PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: I get an Oracle error when we using “Send to Inventory Manager” function.
Topic Summary: OraOLEDB error when adding a substance from ChemACX.
Created On: 11/15/2012 12:43 PM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 11/15/2012 12:43 PM
User is offline View Users Profile Print this message


Aldo

Posts: 41
Joined: 7/11/2011

Question:

I get the error below after I click on the 'Send to Inventory Manager' button.

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




Edited: 12/13/2012 at 4:29 PM by Aldo
 12/13/2012 4:30 PM
User is offline View Users Profile Print this message


Aldo

Posts: 41
Joined: 7/11/2011

Answer:


The following steps have to be applied in the Middle Tier (application server):
1. Connect to the Database as ‘system’

2. Run the following scripts:

GRANT SELECT,INSERT,UPDATE,DELETE ON CHEMINVDB2.INV_VW_COMPOUNDS TO CS_SECURITY WITH GRANT OPTION;

GRANT SELECT,INSERT,UPDATE,DELETE ON CHEMINVDB2.INV_VW_COMPOUNDS TO INV_ADMIN;

GRANT SELECT,INSERT,UPDATE,DELETE ON CHEMINVDB2.INV_VW_COMPOUNDS TO INV_BROWSER;

COMMIT;

3. Perform an iisreset and see if the problem persists.

FuseTalk Basic Edition v4.0 - © 1999-2017 FuseTalk Inc. All rights reserved.