AnsweredAssumed Answered

Some Projects can not be saved in CA PPM 14.3 SP1 or in Open Workbench. Deadlocks in Task and Assignments

Question asked by Thelem-ppm on Nov 7, 2017
Latest reply on Feb 2, 2018 by Thelem-ppm

Hi everyone,

 

We got some issues when we want to save some projects in CA PPM 14.3 SP1 or in Open Workbench since two weeks.

 

We have to kill Open Workbench session when it happens but updates are not saved, and in CA PPM the saving function loops without updating projects. The oracle SQL transaction is running during some hours after trying to save our updates.

 

We restart CA PPM services every night, sometimes projects can be saved the next day and sometimes not...

 

We found nothing in PRLOCK table, and we got no idea why it happens and how resolve this problem.

 

We got this sort of errors in app.log :

 

ERROR 2017-10-20 09:46:07,275 [http-nio-443-exec-95] xql2.rule (clarity:info0771:7809055__C6034FF8-D6CC-46BD-BEEF-C89C3754EEE2:npt.gridUpdate) InvInvestmentsRule.updateProxyTasks
java.lang.NullPointerException
at com.niku.xql2.pmd.rules.INVInvestmentsRule.updateProxyTasks(INVInvestmentsRule.java:686)
at com.niku.xql2.pmd.rules.INVInvestmentsRule.onPostUpdate(INVInvestmentsRule.java:593)
at com.niku.xql2.odf.ODFRecord.update(ODFRecord.java:267)
at com.niku.xql2.handlers.UpdateHandler.postProcess(UpdateHandler.java:103)
at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1419)
at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

 

and then

 

ERROR 2017-10-20 13:43:29,745 [http-nio-443-exec-22] niku.schedulers (clarity:info0776:7811048__20A50703-5A42-4333-B9EC-7BA8284146D9:schedulers.postProject) Rolling back transaction:
com.niku.union.persistence.PersistenceException:
SQL error code: 0
Error message: [CA Clarity][Oracle JDBC Driver]Operation cancelled by user request.
Executed:
select a.*
, r.resource_type
, tm.prid teamId
from prassignment a
, prteam tm
, srm_resources r
, prtask t
where t.prprojectid=?
and a.prtaskid=t.prid
and r.id=a.prresourceid
and tm.prid = a.team_id and r.resource_type=?
Derived from statement:

 

and yesterday :

 

ERROR 2017-11-06 11:44:32,271 [http-nio-443-exec-1689] niku.schedulers (clarity:info0653:7874055__FF91E59A-C310-4D43-8110-D0410FCFAB65:schedulers.postProject) Rolling back transaction:
com.niku.union.persistence.DBConnectionException: java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver]Internal error: Net8 protocol error.
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2111)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2823)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:869)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:769)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:577)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:307)
at com.niku.xql2.pmd.PMDRecordSet.executePMDStatement(PMDRecordSet.java:267)
at com.niku.xql2.pmd.PMDRecordSet.<init>(PMDRecordSet.java:87)
at com.niku.xql2.pmd.PMDDataSource.select(PMDDataSource.java:94)
at com.niku.xql2.pmd.rules.InvestmentTSVController.getInvestmentAssignments(InvestmentTSVController.java:948)

 

Did anyone got any idea for resolving our issue ? Help will be appreciated, thank you.

 

Regards,

 

Ebubekir

Outcomes