View Issue Details

IDProjectCategoryView StatusLast Update
0005133SymmetricDSBugpublic2021-12-11 17:11
Reporterelong Assigned Tojosh-a-hicks  
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.12.13Fixed in Version3.12.13 
Summary0005133: During a full load do not ok existing batches for the same load id.
DescriptionIf a full reload is sent to the target and there is a socket time out while sending batches, the initial batches could be in a state where they were already loading into sym_incoming_batch table. Then when the load tries again it will send a sql event (as it does for all full loads) to mark any pending batches to OK before running the load.

The issue occurs because this will now ok batches in sym incoming batch for the load that is running but experienced the timeout prior to loading. Then when the batches arrive it will detect they are in sym incoming batch already and marked OK status and will skip them causing these batches to never run.

This fix is to adjust the sql that runs prior to a full load to update the status of only those batches that are not part of the same load id and not ok.
TagsNo tags attached.


related to 0005118 closedjosh-a-hicks During a full load do not ok existing batches for the same load id. 


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-11-24 18:15 elong New Issue
2021-11-24 18:15 elong Status new => assigned
2021-11-24 18:15 elong Assigned To => josh-a-hicks
2021-11-24 18:15 elong Issue generated from: 0005118
2021-11-24 18:15 elong Relationship added related to 0005118
2021-11-24 18:16 elong Status assigned => resolved
2021-11-24 18:16 elong Resolution open => fixed
2021-11-24 18:16 elong Fixed in Version => 3.12.13
2021-11-24 18:16 elong Target Version => 3.12.13
2021-12-11 17:11 admin Status resolved => closed