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 to [Release 19.12]
Primavera Unifier - Version to [Release 19.12]
Information in this document applies to any platform.


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.

"String index out of range: ‐8"

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

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


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


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.