My Oracle Support Banner

Errors In Data Tables When Importing Unifier Data To A Third Party Interface: String index out of range and/or ORA-* (Doc ID 2741999.1)

Last updated on JANUARY 07, 2021

Applies to:

Primavera Unifier Cloud Service - Version 20.11 to 20.11 [Release 20.11]
Primavera Unifier Cloud Service - Version 19.12.10.0 to 19.12.11.0 [Release 19.12]
Primavera Unifier - Version 19.12.10.0 to 19.12.11.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

After exporting data from Unifier and trying to import it into a third-party interface:

1. When trying to import the data from Unifier to another system there is an issue with what looks like a schema change to the table where it is causing a failure.

ERROR
-----------------------
"String index out of range: ‐8"

2. When trying to import data from Unifier to a table or view, the following error occurs.

ERROR
-----------------------
"ORA‐01446: cannot select X from, or sample, a view with DISTINCT, GROUP BY, etc.\n"

and/or

"ORA-01445: cannot select X from, or sample, a join view without a key-preserved table\n"

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
References


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