ETL Fails with Error 'ORA-30004 when using SYS_CONNECT_BY_PATH function, cannot have separator as part of the column'
(Doc ID 2540350.1)
Last updated on OCTOBER 01, 2019
Applies to:Primavera Analytics - Version 18.8 and later
Primavera Analytics Cloud Service - Version 18.8 and later
Primavera Data Warehouse - Version 18.8 and later
Information in this document applies to any platform.
When running the LOAD_PLAN_DAILY procedure, the ETL fails with the following error:
ORA-30004 when using SYS_CONNECT_BY_PATH function, cannot have separator as part of the column.
The issue can be reproduced at will with the following steps:
- Login to the Primavera Cloud Portal Page.
- Open the Analytics Administration page.
- Run the daily load plan.
- Observe the reported error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!