My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.