IBM Support

Internal Query Processor Error when deleting a record

Troubleshooting


Problem

An error is displayed in IBM i2 iBase when trying to delete or update a record.

Symptom

error message displayed :
(French)
Erreur interne du processus de requêtes : le processeur de requêtes a
rencontré une erreur inattendue pendant l'exécution.
(English)
Internal Query Processor Error: The query processor encountered an
unexpected error during execution.

And details :
An error #3092 occured in:
Microsoft OLE DB Provider for SQL Server.
idDBEngine:ExecuteSQL
idDatabase:CDBRecord:Delete


Cause

http://support.microsoft.com/kb/258198
It's a Microsoft SQL Server bug

Resolving The Problem

1- Open iBase Designer
2- Alter the Entity or Link type to remove the Indexes on the fields.
(to remove the Indexes, the fields must not be Discriminators)
3- Close iBase Designer and open iBase User
4- Try to delete the records and see if this works
5- If yes, go back to iBase designer, and reactivate the Indexes and the Discriminator fields

[{"Product":{"code":"SSXW43","label":"i2 iBase"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.9;8.9.1;8.9.5","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

More support for:
i2 iBase

Software version:
8.9, 8.9.1, 8.9.5

Operating system(s):
Windows

Document number:
710195

Modified date:
21 June 2018

UID

swg21689233

Page Feedback