Primavera Data Service (PDS) Error "Gateway Timeout" Occurs After Query Runs for 2 Minutes (Doc ID 2951643.1)

Last updated on JUNE 15, 2023

Applies to:

Symptoms

When attempting to run a query using Primavera Data Service (PDS), the following error occurs after 2 minutes.

ERROR
-----------------------
Gateway Timeout - In read
Gateway Timeout
The proxy server did not receive a timely response from the upstream server.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run a PDS request to get data from the P6 TASKACTV. For example,

https://p6.oraclecloud.com/<SERVICE_INSTANCE>/sync/rest-service/dataservice/runquery?configCode=ds_p6adminuser

{
    "name": "TASKACTV",
    "tables": [
        {
            "tableName": "TASKACTV",
            "columns": [
                "TASK_ID",
                "ACTV_CODE_ID",
                "ACTV_CODE_TYPE_ID",
                "CREATE_DATE",
                "CREATE_USER",
                "DELETE_SESSION_ID",
                "PROJ_ID",
                "DELETE_DATE",
                "UPDATE_DATE",
                "UPDATE_USER"
            ],
            "condition": {
                "operator": "AND",
                "conditions": [
                    {
                        "columnName": "ACTV_CODE_TYPE_ID",
                        "operator": "BETWEEN",
                        "value1": "30563",
                        "value2": "30570"
                    }
                ]
            },
            "orderByColumns": [
                "TASK_ID",
                "ACTV_CODE_ID",
                "ACTV_CODE_TYPE_ID"
            ]
        }
    ]
}

Changes

Cause

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