Connect to Test Database

I have a new client who already has TaskCentre installed. They have asked me to set up some automated tasks for them. I created a copy of their database to use for testing and would like to use it for TaskCentre until I can be sure the task is going to run correctly. In the connection for the query it only wants to connect to the original database. Is there somewhere I can set it to go to the test database?

TaskCentre - Crystal Reports Runtime

Hi guys,


I have a running task centre. I was working fine until I checked it again today and found out that every single task with crystal reports attachment failed.

I have checked taskcentre's event log, nothing's there.

However, other tasks work perfectly fine.

Adding logo to TaskCentre generated email

A TaskCentre job sends an e-mail in html format, to whch content I need to add a logo (.jpg). How do I add the image file?

TaskCentre sending out a double email when only one should be sent

We have a TaskCentre task setup with our events to send out a confirmation letter. The issue we are experenceing is that every now agian for no reason that I have been able to find out yet, TaskCentre sends out 2 confirmations instead of 1 like it should.


Has anoyone else run into this odd issue??

if so did you find a soltion?

Thank you in advance for your time and assistance.

Taskcentre: Can a task be triggered from iMIS WCM page


In IMIS can a taskcentre task be triggered from a link/button on a page that is hosted by iMIS WCM?

i.e. wondering if user can click link and have their membership certificate emailed to the email address we have on record for them?




Has anyone yet reached their maximum number of Tasks in TC?

You may have or may not have been aware, but there is a limit of 25 tasks you can build in an out of the box TC implementation.  You can buy more of course, but I was curious to find out who may have hit this limitation and how fast?  Would you mind sharing how you worked around your issues if you did run into this limitation?

Crystal Report Errors in TaskCentre with - Error returned from Crystal Reports - (0x80020009)

I have a Crystal 9 report that is a dues receipt and yesterday after setting up the task, testing it several times and then running it manually once I set the schedule for the report and expected that dues receipts for payments received from yesterday would be sent to all of our members.  This did not happen.  Today I see in the event log this message Error returned from Crystal Reports - (0x80020009).  The same message is displayed to me even when I attempt to run the task with the Queue Now option.  Does anyone have any knowledge of this error and how they resolved it?  I have already tried using a different user name and password, something simpler, resetting all the login information (the event log reports that logging into the tables on the server is file as it starts to load the crystal report).  In fact, the event viewer tells me that the report is loading and then the error occurs.  here are a couple of the messages in order.

TaskCentre task to move event registrations to activity when reg status is changed, without closing the event

We have a client who requires the ability to move an event registration from the order order_lines, etc. tables into activity whenever they update the status of the registration to anything other than blank (default).  All of the event functions are no fee & they don't need to worry about the closing event process.  Some events remain open for 12 months so they need to be able to pull reports & queries from a single source (i.e. either the registration or activity).

Task Centre's maintenance mode

Clients tasks had stopped running and when I tried launching a test task manually, I got a message the server was in maintenance mode and the task could not be started.

Do you know how to get it out of this mode? I've never known it to be in this mode in the past.


Task stuck in loop

Very strange occurence here.  We have a task that fires and completes successfully at times.  Other times it fires but gets stuck in a loop and causes the tempdb to grow too large and eats up all the server disk space.

Here's the error:

Could not allocate space for object 'dbo.CWT'.'CWT_PrimaryKey' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Any idea what CWT in the tempdb is referring to?