I have an issue that I am at a loss on how to trouble shoot. I am trying to produce an Excel Spreadsheet that notifies management of 6 different conditions that will occur within 3 months of the report date for the clergy members of our diocese.
This report runs the first Monday of every month and I use a process model Run Assignment Notification Report to produce the report.
The process model is pretty straight forward.
I then run through a serries of two smart services; Script Task and Export DSE to Excel for each of the 6 tabs.
This is my problem.
The first time this set of two smart services run, it works fine. I can see the process variables in the process model monitor and the data is pulled and saved into the spreadsheet and sorted corrected. (EX: Set Blank Term End Config and Export Blank Term End Tab).
The second and all subsequent pairs of smart services (for example Set Age Notification Config and Export Age Notification Tab) I do not see any data in the two process variables; PV!clergyReportQueryConfig and PV!exportCustomPositionsAndValues (the are null). The strange thing is that the data is pulled correctly and in the proper tabs, however, it is not sorted correctly.
I tested the two expression rules independently of the process models for all the possible inputs for this report and they work as expected for every condition in this process model.
It is a guess on my part that the reason the data is not sorted correctly, it that the two process variables i need for the Export DSE to work are null. But if that is the case, then way is the data filtered correctly into the worksheet??
The issue I am trying to solve is to sort the data in the worksheets 2 through 6.
Discussion posts and replies are publicly visible
I would suggest to test each pair of nodes in the series to verify the output and it will easier to troubleshoot.