PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: Aparece un error de Oracle cuando uso la función ‘Send to Inventory Manager’
Topic Summary: Error OraOLEDB cuando añado una substancia de ChemACX
Created On: 11/15/2012 1:10 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 1:10 PM
User is offline View Users Profile Print this message


Aldo

Posts: 41
Joined: 7/11/2011

Pregunta:

Tengo el error de abajo después de darle clic al botón de ‘Send to Inventory Manager’

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:29 PM
User is offline View Users Profile Print this message


Aldo

Posts: 41
Joined: 7/11/2011

Respuesta:


Los pasos siguientes deben ser implementados en el Middle Tier (application server):

1. Conectarse a la base de datos como ‘system’

2. Correr los scripts siguientes:

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. Hacer un iisreset y ver si el problema persiste.

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