Question
Scotiabank
CO
Last activity: 2 Apr 2025 15:24 EDT
BIX Extract rule not working after migrating to Pega Infinity 24.1.2 (Output to Database Schema)
Hi Everyone,
We use to have the same EXTRACT rule in our previous Pega 7 version, this rule is configured to Database Schema, but now when running this rule in Pega infinity we getting the following error for multiple properties:
"com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=<Property_Name>"
This is occurring on the insert statement to the database.
Please do let me know if any idea on what we missing.
Accepted Solution
Updated: 2 Apr 2025 15:24 EDT
HCA Healthcare
US
@Mateo Rojas The error you're encountering likely occurs because the database schema has changed or there are mismatched property-to-column mappings after migrating to Pega Infinity 24.1.2. First, ensure that the columns in the database schema match the properties in your BIX Extract rule. Double-check the property-to-column mappings to ensure they’re correct. Also, verify that the database columns are named correctly, considering any case-sensitivity issues in DB2. If properties have been renamed or removed during the migration, update the mappings accordingly. Review the Pega logs for detailed error messages about the problematic properties. Ensure the database version is compatible with Pega Infinity and that there are no configuration changes affecting the BIX rule. If the issue persists, consider reaching out to Pega support with logs for further assistance.