AnsweredAssumed Answered

remove files from workflow

Question asked by Eric Martin on Apr 24, 2011
Latest reply on May 12, 2011 by Faur Arama

I upgraded from 2007 to 2011 and I had no errors in the database conversion and everything works right except workflows. When I try to transition any files I get a error

Error running query in SpDbOdbc
State=37000
Msg=[Microsoft][ODBC SQL Server Driver][SQL Server]The ntext data type cannot be selected as DISTINCT because it is not comparable.

 

I created a new vault with a new workflow to see if it was PDM or just teh old workflows and had no problems. Therefor I would have to say there is a problem with the way the upgrade carried over the old workflows.

 

Is there a way to remove all files from the old workflows. This would probably have to be done via a query or something.

Outcomes