Query for workflows using a common versus user workflow connection profile?

asked on August 22, 2024

Greetings,

In our environment there are workflows that use the same Repository User account to connect to our repository, but some use our Common workflow connection profile while others use a User workflow connection profile. We want to change the password for the Repository User account. We can easily update the password for the Common workflow connection profile and all workflows using that profile should just work afterwards, but I believe those using a User profile would break unless we find each case and manually edit the profile or switch it to use the Common profile. Given we have a whole lotta workflows developed over many years, this leads to my question: Is there a way to query what connection profile workflows are using (e.g., a Common versus User profile) on the SQL backend? We poked around in the workflow database the table where this information is located has not yet jumped out at us.

Best regards,

Jeff

0 0

SELECTED ANSWER

replied on August 22, 2024

There is not. Connection profiles are stored in the workflow definitions which are stored as XML blobs in the database. The data in the connection profile is encrypted.

You may be able to find them by downloading the XML and then searching for the profile IDs that match the profile IDs listed in C:\ProgramData\Laserfiche\WF\Profiles\ConnectionProfiles.xml to find the ones using Common Profiles. Though, Common Profiles are per machine and not saved in the Workflow Server because they're meant as a nicety for designing workflow, so it wouldn't be an exhaustive search.

The workflow definition is not aware of whether it used a common or user profile. The profile info is saved with the definition when the workflow is published. Updating profiles save in common profiles or user profiles has no impact on is used by running workflows until the workflow definition is republished.

Workflow can handle keeping things going through a password change with connection redirects.

1 0

replied on August 22, 2024

Greetings, Miruna:

Thank you for the information. After my initial post I did some experimenting and arrived at the conclusion that when you perform a "Copy from" a Common profile on a given workflow, that copy is not updated when you change the password on the Common profile. I'll look into the connection redirects.

Thank you for your time and guidance.

Best regards,
Jeff

0 0

Question

Question

Query for workflows using a common versus user workflow connection profile?

Answer

Replies

Sign in to reply to this post.