SAP Knowledge Base Article - Preview

2693809 - Scheduled jobs fail intermittently in SAP Data Services

Symptom

  • Some scheduled jobs fail intermittently, and the following error can be seen in the AL_RWJobLauncherLog.txt:

"The last packet successfully received from the server was 85,825,968 milliseconds ago. The last packet sent successfully to the server was 85,825,968 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem"


Read more...

Environment

  • SAP Data Services 4.X
  • MySQL 5.6.40.
  • MySQL java connector 5.1.34.

Product

SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2

Keywords

SAP Data Services, Data Integrator, DS, MYSQL, Scheduled job failing, Intermittent, DI, Connection, Database , KBA , EIM-DS-SVR , Data Services Administration/Server , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.