Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Actuals dataset synchronization fails in UAT

SA-106374

Summary



The Actuals dataset synchronization in UAT fails with an error. 


Error Messages



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.


Root Cause



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.


Resolution



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.
Suggest Edit

Published June 12, 2020 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us