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.
SAP Knowledge Base Article - Preview