My Oracle Support Banner

Error: "Invalid Length Parameter Passed To The LEFT Or SUBSTRING Function" Executing Publish Audit Global Scheduled Service Using SQL Server Database (Doc ID 2360727.1)

Last updated on APRIL 27, 2018

Applies to:

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

Symptoms

When using a SQL Server project management database and running the Global Schedule Service Publish Audit Data, it fails with the following error:

ERROR
Publish Audit Data Log:
2018-01-23 00:03:27:[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): Executing: px_audit_demand...
SEVERE: 2018-01-23 00:03:27:[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): Invalid length parameter passed to the LEFT or SUBSTRING function.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid length parameter passed to the LEFT or SUBSTRING function.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
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.execute(SQLServerPreparedStatement.java:320)
at com.primavera.infr.db.PPreparedStatement.execute(Unknown Source)
at com.primavera.px.audit.PxAuditServiceTaskImpl.execute(Unknown Source)
at com.primavera.px.audit.PxAuditServiceTaskImpl.execute(Unknown Source)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)


STEPS TO REPRODUCE

  1. Configure the "Publish Audit Data" global service to run.
  2. View the log file of the "Publish Audit Data" job.
  3. Note the error "Invalid length parameter passed to the LEFT or SUBSTRING function."

Changes

 

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!


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