Support Article
BIX extract fails when class instances map to external DB table
SA-42072
Summary
The Business Intelligence Exchange (BIX) extract fails when class instances (extracted using BIX) map to a table in an external database.
Error Messages
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DATA.PR_EXTRACT_TIME, DRIVER=4.19.26
Steps to Reproduce
1. Create a class that maps to a table in an external database
2. Create an Extract rule for the class and check the ‘Use last updated time as start’ option
3. Run the Extract
Root Cause
A defect in Pegasystems’ code or rules. The incorrect data source was used to update the table, pr_extract_time.
When running the extract to query the table, pr_extract_time, the external database connection was used instead of PegaDATA.
Resolution
Apply HFix-36400Published September 25, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.