GP with real time SQL Server data source – missing events?

hi,
I have SC 2018 map using real time SQL Server datasource (GP IV00102 table – i.e. GP item quantity master table) with MS SQL Server stored proc as destination. Inside of my stored proc, the very first step I do is I write row in my custom log table in order to log for what inventory item my map as been invoked for and some of data points I pass into my stored proc such as Qty Allocated, Qty On Order etc.
From my custom table log entries it became apparent – it looks like my real time map is NOT being invoked every single time when I think it should be invoked, i.e. when any of the columns of IV00102 table I have included in my data source are changing, i.e. when item is being trasacted on. I do not understand how could this happen, since as I assume every time new SO or new PO are created, item’s Qty Allocated and/or Qty On Order change and it MUST trigger my map’s execution. 
I am at loss at where to look next – could there be errors I am not logging and therefore not seeing?  I log errors as well as successes in my map but don’t see anything which would point to the root cause of the behavior I am observing. Would you have any suggestions as to where I may look?
 
Thank you!
Eugene




4 Answers

Slade Conner July 11, 2020 at 10:34am
The items of Pandora like bracelets, pendants and ear rings having heart structure crave on them Bowling Green Roofing Contractor look very much attractive it is just like a charm and it is so cool the girls of my high school are very crazy about these items of Pandora.
#1



Noeh Chance Kim July 13, 2020 at 10:17pm
Leaving this here as this may help. Click here
#2



performance based SEO
#3







Answer this Discussion