EMIS

Error ketika menjalankan job dengan message sbb :

Starting job stg_m_students at 11:50 22/09/2025.
[statistics] connecting to socket on port 3366
[statistics] connected
Exception in component tDBInput_1 (stg_m_students)
java.sql.SQLException: Error retrieving record: Unexpected Exception: java.io.IOException message given: Socket is closed

Nested Stack Trace:

• BEGIN NESTED EXCEPTION **

java.io.IOException
MESSAGE: Socket is closed

STACKTRACE:

java.io.IOException: Socket is closed
at com.mysql.cj.protocol.AbstractSocketConnection.getMysqlInput(AbstractSocketConnection.java:72)
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:71)
at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:42)
at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1576)
at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:193)
at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.close(ResultsetRowsStreaming.java:115)
at com.mysql.cj.jdbc.result.ResultSetImpl.realClose(ResultSetImpl.java:1852)
at com.mysql.cj.jdbc.result.ResultSetImpl.close(ResultSetImpl.java:516)
at emis_kemenag.stg_m_students_0_1.stg_m_students.tDBInput_1Process(stg_m_students.java:6402)
at emis_kemenag.stg_m_students_0_1.stg_m_students.tDBInput_16Process(stg_m_students.java:2447)
at emis_kemenag.stg_m_students_0_1.stg_m_students.tFixedFlowInput_1Process(stg_m_students.java:1995)
at emis_kemenag.stg_m_students_0_1.stg_m_students.runJobInTOS(stg_m_students.java:17170)
at emis_kemenag.stg_m_students_0_1.stg_m_students.main(stg_m_students.java:17014)

• END NESTED EXCEPTION **

  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:131)
  at com.mysql.cj.jdbc.result.ResultSetImpl.realClose(ResultSetImpl.java:1854)
  at com.mysql.cj.jdbc.result.ResultSetImpl.close(ResultSetImpl.java:516)
  at emis_kemenag.stg_m_students_0_1.stg_m_students.tDBInput_1Process(stg_m_students.java:6402)
  at emis_kemenag.stg_m_students_0_1.stg_m_students.tDBInput_16Process(stg_m_students.java:2447)
  at emis_kemenag.stg_m_students_0_1.stg_m_students.tFixedFlowInput_1Process(stg_m_students.java:1995)
  at emis_kemenag.stg_m_students_0_1.stg_m_students.runJobInTOS(stg_m_students.java:17170)
  at emis_kemenag.stg_m_students_0_1.stg_m_students.main(stg_m_students.java:17014)
  [statistics] disconnected

Job stg_m_students ended at 14:37 22/09/2025. [Exit code = 1]