Support Article
BIX extract "No Instance found in the database" error
SA-15742
Summary
Run an Extract Rule from the developer portal, the error "No Instance found in the database" is received.
Error Messages
No Instance found in the database.
bix/useHistoryClasses setting has been disabled
Value of pyLastUpdateDate in pr_Extract_Time at the beginning of BIX run: 2015-09-22 00:00:00.0
SQL Exception: Unsupported holdability value
#Instances this thread updated: 0
CPU Time (this thread): 0.0 seconds
Steps to Reproduce
- Create an extract rule
- Select CSV as the extract output format
- Delete all filter criteria and check "Use Last Updated time as Start"
- Run extract
Root Cause
A third-party product issue. There is a compatibility problem with this version of BIX and up level versions of the Oracle JDBC driver.
Resolution
Make the following change to the operating environment:
Use an earlier version of the JDBC driver to circumvent this problem.
See reference:
ResultSet.HOLD_CURSORS_AT_COMMIT holdability value is not supported in Oracle JDBC driver version: 12.1.0.1.0.
Published January 31, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.