My Oracle Support Banner

XML Import in P6 Web Using a SQL Server Database Fails When the Project ID Contains a Closing Square Bracket (Doc ID 2513096.1)

Last updated on DECEMBER 04, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8.5.0 to 18.8.7.0 [Release 18.8]
Primavera P6 Enterprise Project Portfolio Management - Version 18.8.5.0 to 18.8.7.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

When importing an XML file of a project with a Project ID that includes a closing square bracket ( ] ) in P6 Web connected to a Microsoft SQL Server database, the import fails and the following error occurs:

<file name> is not a valid XML file

 

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

  1. Create a new project with a Project ID containing the ] character at the end.
  2. Export the project in P6 XML file format.
  3. Import the file in P6 Web.
  4. Note the reported error when selecting the XML file.

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.