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

Error on PPM 7.5 while executing workItemPendingUpdates

Highlighted
Laure_Juan
Occasional Advisor

Error on PPM 7.5 while executing workItemPendingUpdates

Hello,

We are facing an issue on PPM7.5.

Our environmment is not working because when we try to load a page, we are getting the below error:

An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1738)
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1675)
    at com.kintana.core.util.AgentUtils.runCallableStatement(AgentUtils.java:1642)
    at com.kintana.rsc.server.WorkItemPendingUpdateService.runService(WorkItemPendingUpdateService.java:81)
    at com.kintana.core.server.ServiceController$ServiceThread.run(ServiceController.java:125)

server:Work Item Pending Update Service:com.kintana.core.database:2012/07/23-08:46:00.891 CEST: DB session [poolID=-1,sid=-1,created=null,conn=null] has already been released, but another release was attempted
java.lang.Exception: Session release stack trace
    at java.lang.Throwable.<init>(Throwable.java:67)
    at com.kintana.core.db.DBConnectionBroker.releaseDBSession(DBConnectionBroker.java:479)
    at com.kintana.core.server.ISIntegrityServerImpl.releaseDBSession(ISIntegrityServerImpl.java:1850)
    at com.kintana.rsc.server.WorkItemPendingUpdateService.runService(WorkItemPendingUpdateService.java:118)
    at com.kintana.core.server.ServiceController$ServiceThread.run(ServiceController.java:125)
server:Work Item Pending Update Service:com.kintana.services.workItemPendingUpdates:2012/07/23-08:48:00.962 CEST: An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)
nested detail:DB Package error:

ORA-01422: exact fetch returns more than requested number of rows {KRSC_PROCESS_PENDING_UPDATES-150} (KNTA-10498)

We already try to restart Apache and HP PPM. But one week after we are getting again the same error.

Someone has any idea why we are getting this error?

Thank by advance,

Laure

2 REPLIES
UI-Developer
Acclaimed Contributor

Re: Error on PPM 7.5 while executing workItemPendingUpdates

me also

for more software errors and solutions visit softwareerrors.blogspot.in
AlexSavencu
Honored Contributor

Re: Error on PPM 7.5 while executing workItemPendingUpdates

Hi,

 

I would check the code for the KRSC_PROCESS_PENDING_UPDATES, line 150, just as it is mentioned in the error message.

 

this problem looks like there is a mis-consistency in the database.

 

cheers

alex


--remember to kudos people who helped solve your problem
//Add this to "OnDomLoad" event