CISPro has been upgraded from (for example) version 2020 to 2022. BIOVIA Direct 2020 has been replaced by Direct 2022 and the Direct 2022 synonyms were setup 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.
Error Message:
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;