Jason
If you're using TaskCentre to update a UD table, and it's causing iMIS to crash, then I would suggest that the fault is in your update script, not in TaskCentre!
What are you updating, and what sort of crash are you experiencing?

I am a Consultant working with one of ASi's clients. I am actually working on a certified consultant path for iMIS as well. Unfortunately, I cannot wait for the next class. We are deploying some new business processes on April 1st and I need to get TaskCentre up and running for SQL Triggers to handle some new chapter subscription rules. I understand that the documentation may not make sense, but at this point anything will help.

I have successfully installed TaskCentre, and I set up one task for testing. The task is a trigger on a UD table in iMIS that runs whenever a record is inserted or updated. In the SQL interface, when I edit the row, the trigger fires and the correct procedure gets called. However, when I run iMIS and updated a field in that table, the customer module crashes. I can only guess this is some permissions issue, but I can't be sure. I am not finding any errors in error logs either.

Any help you can provide will be greatly appreciated.

Thanks,
Jason

PS, the only step in my task, after the trigger is a call to a stored proc that inserts a record into a dummy table. Nothing fancy yet. I wanted to get it to work and then do what I wanted, so it's not an issue with my code at this point.

Usually when iMIS crashes it puts an entry in the log file in the ASITemp folder. Have you checked that? If that doesn't help you may have to run SQL Profiler to see exactly what's happening. When you add triggers to the iMIS database you have to be really careful about the sequence of things. Be sure and set nocount ON at the beginning of the trigger - if you don't do that iMIS can get unexpected results returned that can upset it.

NoCount is on, and there is nothing in the error log.

That was actually the SQL Server PUBLIC Role that we assigned the permissions to, which I believe all users of SQL Server are members of by default. Assigning the permissions directly to the imis sql user account was not sufficient.

I never received any documentation, however, I do have a document with setup instructions and some basic triggers. I don't see anyway to posting a document here however, so I guess if you send me a way to contact or send you a file, can send over what I have.

can you email it go me? jrguenther@bscichicago.com I thought there was a way to submit files. I'll continue to look for it.

You get documentation when you come to class. Ted Ericson. ASI/Product Management