My Oracle Support Banner

Error: "Invalid Parameters Requested" When Attempting to Run a Report in P6 and the Bi Publisher Log Shows ASCII Code Instead of a Comma in the Returned Value (Doc ID 2368739.1)

Last updated on APRIL 04, 2018

Applies to:

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

Symptoms

When attempting to run a report in P6 and selecting a project code value that contains a comma, the following errors occur:

ERRORS
P6 On Screen:
Errors have been encountered while running the report. To resolve, contact your administrator.

P6 Web Access log:
"Invalid parameters requested"

BI Publisher log:
Illegal parameter value: "<parameter>=<result showing &#44; instead of a comma>"
Example: "p_code_val__Location=Pennsylvania&#44; PA"

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

  1. Log-in to P6 Web
  2. Create a Project Code
  3. Create a Project Code Value that contains a comma in it (Example: "Pennsylvania, PA")
  4. Assign the project code value to a project
  5. Publish the global services (specifically Enterprise Data)
  6. Publish the project
  7. Setup a data model with the List of Value looking for the Project Code:
    (Example:
    select "P6PROJECTCODE"."CODEVALUE" as "CODEVALUE"
     from "PXRPTUSER"."P6PROJECTCODE" "P6PROJECTCODE"
     where "P6PROJECTCODE"."CODETYPENAME" = '<Project Code created for the test>')
  8. Create a basic report, generated from the data model
  9. Run the report from BIP selecting the value with the comma, successful
  10. Run the report from P6 selecting the value with the comma, failure
  11. Check P6 and bipublisher.log for errors

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.