Support Article
Timeout issue with BIX extraction
SA-45712
Summary
Business Information Exchange (BIX) extraction's 'Generated SQL' is going timed out with Pega 7.2.2.
Error Messages
SELECT COUNT("PC0"."pzInsKey") AS "pySummaryCount(1)" FROM PEGA_DATA.pc_InvestDepositApp_Work "PC0" WHERE ( "PC0"."pzInsKey" LIKE ? AND "PC0"."pxCommitDateTime" >= ? AND "PC0"."pxCommitDateTime" < ? )
com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
Steps to Reproduce
1.Create a BIX extract rule on work class which is of type - 'Class Group'. So the filter condition will be generated on pzInsKey column with Like clause, instead of pxObjClass column.
2. Do not select 'Skip standard order by clause' under 'Filter Criteria' tab.
2. Have more number of work objects to get extracted.
3. Run the extract rule.
4. Check the Pega RULES/ Pega BIX logs for the above error.
Root Cause
Since there are more number of work objects and also filtering is enabled by default.
Resolution
Enable 'Skip standard order by clause' under 'Filter Criteria' tab and create indexes for the work object tables columns to resolve the issue.
Published March 22, 2018 - 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.