Symptom
- Job running with the error below after database and JDBC driver upgrade:
"RUN-058105: |Data flow <DATA_FLOW>Error preparing to read <Query>: <Exception occurs when executing 'begin' method of the adapter operation with ID [16]. Optimized SQL Statement : SELECT <TABLES> FROM <SOURCE>, Error : Connection closed>. " - Trace log:
"Data flow <DATA_FLOW> is terminated due to error <58105>." - Job runs using a Job Server with Adapter connecting to Denodo database with JDBC driver.
- In the JDBC driver V.7 every job is working fine, but on V.8 it is returning this inconsistence when running the jobs with high volume of columns.
Read more...
Environment
- SAP Data Services 4.x
- Denodo Database upgrade from 7.0 update 20181011 to 8.0 update 20220815.
- JDBC driver from 7.0 update 20181011 to 8.0 update 20220815 or 8.0 update 20230914.
- Linux
Product
SAP Data Services all versions
Keywords
DS, BODS, Connection, Failure, Failing, Tasks, Adapter, columns, table, upgrading, upgraded, migrating, migration, migrated, DB, DBA, , KBA , EIM-DS-SVR , Administration/Server , EIM-DS-DEP , Deployment, Installation, Upgrade , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.