Hi, We have a workflow created for performing bulk import on large number of PDF files. The workflow has four phases:

1. User moves the files from a folder on a server to a specific folder in Laserfiche called "Pending"
2. Upon moving a file, the workflow will be triggered. It will associates specific template with the file. The workflow will retrieve fields values from an excel sheet we placed in specific location. We defined the excel sheet as the data source to be used in the workflow. We set ODBC connection to to achieve this connectivity.
3. Once the template and field values are applied, the workflow will create a new folder hierarchy under a main folder called "Processed". The folder hierarchy is based on the field values specified in the template. The workflow will move the files into the created folders.
4. The workflow will repeat the above steps under all imported files are processed

Recently the workflow stopped working. We troubleshooted the issue and found that the workflow definitions reverted to old parameters that were used during testing sessions few years back - we could not know why this happened.

To solve the issue, we updated the workflow defined in the Laserfiche Workflow Definition file with the correct parameters. We saved and published the workflow. The workflow partially worked. It applied the template but did not capture the field values and failed to create the folder hierarchy.

The data source is set correctly but the test query feature retrieves 0 results and we don't have any errors generated. We also noticed that the workflow definitions in the Workflow Server remains unchanged and not matching the updates we made.

What could have caused the workflow definitions to roll back to values that were used few years back?

What should I troubleshoot or investigate to capture the field values from the excel sheet?

How can I ensure that the correct workflow definitions are reflecting the workflow server?

Any other suggestions would help. Thank you.