Unable to Delete EPS Nodes (Doc ID 2197199.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.4.10.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.4.10.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to Delete EPS nodes, the action is in progress for a long time, then fails with a pending status.  Nothing is actually deleted.

In the P6WebAccess log, the following error message is logged:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
at com.microsoft.sqlserver.jdbc.TDSCommand.checkForInterrupt(IOBuffer.java:4214)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:70)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1449)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms