Traditional STARETL Fails With the Following Error - ORA-28132: The MERGE INTO syntax does not support the security policy
(Doc ID 2925033.1)
Last updated on FEBRUARY 01, 2023
Applies to:
Primavera Data Warehouse - Version 19.12.3.0 and laterPrimavera Analytics - Version 21.12 and later
Information in this document applies to any platform.
Symptoms
When attempting to execute the traditional staretl,
the following error occurs.
ERROR
-----------------------
2023-01-26 14:29:31.804 [main] INFO ETL.Message - === Step 12, Part 1 ====================================================
2023-01-26 14:29:31.805 [main] INFO ETL.Message - === Validate Meta Data Syntax (metadata\validate_work_down_update_stmts.sql)
2023-01-26 14:29:32.280 [Thread-2] INFO ETL.Message - declare
2023-01-26 14:29:32.281 [Thread-2] INFO ETL.Message - *
2023-01-26 14:29:32.282 [Thread-2] INFO ETL.Message - ERROR at line 1:
2023-01-26 14:29:32.282 [Thread-2] INFO ETL.Message - ORA-28132: The MERGE INTO syntax does not support the security policy.
2023-01-26 14:29:32.282 [Thread-2] INFO ETL.Message - ORA-06512: at "STARUSER.WORKDOWN_UPDATE", line 1426
2023-01-26 14:29:32.284 [Thread-2] INFO ETL.Message - ORA-06512: at line 4
2023-01-26 14:29:32.288 [main] INFO ETL.Progress - Step 12/78 Part 1/1 - FAILED (28132) (0 hours, 0 minutes, 1 seconds, 569 milliseconds)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute the staretl.bat.
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 |