View Revisions: Issue #6741

Back to Issue
Summary 0006741: Change log level to WARN in DefaultDatabaseWriter.logFailureDetails
Revision 2025-02-28 16:30 by pbelov
Description The DefaultDatabaseWriter.logFailureDetails logs batch errors as INFO level messages.

Example for the Compare & Repair job:

2025-02-28 09:51:13,298 INFO [Sybase] [DefaultDatabaseWriter] [sybase-dataloader-49994] Failed to process insert event in batch SQL08_Trigger--9999 on channel 'default'.
Failed sql was: insert into jcdc.dbo.disability (add_dt, add_user, disability_id, disab_cat_cd, disab_cat_other_desc, disab_sub_cat_cd, disab_sub_cat_other_desc, last_mod_dt, last_mod_user, stud_id) values ({ts '2018-10-10 11:20:23.563'},'BrandL01','234824','2370',null,'4442',null,null,null,'1742371')'234824'
Failed raw sql was: insert into jcdc.dbo.disability (add_dt, add_user, disability_id, disab_cat_cd, disab_cat_other_desc, disab_sub_cat_cd, disab_sub_cat_other_desc, last_mod_dt, last_mod_user, stud_id) values (?,?,?,?,?,?,?,?,?,?)
Failed sql parameters: [{ts '2018-10-10 11:20:23.563'}, 'BrandL01', '234824', '2370', null, '4442', null, null, null, '1742371', '234824']
Failed sql parameters types: [TIMESTAMP, VARCHAR, BIGINT, BIGINT, VARCHAR, BIGINT, VARCHAR, TIMESTAMP, VARCHAR, BIGINT]
Failed sql state and code: ZZZZZ (584)
Failed row data was: "2018-10-10 11:20:23.563","BrandL01","234824","2370",,"4442",,,,"1742371"
 StackTraceKey [SqlException:1962199873]
2025-02-28 09:51:13,399 ERROR [Sybase] [ManageIncomingBatchListener] [sybase-dataloader-49994] Failed to load batch SQL08_Trigger--9999 StackTraceKey [SqlException:1962199873]
Revision 2025-02-28 18:30 by pbelov
Description The DefaultDatabaseWriter.logFailureDetails logs batch errors as INFO level messages.

This change sets log level to WARN in logFailureDetails, to help this message break through filters, which might eliminate INFO messages.

Example for the Compare & Repair job:

2025-02-28 09:51:13,298 INFO [Sybase] [DefaultDatabaseWriter] [sybase-dataloader-49994] Failed to process insert event in batch SQL08_Trigger--9999 on channel 'default'.
Failed sql was: insert into jcdc.dbo.disability (add_dt, add_user, disability_id, disab_cat_cd, disab_cat_other_desc, disab_sub_cat_cd, disab_sub_cat_other_desc, last_mod_dt, last_mod_user, stud_id) values ({ts '2018-10-10 11:20:23.563'},'BrandL01','234824','2370',null,'4442',null,null,null,'1742371')'234824'
Failed raw sql was: insert into jcdc.dbo.disability (add_dt, add_user, disability_id, disab_cat_cd, disab_cat_other_desc, disab_sub_cat_cd, disab_sub_cat_other_desc, last_mod_dt, last_mod_user, stud_id) values (?,?,?,?,?,?,?,?,?,?)
Failed sql parameters: [{ts '2018-10-10 11:20:23.563'}, 'BrandL01', '234824', '2370', null, '4442', null, null, null, '1742371', '234824']
Failed sql parameters types: [TIMESTAMP, VARCHAR, BIGINT, BIGINT, VARCHAR, BIGINT, VARCHAR, TIMESTAMP, VARCHAR, BIGINT]
Failed sql state and code: ZZZZZ (584)
Failed row data was: "2018-10-10 11:20:23.563","BrandL01","234824","2370",,"4442",,,,"1742371"
 StackTraceKey [SqlException:1962199873]
2025-02-28 09:51:13,399 ERROR [Sybase] [ManageIncomingBatchListener] [sybase-dataloader-49994] Failed to load batch SQL08_Trigger--9999 StackTraceKey [SqlException:1962199873]