Question
Hoverstate
SV
Last activity: 22 Mar 2022 12:26 EDT
Pega Extract - No Instance found in the database
Hi everyone. I've been having some issues while trying to do an Extract of a specific Index- table.
I created the class Index-TestClass and records are being created through a Declare Index, there are instances there since I've validated it in Dev Studio, but whenever I try to run my extract rule (Created in the same Index-TestClass class), I get the error message "No Instance found in the database".
I tried using the Filter Criteria "Use last updated time as start", and I also tried adding only a really generic filter just to test (pxCreateDateTime is not null) but I got the same error in both tries. In the BIX Logs I see the following messages whenever I try to run the extract:
Processing extract rule with insKey: *My extract Key*
bix/useHistoryClasses setting has been disabled
Unable to process Index-TestClass: null
# Total Instances Retrieved: 0
Has anyone ever experienced an issue like this one? Is it something from my side while configuring this that might've caused the issue? Thanks in advance!
- Luis Orellana
Pegasystems Inc.
GB
Please try the below:
Create separate tables for the page list property
Can you check to see if you have modified the ootb Validate activity for bix extract?
Also Issue may be due to connection pooling in Weblogic server. Please could you check your full error log stack? Do you see any connection reset errors?
http://www.lkakarla.com/2015/02/weblogic-connection-has-been.html
If you need a more in-depth analysis could I suggest that you log a support Incident and provide PegaRULES and bix logs by enabling debug for below classes
com.pega.pegarules.data.internal.access.BIXSourceSQLGenerator com.pega.pegarules.data.internal.access.ExtractImpl com.pega.pegarules.data.internal.access.ExtractParameters
If you do chose to log a support ticket, please let us know the ticket ID so that we can help track it.