GP with real time SQL Server data source – missing events?
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?
I know a lot of our readers run some type of Microsoft SQL Server reporting on their General Purpose GP. Need to check this open cell spray foam and get more steps about spray foam. That’s a great fact, but there is something that may not be as familiar to you. If you are utilizing the SQL Server Reporting Services and have added events as part of your report, there is something else you should know.
If you would like to submit an answer or comment, please sign in to the eOne portal.