Question

SQL query returns all results but Folder Building workflow produces subset of results

Workflow Version 9 Ideas Laserfiche Business Processes

Updated July 30, 2015

asked on July 22, 2015 • Show version history

Folder building workflow works, mostly.

SQL Query finds Last, First MI and builds folders in Laserfiche "For Each Row" after copying a base set of folders and checking for pre-existing folder names in LF.

The problem is, I have 1012 names in the database, and only 1009 named folders in LF.

Here is the result of the query:

Here is the same query in SQL, showing one of the three missing names from Laserfiche:

And here is the resulting folder list from Laserfiche.

Here is the workflow. It is this complex because it needs to check for pre-existing folders, run a query, and build folders based on the For Each Row portion of the query, and because it was working to build folders. I am willing to simplify it if necessary to achieve 100% success with folder names.

By the way, one of the names is Client #4 in a list of over 2000 total names (the ones we are importing are all StatusType = 'Active' in SQL) and the other two are Client #2198 and Client #2199 of total 2200. (But #2200 came across OK.) All the other entries are marked 'Inactive' and are excluded, but all our queries are limited to the 'Active' clients. It's just these pesky exceptions...

Thanks!

John Kimball

jkimball@copiersnw.com

0 0

Answer

APPROVED ANSWER

replied on July 30, 2015

A support case had been opened for this issue. The workflow was re-designed as the original way it was checking for existing folders may have had some issues. See the screenshot below for the recommended workflow which was then confirmed to have resolved the matter.

0 0

Replies

replied on July 22, 2015

Have you looked in the instance details? How many results did it get? Are there any errors or warnings? What's different about the missing 3 entries?

0 0

replied on July 23, 2015 • Show version history

I do not see the number of results in the Instance details (just the length of time each task ran.) I have a bunch of "Assign Field Values" errors ending with "Entry not found. [0472-WF1]." The Business Process details say "Terminated" rather than "Completed."

Nothing different about those entries, other than the small details I mentioned at the end of the last post.

Here is what I am describing now:

Instance Details:

Errors:

Business Process Details:

Final rows of Activities:

"Tokens" list shows that the query found all 1012 active client entries among the table: It is interesting to me that "M. Wilson" is not an active client. Is he/she taking up the last spot of the 1012 active clients?

The ones I am missing have last names Abee, Flack, and Smith. Flack and Smith are toward the end of the list (by Client ID) and Abee is #4.

One more point: The "Workflow" tab shows an error status on my "Assign Field Values" step. "Client ID" is the only Required field in all of Laserfiche. All of these clients have a Client ID in the database, so I don't think there is an error there, but I am not sure why this step is failing. The "Entry Not Found" errors above point to this step. Any ideas on what those errors mean?

Any help will be appreciated.

0 0

replied on July 24, 2015

John -

I'm sure you looked at this already, but just in case: in your screenshot of the SQL table, the MiddleInit for Abee is NULL - is it possible that all of the ones that don't return are NULL for that column?

0 0

replied on July 28, 2015

Thanks Jim,

Most middle Inits are NULL, and the other two names that are not returning have middle inits.

All the Best

John Kimball

0 0

replied on July 28, 2015

It's hard to tell what's going on since you have so many errors. Your error list is not completely displayed in the screenshot, so I can't tell if something else is failing. It looks like your Assign Fields activity is misconfigured in the cases where the activities in the Conditional Sequence don't run. Could you clean that up first and try again?

0 0

You are not allowed to follow up in this post.

Question

Question

SQL query returns all results but Folder Building workflow produces subset of results

Answer

Replies

Sign in to reply to this post.