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
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.