Support Article

BIX trying to write to wrong schema of target database

SA-34156

Summary



User has created a extract rule by configuring the database table present in new schema (otherthan pegarules and pegadata schemas) and while run the extract rule, the system throws error saying that the table is not present in the target database.
For testing, they have created a similar table in pegadata schema, it extracted successfully. But the same is not working with table in new schema.

User has verified the PDN and found the below article:
https://pdn.pega.com/support-articles/bix-trying-write-wrong-schema-target-database

User requires the hotfix "HFix-21237" to fix this issue in Pega 7.1.7.


Error Messages



Error: table not present in the target database


Steps to Reproduce



For testing Pega GCS created a extract rule by configuring the database table present in new schema (other than Pegarules and Pegadata schemas) and while run the extract rule, the system throws error saying that the table is not present in the target database.


Root Cause



Data Source configuration for target database missing in config file. This is required to insert the Business Intelligence Exchange (BIX) extract data to target database.

Resolution



Add the target database details in prconfig file, to resolve the issue.

Published February 24, 2017 - Updated March 15, 2017

Have a question? Get answers now.

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