LoadDisbursementVouchersJob

Owned by Kathleen Avery (Deactivated)
Last updated: Feb 19, 2016
1 min read

Problem: 

Job fails with the following message:

* SQLException during execution of sql-statement:

* sql statement was 'SELECT A0.ROLE_MBR_ID,A0.ROLE_ID,A0.MBR_ID,A0.MBR_TYP_CD,A0.VER_NBR,A0.OBJ_ID,A0.ACTV_FRM_DT,A0.ACTV_TO_DT FROM KRIM_ROLE_MBR_T A0 WHERE ((A0.ROLE_ID = ?) AND A0.MBR_ID = ?) AND A0.MBR_TYP_CD = ?'

* Exception message is [IO Error: Connection reset]

* Vendor error code [17002]

* SQL state code [08006]

* The root stack trace is -->

* java.net.SocketException: Connection reset

 

Resolution:

This job can be rerun.  Any disbursement vouvhers that were already created will get a message 

"E - The Invoice Number "9999999" has already been used in another Disbursement Voucher (Document ID: 9999999)" on the .PDF file sent to the initiator of the file.  The Document ID is the original Disbursement Voucher.

Any Disbursement Vouchers not created will get created.

 

The job can be rerun as many times as needed, to process all input files.