Question

workflow subscriber and designer unable to connect to laserfiche server after upgrade to 9.1

Workflow Version 9 Installation and Upgrades

Updated November 4, 2014

asked on October 3, 2014

Upgraded from Lf 8.3 to 9.1 Rio and installed Workflow Web and Web Access

server and workflow upgrade appeared successful and repository accesible as normal from clients.

Also installed Workflow Web and Workflow Web Services and both appear to be connecting properly in Config panel and can connect to both URLs from server and other computers in network, so don't think port 8085 is blocked. Logs show port 80 to server also open and web access is accessible.

Problem:

Workflow Designer and Subscriber not connecting to the local Laserfiche server. Starting rules not being picked up. Also, in workflow designer if I try to edit connection profiles, it gives an error that it cannot connect to the Laserfiche server. Can, however, connect to another LF 9.1 test server on network with no issues.

Have tried removing the Workflow web services, but they do not uninstall when deselected in the Rio installer. Would love to remove these and get back to status quo if at all possible.

Suggestions to troubleshoot/resolve ?

1 0

Replies

replied on October 3, 2014

Check the subscriber error log and the server error logs in Workflow Admin Console under the Monitoring node. What errors are you getting?

1 0

replied on October 24, 2014 • Show version history

I have a customer that is getting the problem in a similar situation.

the Error Log Viewer,in the Workflow Admin Console, shows "Access denied [9013]" as the error message.

The same message is also displayed when opening the Subscriber Tracer and looking at the repository tab.

As a note there is a second repository (the main production repository) is working just fine.

Also, If the trustee directory is opened for the problem repository, the message is given that "... 'WFUSER$' lacks sufficient access (Manage Trustees) ..."

1 0

View 5 previous replies

replied on October 24, 2014

Hm, that's weird, WFUser$ is a system account, it's granted the privilege on creation. The account is not modifiable through the Admin console either.

Can you run the following query on the SQL database for the repository?

  select t.trustee_id, t.trustee_name, a.privs
  from trustee t inner join account_security a
  on t.sid = a.sid
  where t.trustee_name = 'WFUser$'

1 0

replied on October 24, 2014

value returned is 0

0 0

replied on October 24, 2014

Is the trustee_id 4?

0 0

replied on October 27, 2014

Yes, I believe that it is 4.

0 0

replied on October 27, 2014

You could update the account_security table and set the privs column to "794641". Do you have any SDK scripts setting security on users? There's nothing in the Laserfiche products that would modify the privileges of this user, so I'm not sure how they have changed from the default value.

0 0

replied on October 27, 2014

I don't think that the customer has anything that would be directly modifying the database, I'll confirm and set the privileges to the expect value.

Thanks for the assistance!

0 0

replied on October 28, 2014

It doesn't have to be directly modifying the database. It could be an SDK script gone wrong and accidentally modifying more users than expected.

0 0

replied on November 4, 2014

We ran the script again and the results were as follows (on the 2 LF servers in use):

Production:

4 WFUSER$ 794641

Test:

4 WFUSER$ 794641

0 0

You are not allowed to follow up in this post.

Question

Question

workflow subscriber and designer unable to connect to laserfiche server after upgrade to 9.1

Replies

Sign in to reply to this post.