Actuals dataset synchronization fails in UAT
The Actuals dataset synchronization in UAT fails with an error.
java.util.concurrent.ExecutionException: com.pega.decision.vbd.VBDException: java.sql.SQLSyntaxErrorException: ORA-00904: "A"."PZLBLBCKUPID": invalid identifier
Steps to Reproduce
Click the Actuals dataset synchronization button.
A defect in Pegasystems’ code or rules.
After clicking the Synchronize button, the Visual Business Director (VBD) generates an SQL to query tables. To build this query, the VBD searches the database for tables with the pr_data_ih_dim_<name> prefix.
A set of tables with the prefix are present out-of-the-box (pr_data_ih_dim_channel, pr_data_ih_dim_application and so on).
The synchronization fails when the user backs up one of these tables using the same prefix. In this scenario, the user has taken the backup and named it as PR_DATA_IH_DIM_ACTION_LBLBCKUP, which resulted in the error.
Perform the following local-change:
Drop or rename the additional tables (which are not out-of-the-box and which are backed up by user) such that the PR_DATA_IH_DIM_ prefix is not used.