When clicking on ‘Create New Container’ or ‘Edit Container' and select a new substance from ACX, the following error occurs:OraOLEDBerror '80040e14'ORA-00600: internal error code, arguments: [kkqsadjo-1], [], [], [], [], [], [], [] ORA-06512: at "CHEMINV

Created
October 08, 2021 23:00

Date Posted: 2013-12-11
Product: ChemBioOffice Enterprise

Problem:

When clicking on ‘Create New Container’ or ‘Edit Container' and select a new substance from ACX, the following error occurs: OraOLEDBerror '80040e14' ORA-00600: internal error code, arguments: [kkqsadjo-1], [], [], [], [], [], [], [] ORA-06512: at "CHEMINVDB2.COMPOUNDS", line 362 ORA-06512: at line 1 /cheminv/api/createsubstanceOraSP.asp, line 47

Solution:

From Oracle Metalink Try disabling Query Rewrite; SQL> alter system flush shared_pool; --->>> needed to reparse the statement!!! SQL> alter session set query_rewrite_enabled = false; SQL> You can use it at system level too, setting the following parameter in the pfile query_rewrite_enabled = false