BIX extract "No Instance found in the database" error
Run an Extract Rule from the developer portal, the error "No Instance found in the database" is received.
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
A third-party product issue. There is a compatibility problem with this version of BIX and up level versions of the Oracle JDBC driver.
Make the following change to the operating environment:
Use an earlier version of the JDBC driver to circumvent this problem.
ResultSet.HOLD_CURSORS_AT_COMMIT holdability value is not supported in Oracle JDBC driver version: 22.214.171.124.0.