Support Article
Exception on running Business Intelligence Exchange agents
SA-89394
Summary
Exception occurs on running Business Intelligence Exchange (BIX) agents. The extraction is incomplete. The issue occurs intermittently.
Error Messages
Exception at 20190816T040312.563 GMT: pega.pegarules.pub.PRRuntimeException: Unable to process EXTRACT-RULE-NAME at pega.pegarules.data.internal.access.ExtractImpl.parseAndRunExtractCommand(ExtractImpl.java:850)at pega.pegarules.data.internal.access.ExtractImpl.executeCommandLineExtract(ExtractImpl.java:759) at pega.pegarules.data.internal.PRDataProviderImpl.executeCommandLineExtract(PRDataProviderImpl.java:1548)at pega.pegarules.session.internal.mgmt.Executable.executeCommandLineExtract(Executable.java:8484)at pegarules.generated.activity.ra_action_pxextractdatawithargs_70c7b1a10890f90316470d704198da0c.step2_circum0(ra_action_pxextractdatawithargs_70c7b1a10890f90316470d704198da0c.java:314) pegarules.generated.activity.ra_action_pxextractdatawithargs_70c7b1a10890f90316470d704198da0c.perform(ra_action_pxextractdatawithargs_70c7b1a10890f90316470d704198da0c.java:87)
Steps to Reproduce
Run the BIX extraction.
Root Cause
The filter criteria for the BIX extract contains wildcard usage by using Contains (Property name, text). When the extract starts, the engine must query the database for a list of records which fulfil the filter criteria. Since Contains was used, the database query uses the Where clause of propertyColumn LIKE '%TEXT%'. The Where clause is unable to take advantage of the index. The query times out due to poor performance. As the database grows the issue grows worse though the extract sizes remain roughly the same.Resolution
Perform the following local-change:
Use Starts With instead of Contains for the BIX extraction filter criteria that allows the database to construct a Like clause which can take advantage of the indexes built on the column.
(Propertyname) STARTS WITH (text)
becomes
propertyColumn LIKE 'text%'
Published October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.