Have run hundreds of transactions updating this database and suddenly this error has arisen on a number of update:
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Internal error -1214 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmKeyDelete called from ix_delete on PUB.JobOper for PUB.WIJobAsmDue. Save log for Progress technical support.
The application is written in MS VB6, the ODBC connection isthe SQL-92 Merant driver. The database tables are from the Epicor/Vantage application.
The UPDATE syntax has not changed in 6 months, and at first I thought this was due to an invalid field type. On further examination I find that the WI (What If) tables are empty and not being used in this application, and that any delete function mentioned in the error would normally not make a hit.
Any suggestions would be appreciated. Thanks, Stan
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Internal error -1214 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmKeyDelete called from ix_delete on PUB.JobOper for PUB.WIJobAsmDue. Save log for Progress technical support.
The application is written in MS VB6, the ODBC connection isthe SQL-92 Merant driver. The database tables are from the Epicor/Vantage application.
The UPDATE syntax has not changed in 6 months, and at first I thought this was due to an invalid field type. On further examination I find that the WI (What If) tables are empty and not being used in this application, and that any delete function mentioned in the error would normally not make a hit.
Any suggestions would be appreciated. Thanks, Stan