Pentaho

 View Only

 Pentaho job problems

  • Pentaho
  • Pentaho
Chicago Inspector's profile image
Chicago Inspector posted 11-12-2019 19:01

I'm running Pentaho jobs overnight at 1:00am. Just the other day our server shut down due to power outage while the ETL was running and every since then, the past few days the ETL job has failed at the same time. All the other ETLs jobs before 1am are running fine, but anything after 1am is not. The errors that I get is attached. Has anyone come across the same issue?


#Pentaho
Ana Gonzalez's profile image
Ana Gonzalez

Seems like it's a connection issue in mysql, but can't say what might be happening that it's different in other time slots. Googling the error message seems to lead to timeouts during batch inserts due to preparing the statement, check out about parameters in the connection you can set to widen the timeout slot.

Or you can check other things happening in the database or the net at that time that can make things go slower.

Regards