3.1 RunningBalanceStartPoint Scheduled Event never completes and gets rescheduled
Problem
We have a situation where a Running Balance Scheduled Event never seems to complete and then it reschedules itself to run again, so our Scheduled Events DataGrid shows 100+ events for 'RunningBalanceStartPoint.'
What causes this and how do we stop it?
Solution
This situation occurs when one or more Households in your database have something (a SADetail record) in the Shopping Cart. An item in the Shopping Cart makes it impossible for RecTrac to determine an accurate 'Running Balance Start Point for that Household's transaction history. When this occurs, the system re-schedules the event to run again the next day. The thought process is that if a household legitimately has something in the Shopping Cart when the event is being run, that item will have cleared the Shopping Cart by the time the event runs again the next day.
Having 100+ RunningBalanceStartPoint events, however, strongly suggests these problem transactions are old and not accurate anymore.
To troubleshoot this:
1. Go to the Document Center and locate the most recent version of the RunningBalanceNoCalc.csv. This will be under Reports.
This file will list the households which have the problem transactions. The report/spreadsheet lists only ONE of the sadetail records from each Household that is stopping the process. There could be many sadetail records, but the process lists one per Household only.
At this point, you need to deal with these records in order for the process to ever complete.
2. Go to DBEdit > SADetail. For each Household in the file, run the following query: lookup(cartstatus,'InCart,InCartCancel,InCartChange,Update,NextStatus,PrevStatus') gt 0 and householdnumber = [HHNumberInfile]
3. This query will list all the problem records for the household. These records must be dealt with. Contact Vermont Systems Support for guidance, if needed.
Once all the problem records for all households have been dealt with.
4. Run 'runningpurge.r' (quickie), which will clean up (i.e. delete) the Scheduled Events are named 'RunningBalance*'
5. Run runningbalancestartpoint.r in Quick Fix Processor once more, so that the Households that were causing the issue have a Starting Balance Record made.
6. Go back to Scheduled Events Management. If you see another Scheduled Event for the RunningBalance program, you did NOT properly deal with all the records in the file. Go back to Step 1 above and repeat the steps through to this point.
7. When Scheduled Events Management no longer shows a RunningBalance event, then you have properly completed this process.