My Oracle Support Banner

PDS Query Fails With "(500) "Web.Contents Internal Server Error" (Doc ID 2747369.1)

Last updated on JANUARY 29, 2021

Applies to:

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

Symptoms

After GBUCS customer was upgraded to 19.12.9, not able to run queries in PDS.


URL = "https://<url>/sync/rest-service/dataservice/runquery?configCode=<data service admin user>",
cred64 = "Basic VXdpbGxlOlBhc3N3b3JkMQ==",
query = "{""name"":""UDFTYPEID"",""tables"":[{""tableName"":""UDFTYPE"",""columns"":[""UDF_TYPE_ID""]," &
"""condition"":{""operator"":""AND"",""conditions"":[" &
"{""columnName"":""UDF_TYPE_LABEL"",""operator"":""EQUALS"",""value1"":""Part Number""}," &
"{""columnName"":""TABLENAME"",""operator"":""EQUALS"",""value1"":""TASK""}" &
"]}}]}",
Options = [Headers = [#"Content-Type"="application/json", #"Authorization" = cred64], Content=Text.ToBinary(query)],
web = Web.Contents(URL,Options),
result = Json.Document(web),
data = result[data]

Results in error:  (500)  "Web.Contents": Internal Server Error

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!


In this Document
Symptoms
Cause
Solution


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