3 Replies Latest reply on May 12, 2011 6:28 AM by Faur Arama

    remove files from workflow

    Eric Martin

      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.