The 'Publish Audit Data' Global Scheduled Service Fails with Error 'Invalid length parameter passed to the LEFT or SUBSTRING function' for a SQL Server Database
(Doc ID 2632974.1)
Last updated on MARCH 18, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
When running the Publish Audit Data Global Schedule Service for a P6 database hosted in a Microsoft SQL Server instance, the job fails and the following error occurs in the log file.
[TASK]:[PxAuditServiceTaskImpl]:  CORE(BRE): Executing: px_audit_demand...
SEVERE: [TASK]:[PxAuditServiceTaskImpl]:  CORE(BRE): Invalid length parameter passed to the LEFT or SUBSTRING function.
The issue can be reproduced at will with the following steps:
- Run the Publish Audit Data Global Scheduled Service on a SQL Server database.
- The job fails.
- View the reported error in the job's log file.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!