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.

Rob

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?

I'm having a real problem with an initial task that I wanted to see if this community had any help.

The task is rather complex and involves 2 Decision steps.  The last one has about 6 branches it has to evaluate.  The way it works is initially a trigger fires then a query fires to only pickup certain transactions.  In one example, i purchase 3 different products and the Decision step is supposed to send out 3 different emails with a number of pre-defined attachments.  What is happening is the Decision step is only working for the 1st product code its finding and sending 3 emails of the same product code.

I cannot get the Run Program tool to do anything. I will try to make this as simple as possible.

After I started having problems I created a task called test program tool. All it does is run one batch file in the C: drive called test.bat which renames a file.

If I just browse to it in Run Program, it fails saying it cannot locate c:\test.bat.

If I add double-quotes around it like "c:\test.bat" it does not error, but does not rename the file.

The batch file is on a terminal server with the TaskCentre client.

Can Run Program only run programs on the server where TaskCentre Server resides? I am trying to run a .net program in the iMIS app server, and the TaskCentre server is on the SQL server.

I really am trying to run a createuser.exe file that takes one parameter, ID. I tried that at c:\Program Files (x86)\ASI\iMIS15\net\bin\createusers.exe and it either failed if not in quotes or acted like it executed in quotes. Same as the simple batch file. The program works when executed at the command line.

The exe takes just one parameter no output, input dialogs or anything. It does output a success message at the command line, but the program is done by then.

In any case, the simple batch file should work, a. What are the tricks to getting this to work?

Help!

Hi to all,

We have a crystal report that a user runs every month. It is a standard iMIS crystal report (within the Event Module) called Function Roster. This report when run in iMIS requires the user to select options. First selection group is about event, In our case, the user must select the AdHoc Search radio button. When the list of available AdHoc searches window opens, user selects the AdHoc search Begin Date. The AdHoc Search is configured as from Meet_Master.BEGIN_DATE >= 07/01/2011 (date is just an example). The second set of selection after Event is Print Options. In this set, the Include Cancelled checkbox must be checked.

I have couple of simple triggers on a particular field on the database but when testing them they don't fire.
I double checked everything and it all seems fine. One of them used to be working even few weeks ago and now it wouldn't fire.
I checked the database and triggers are there. Event Log shows creation of triggers. It's just that when the value is changed in the DB they don't fire.
I checked thy all the services are up and running including SQL trigger in the database server.

I am fairly new user of TaskCentre and just trying to figure out how to use it.
I need to create "Execute" step and using my OLEDB connection (or even "native connection") when I browse to select procedure it only lists "master" database and procedures under it as available. I do not see my iMIS database as an option.

I need to execute store procedure from my iMIS db.

Your help is appreciated.

Hi

I'm trying to best work out how to automate deleting cart items older than a certain number of days.

A bit of background:

Our organisation has hundreds of events a year.  Entries (registrations) close for these events approximately 6 weeks before the event takes place.  Currently members can go through the registration process, but not submit the order, and the item remains in their cart.  They can then go back during that 6 week period and finish the registration, thereby gaining entry to the event *after* entries have closed.

Is anyone using Taskcentre 4.5 within a clustered SQL database environment. ASI and Orbis are saying that the SQL Server Trigger Agent currently does not support clustering but I wanted to see if anyone is currently doing this with a workaround.

Their recommendation was to setup replication to yet another database server and install the agent there, which I only want to do as a last resort.

Hi,

We are setting up TaskCentre v4.5 with Word to MailMerge but when running the MailMerge step get the error: "Microsoft Word could not initialize properly" Have tried multiple documents but no solution found as yet....

Has anyone experienced this or has any suggestions?

UPDATE July 14 - All fixed, turned out to be an issue with the server setup and permissions on the account running the TaskCentre service. Big thanks to Paul at ASI for helping resolve this!