Unable to create the SQL statement for selection criteria when adding a new document to PaperVision Enterprise

Product: PaperVision® Enterprise

Last modified: September 21, 2022

Submitted: May 12, 2010

Version: R70

Article ID: PE000151

Unable to create the SQL statement for selection criteria when adding a new document to PaperVision Enterprisemain image

Find what you need

Filed under:

Description

A user attempts to add a document to a project in PaperVision Enterprise and receives the following error: Unable to create the SQL statement for selection criteria. (Source: AttachNewDocToProject.EntProcessNewDocsEx.EntCreateDocWFInstances.EntCreateDocWFInstances.PVDMSystem)

Summary

This error occurs when a document that has been added to the project contains an index field that existed in a WorkFlow definition pre-condition, but has been changed or removed. The WorkFlow is not able to create an instance for the document because the index field does not match what is stored in the WorkFlow pre-condition and the system throws the error.

To resolve this follow the steps below:

  1. Log in to PaperVision Enterprise (or ImageSilo) as a Workflow Administrator, System Administrator or Global Administrator.
  2. Refresh the Workflow Definition by opening the definition, clicking Edit under Pre-Conditions, then clicking OK to save the pre-condition.

This causes the WorkFlow definition to update its pre-condition based on the current project index field configuration, and allows valid WorkFlow instance to be created when a document meets the pre-condition.

Note: If the index field was removed from the project, it will be removed from the pre-condition criteria as well. Since this could leave the pre-condition with no criteria, you should check for this scenario as well when refreshing the WorkFlow definition.