CISPro and Direct have been upgraded, for example from version 2020 to 2022. The new Direct username has been defined in CSWConfigUX.exe and the Direct 2022 synonyms were setup on the CISPro schema using the command: execute c\$direct2022.mdlauxop.setup
CISPro appears to be functioning until attempting to upload a structure (mol file) to a chemical. At this point an error occurs and the structure cannot be uploaded.
Invalid mol file: An internal error occurred: Error updating table identified as NodePropMol.setMol_mol_data_2_64476c36-6393-4931-b223-faa5f0236174 with the following SQL: insert into mol_data (moldataid,isdirectcompatible,jctnodepropid,nodeid,fingerprintfailed,modified,jobid,originalmol,CTAB,ORIGINALCDX) values(:moldataid,:isdirectcompatible,:jctnodepropid,:nodeid,:fingerprintfailed,:modified,:jobid,:originalmol,:CTAB,:ORIGINALCDX); the exception thrown was:ORA-29881: failed to validate indextype; Exception occurred in CswCommon: at ChemSW.RscAdo.CswDataAdapter.Update(DataTable DataTable) in C:\buildarea\cispro\Common\CswCommon\Csw\Ado\CswDataAdapter.cs:line 305 at ChemSW.DB.CswTableUpdate.update(DataTable DataTable, Boolean AllowAuditing) in C:\buildarea\cispro\Common\CswCommon\Csw\DB\CswTableUpdate.cs:line 418 at ChemSW.Nbt.PropTypes.CswNbtNodePropMol._saveMolData(String MolString, Byte[] cdxData) in C:\buildarea\cispro\nbt\nbt\NbtLogic\csw\PropTypes\CswNbtNodePropMol.cs:line 328; at ChemSW.RscAdo.CswDataAdapter.Update(DataTable DataTable) in C:\buildarea\cispro\Common\CswCommon\Csw\Ado\CswDataAdapter.cs:line 305 at ChemSW.DB.CswTableUpdate.update(DataTable DataTable, Boolean AllowAuditing) in C:\buildarea\cispro\Common\CswCommon\Csw\DB\CswTableUpdate.cs:line 418 at ChemSW.Nbt.PropTypes.CswNbtNodePropMol._saveMolData(String MolString, Byte[] cdxData) in C:\buildarea\cispro\nbt\nbt\NbtLogic\csw\PropTypes\CswNbtNodePropMol.cs:line 328;