Error: 'ORA-01489: Result of String Concatenation Is Too Long' When Attempting to Query a Data View via Primavera Data Services (PDS) (Doc ID 2877146.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Symptoms

When attempting to query a data view via PDS, the following error is returned. When running the data view within the Unifier UI, the results are returned without error.

ERROR
-----------------------
The remote server returned an error: (500) Internal Server Error.

ORA-12801: error signaled in parallel query server P000, instance iad0152-a-tvlen1:IAD0152A1 (1)\nORA-01489: result of string concatenation is too long\n" occurs.

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

1. Using PDS, run the request:
{
  "name": "Test",
  "pageSize": "100",
  "tables": [
  {
  "tableName": "unifier__<view name>",
  "columns": [
  "project_id",
  "projectnumber",
  "projectname",
  "id",
  "record_no",
  "workflow_name",
  "title",
  "recipients",
  "attachments"
  ]
  }
  ]
}

Cause

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