3732627 - How to add a connection timeout for SQL Anywhere repository - SAP Data Services

• Multiple SQL Anywhere repositories show intermittent job failures at different intervals and dates due to network instability.
• It is necessary to increase the connection timeout, but there is no option in SAP Data Services Server Manager.
• The jobs fail with the following errors:
  • ODBC call <SQLDriverConnect> to connect database <DS_PROD_SQL> failed with error: <[SAP][ODBC Driver][SQL Anywhere]Connection
    error: Timeout occurred while waiting for connection response>. (...)
  • REP-100108: Initialization Cannot perform operation on repository <Current Repository> because no connection has been opened.

IMPORTANT: SAP Data Services requires a stable connection to the repository. Adjust the timeout only if there is no other option. First, always discuss with the network team to improve latency and identify the reason for the network issue.

• SAP Data Services
• SQL Anywhere as repository

REP-100108; SQLDriverConnect; ODBC; timeout; SQL Anywhere; AppConnTimeout; repo; DSN , KBA , EIM-DS-CON , Connectivity , EIM-DS-EXE , Job Execution , Problem