Has anyone else experienced warnings in the job log when doing a delta against a 2LIS extractor using CDC extraction mode? I am using multiple 2LIS extractors. Most work fine, however I am seeing a few that throw the following warning messages upon execution: “Reader Query - Mapping1 Invalid Value <Month: 255> for date <>. Context: Column <>”
An example (and one that is bothering me the most) is the 2LIS_02_SCL extractor. My initial load works fine (no warnings). However, I get warning messages when doing deltas.
The number of warnings appears to coincide with the number of records that are cancelled coming in from the extractor (ROCANCEL has a value of ‘X’). However I have no way of verifying this for sure as the root cause.
Any thoughts?
dhofman (BOB member since 2006-03-17)
(BOB member since 2012-01-17)