Primavera Data Service (PDS) Perfromance is Slow for Some Tables (Doc ID 2893642.1)

Last updated on SEPTEMBER 29, 2022

Applies to:

Symptoms

When attempting to retrieve audit details for P6 using PDS, the following error occurs or the query takes a long time to run e.g 40s to over a minute.

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 Audit table. For example,

https://p6.oraclecloud.com/<SERVICE_INSTANCE>/sync/rest-service/dataservice/runquery?configCode=ds_p6adminuser
{
    "name": "Test",
    "pageSize": "9999",
    "nextTableName": null,
    "nextKey": 0,
    "tables": [
        {
            "tableName": "PAUDITX",
            "columns": [
                "TABLE_NAME",
                "TAB_PRIMARY_KEYS",
                "TAB_COL_NAME",
                "OLD_VALUE",
                "AUDIT_TS",
                "OPER",
                "PROJ_ID"
            ],
            "condition": {
                "operator": "AND",
                "conditions": [
                    {
                        "columnName": "AUDIT_TS",
                        "operator": "GREATER_THAN_OR_EQUALS",
                        "value1": "2022-06-02 12:10:11 +00:00"
                    },
                    {
                        "columnName": "TABLE_NAME",
                        "operator": "EQUALS",
                        "value1": "TASKRSRC"
                    },
                    {
                        "columnName": "OPER",
                        "operator": "EQUALS",
                        "value1": "D"
                    },
                    {
                        "columnName": "TAB_COL_NAME",
                        "operator": "IN",
                        "value1": "task_id,taskrsrc_id,proj_id,act_end_date,reend_date,remain_qty,rsrc_id,rsrc_type,act_start_date,restart_date"
                    }
                ]
            }
        }
    ]
}

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.