SmartsIntegrator Support and Discussion Forums

Index error

Share/Bookmark: Add this Thread to Digg Digg   Add this Thread to StumbleUpon Stumble Upon   Add this Thread to Del.icio.us Del.icio.us   Add this Thread to Reddit Reddit   Add this Thread to Facebook Facebook
RE: Index error
by benj on Wed, Jan 14 2009 12:11 PM
Hi Mike

I’m very sorry that you’ve encountered this problem, and have been able to reproduce it using an old database. A new column, GenId, was recently added to the WT_WorkflowMessage table. This change was supposed to be backwards compatible, but clearly an error has occurred.

The easiest way of proceeding is for you to export all elements of your solution, create a new database, and then import your solution into the new database. Alternatively if you prefer I can send you a component update to allow you to continue using your old database without error, but the new schema will provide a number of benefits.

Please advise how you’d like to proceed,

Thanks,

Ben.
Ben Jackson
SmartsIntegrator Technical Support
Quote This Reply
benj
benj
Joined: Thu, Feb 7 2008
Posts: 96
Index error
by portedquery on Wed, Jan 14 2009 12:10 PM
Ben,

Thanks for the info..This is a really nice feature and should take some of the deployment pain away!

Another questions if you don’t mind.

We have a simple database receive port that check for a status change and if it finds it, send a message which kicks off a workflow. During testing, the workflow terminated due to an unhandled exception. In the System Overview screen, the Incoming Message count is 8. If I click on this, it takes me to the Receive Port root in the explorer tree but no sign of any messages. If I go to tracking, there is no sign of the messages either Search Tracking Log or Active and Suspended Messages. If I then go to Active and Suspended Workflows and click on the Queued / Failed Instances, I get an Exception, “Error: An Exception occurred: IndexOutOfRangeException, GenId:” – Any ideas?

Cheers

Mike
Quote This Reply
portedquery
Joined: Wed, Jul 2 2008
Posts: 72
Page 1 of 1