My Oracle Support Banner

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:

Primavera Unifier Cloud Service - Version 20.12 and later
Information in this document applies to any platform.


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.

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.

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": [


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

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