Verification of data forwarding and re-sending to Axess
To verify that transactions are being sent to the Axess database, run the following query:
select * from _Ax_Transactions at where at.[Status] = 9
If zero records are returned it means that all data has been forwarded. If there are records returned, look at the errors and try to correct them. Once they are corrected, reprocess the transactions by running the following statement in a query window:
exec SiriusSP_Ax_ReprocessTransactions
After resending - verify again with the select statement above. Repeat the process as necessary. To retire old errors, run this in a query window adjusting the dates as appropriate:
Update _ax_transactions set status = 8 where status = 9 and DateAdded between '2010-08-01' and '2010-12-15'