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 188.8.131.52 to 184.108.40.206 [Release 19.12]
Primavera Unifier - Version 220.127.116.11 to 18.104.22.168 [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