The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

MERCURY.KCRT_REQUEST_UTIL ORA-06512

Highlighted
caccade3532
Acclaimed Contributor

MERCURY.KCRT_REQUEST_UTIL ORA-06512

 

When updating PPM demand management, got following error occationally. Did anybody face the same issue? Any hint would be appreciated. Thanks in advance.

 

An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

Exception Correlation: GUID=89B9A746-24D5-5883-E88F-F53AE20381C3
Generated Time=2012/06/18-15:46:05.705 CDT
Server Node Name: kintana
 

ORA-01001: invalid cursor
ORA-06512: at "MERCURY.KCRT_REQUEST_UTIL", line 236
ORA-06512: at "MERCURY.KCRT_REQUEST_UTIL", line 327

6 REPLIES
caccade3532
Acclaimed Contributor

Re: MERCURY.KCRT_REQUEST_UTIL ORA-06512

BTW, We are using PPM Version 8.00.02. Thanks.
Celil
Esteemed Contributor

Re: MERCURY.KCRT_REQUEST_UTIL ORA-06512

Hi,

Please consult your DB admins and say them cursor of KCRT_REQUEST_UTIL table give failure.



PS: Please keep alive our forum via KUDOS the professionals
Celil

IT Governance Professional
& PPM Solution Architect
philipwood
Regular Collector

Re: MERCURY.KCRT_REQUEST_UTIL ORA-06512

Hi,

 

To gather some info to help you understand the problem:

 

What is located at the lines of code indicated?

 

I.e. if you use your PL SQL Editing environment of choice or sqlplus to look at the package body for MERCURY.KCRT_REQUEST_UTIL, what is located at lines 236 and 327.

 

Is it a cursor definition?

Or the use of a cursor defined elsewhere?

 

Having a look at it might give more meaninful info.

 

BTW: are there any invalid objects in the schema?

 

Maybe an invalidated view or other object is referenced.

 

Regards

 

Philip Wood

TurboMan
Member

Re: MERCURY.KCRT_REQUEST_UTIL ORA-06512

Hi,

 

I would recommend to apply SP3 for 8.0.

 

Celil
Esteemed Contributor

Re: MERCURY.KCRT_REQUEST_UTIL ORA-06512

Hi caccade, Could you please inform us whether our solutions work.
Celil

IT Governance Professional
& PPM Solution Architect
caccade3532
Acclaimed Contributor

Re: MERCURY.KCRT_REQUEST_UTIL ORA-06512

Thanks everybody for your reply and suggestions.  Somehow the issue disappeared.  Hate to see those "self-heeling" things and couldn't find RCA.  Thanks again.

//Add this to "OnDomLoad" event