Troubleshooting TaskCentre

On occasion, TaskCentre will stop running or return cryptic errors like:

"Cannot run task “Monthly Mailer” because the server has no available slots"

"Monthly Mailer" is the name of one of my tasks - substitute the name of a task, etc.

The first thing to check to see if the service is running. If it is, try restarting it - many times it has been the fix.

Also, I recommend setting up a simple task in TaskCentre that sends you an email everyday. If it does not arrive you know something is up.

Resetting TRANS records

We are testing some G/L Integration; one of the challenges is once we run our Month-End Procedures they are no longer available for testing again.

One way to resolve this is simply to take a backup of the database before running the Month-End Procedures and restoring it if you want to try it again.

A short-cut method, which is working for us is to update the TRANS.Posted field like so:


/*
Testing G/L Integration
set the TRANS.Posted value to 2 to re-integrate or setup transaction for month-end procedures
when the month end procedures are run the value get changed to 4
*/
update
trans
set
posted = 2
where
year(transaction_date) = 2009