My Oracle Support Banner

Error "INVALID OBJECT NAME 'JOBSVCWITH'" Attempting to Export Project XML and 'Store Files in Database' Option Is True on MS SQL Server Database (Doc ID 3019843.1)

Last updated on MAY 08, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 23.12.1.0 to 23.12.3.0 [Release 23.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 24.1 to 24.3 [Release 24.1 to 24.3]
Information in this document applies to any platform.

Symptoms

When Exporting Project XML and the setting "Store files in database" is True, and the database server platform is MS SQL Server, the export fails and the following error is written to the Job Service log:

Failure Executing Export Project service job, with the caused by field: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'jobsvcWITH'.

 

The issue can be reproduced at will using the following steps:

  1. Access the P6 Administrator application using ONE of the following methods:
    • In a web browser, go to http://<P6 EPPM server>:<P6 Web port>/p6/action/adminconfig (ex. http://example.com:8203/p6/action/adminconfig) and login with a P6 admin-superuser account.
    • As an administrator on the P6 EPPM application server, navigate to the <P6 EPPM home>\p6 directory (ex. C:\P6EPPM_1\p6), launch adminpv.cmd, and login with the privileged schema user (default privuser) credentials.
  2. Expand the (current P6 configuration) > Services > Job Services > Import/Export > Import/Export Options section.
  3. Triple-click the Store Files In Database field to modify it, and check the box.
  4. Click Save Changes and close the P6 Administrator.
  5. Log-in into P6 and open a Project.
  6. Export the Project in XML or Microsoft Project format.
  7. Observe the reported error in the failed job log.

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.