Project and Portfolio Management Practitioners Forum
cancel

Getting Constraint violation error while creating projects

SOLVED
Go to solution
Highlighted
kndlny
Super Contributor.

Getting Constraint violation error while creating projects

Hi,

 

We are using PPM v9.10.

 

We have a request type(lets say X) and 4 project types(they all have unique request types lets say A,B,B,D) which can be created from this request type.

 

Thus, X can create A,B,C or D

 

There were no problem with project creation before.

 

However, after we have done deployment (four request types related with the four project type have been deployed A,B,C,D)

 

and suddenly we start to get the fallowing error during project creation:

 


Exception Correlation: GUID=8B72F8A3-7BB6-ECCF-FFC9-D8FD6A2F1184
Generated Time=2012/12/12-14:14:23.500 GMT+02:00
Server Node Name: HPPPM
nested detail:An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

Exception Correlation: GUID=5584B7E2-6BFB-44ED-5669-AB027D4A4892
Generated Time=2012/12/12-14:14:23.495 GMT+02:00
Server Node Name: HPPPM

Exception Correlation: GUID=32F63A30-9F76-5AA2-1F97-6D36448FFA2E
Generated Time=2012/12/12-14:14:23.497 GMT+02:00
Server Node Name: HPPPM



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

Exception Correlation: GUID=8B72F8A3-7BB6-ECCF-FFC9-D8FD6A2F1184
Generated Time=2012/12/12-14:14:23.500 GMT+02:00
Server Node Name: HPPPM
    at com.kintana.crt.util.PMRequestUtils.create(PMRequestUtils.java:385)
    at com.mercury.itg.util.integration.RequestUtils.createRequest(RequestUtils.java:186)
    at com.mercury.itg.util.integration.ProjectUtils.createProject(ProjectUtils.java:253)
    at com.mercury.itg.util.integration.ProjectUtils.createProject(ProjectUtils.java:112)
    at com.kintana.core.server.execution.CreateProject.createProject(CreateProject.java:137)
    at com.kintana.core.server.execution.CreateProject.execute(CreateProject.java:214)
    at com.kintana.core.server.execution.CommandExecutionAgent.doExecuteCommands(CommandExecutionAgent.java:826)
    at com.kintana.core.server.execution.CommandExecutionAgent.executeCommands(CommandExecutionAgent.java:713)
    at com.kintana.core.server.execution.BaseExecutionManager.executeBatchForRegularExecution(BaseExecutionManager.java:1162)
    at com.kintana.core.server.execution.BaseExecutionManager.executeBatch(BaseExecutionManager.java:1093)
    at com.kintana.core.server.execution.BaseExecutionManager.run(BaseExecutionManager.java:841)
Caused by: An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

Exception Correlation: GUID=5584B7E2-6BFB-44ED-5669-AB027D4A4892
Generated Time=2012/12/12-14:14:23.495 GMT+02:00
Server Node Name: HPPPM

Exception Correlation: GUID=32F63A30-9F76-5AA2-1F97-6D36448FFA2E
Generated Time=2012/12/12-14:14:23.497 GMT+02:00
Server Node Name: HPPPM
    at com.kintana.crt.util.PMRequestUtils.save(PMRequestUtils.java:692)
    at com.kintana.crt.util.PMRequestUtils.create(PMRequestUtils.java:382)
    ... 10 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PPMPROD.KCRT_FG_PFM_PROJECT_U2) violated

    at com.kintana.core.db.pool.PooledPreparedStatement.executeUpdate(PooledPreparedStatement.java:177)
    at com.kintana.core.util.AgentUtils.executePreparedStatements(AgentUtils.java:169)
    at com.kintana.core.util.AgentUtils.executePreparedStatements(AgentUtils.java:85)
    at com.kintana.core.server.FieldGroupAgent.saveRequestFieldGroupDetails(FieldGroupAgent.java:341)
    at com.kintana.crt.server.RequestDBAdapterImpl.saveOnly(RequestDBAdapterImpl.java:411)
    at com.kintana.crt.server.RequestDBAdapterImpl.saveNoCommit(RequestDBAdapterImpl.java:365)
    at com.kintana.core.arch.DBAdapter.saveWrapper(DBAdapter.java:131)
    at com.kintana.core.arch.Home.save(Home.java:173)
    at com.kintana.crt.bean.UserRequest.save(UserRequest.java:309)
    at com.kintana.crt.bean.UserRequest.save(UserRequest.java:294)
    at com.kintana.crt.util.PMRequestUtils.save(PMRequestUtils.java:675)

We have checked the kcrt_fg_pfm_project index and the related unique constraint is about financial summary. But we are not using financial management in our project.

 

PS. There is no problem with the requests(X) created after deployment is done. Problem occurs only for the requests(X) that are created before deployment(for A,B,C,D) is done.

 

Thanks

1 REPLY
kndlny
Super Contributor.
Solution

Re: Getting Constraint violation error while creating projects

Hi again,

 

It seemed like we had rows which have not converted to the project in that table.

 

We have come up with two possible solutions.

 

Either setting the related constraint to nonunique or removing the related row in the kcrt_fg_pfm_project table.

 

We have prefered the second solution which seemed less risky.