SEVERE: An Error Occurred While Dropping License Records while running P6 Web Services (Doc ID 2307517.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Primavera Web Services - Version 16.1.6.0 and later
Information in this document applies to any platform.

Symptoms

On : 16.1.6.0 version, Business Objects

When running P6 Web Services, the following error occurs.

ERROR
-----------------------
com.primavera.infr.srvcs.LicenseServiceImpl$DropLicensesJob error
SEVERE: An error occurred while dropping license records.
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.primavera.infr.db.PStatement.executeUpdate(PStatement.java:163)
at com.primavera.infr.srvcs.LicenseServiceImpl$DropLicensesJob.execute(LicenseServiceImpl.java:912)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:320) at java.lang.Thread.run(Thread.java:745)
<Error>
<com.primavera.infr.srvcs.LicenseServiceImpl$DropLicensesJob> <BEA-000000>
<An error occurred while dropping license records.
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
Truncated. see log file for complete stacktrace> "

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Due to this issue, users have larger logs full of errors.

NOTE: This does not cause a P6 Web Services interruption. However the error can be thrown hundreds or thousands of times in a short period making the logs full of irrelevant errors making it harder to trouble shoot others.

 

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