Change the EPX System Password - Precisely_EnterWorks - EnterWorks_Process_Exchange_(EPX) - EnterWorks - 11.0

To change the EPX system password:

1. Use the EPX Design Console to change the system user password:
   1. On the server hosting EPX, log into the EPX Design Console as the admin user, using the current credentials.
   2. Open the host folder, open the Administration folder, and open the Users folder.

   3. In the Users folder, right-click the System Administrator (system) account, and select Open.

   4. In the User editor, on the Details tab, click Password.

   5. Type the new password twice in the appropriate boxes, then click OK.

   6. Click OK in the User editor to make the change permanent.

   7. Right-click the server in the Navigator and select Logout.

   8. Login in again using the system user and new password to verify that the password has been changed.

   9. Close the EPX Design Console.

2. Log into the SQL Server as a user with administrative permissions.
3. Copy the following script into a query window for the EPX database:

   update P_ACTIVITY_PROPERTY set PROPERTY_VALUE = 'system'
   where ACTIVITY_PROPERTY_ID in (
   select ap.ACTIVITY_PROPERTY_ID from P_ACTIVITY a
   join P_PROCESS p on p.PROCESS_ID = a.PROCESS_ID
   join P_ACTIVITY_PROPERTY ap on a.ACTIVITY_ID = ap.ACTIVITY_ID
   where a.ARC_ACTOR_NAME in ('Purge Completed Workitems BIC', 'Flow Monitor BIC')
   and ap.PROPERTY_KEY = 'userPassword')

4. In the script, change the word system that is in straight quotes to be the new, unencrypted password. Keep the straight quotes. Only replace the password itself.
5. Run the script. It should affect at least 12 rows.
6. Verify the password has been changed by executing the following SQL. All the rows generated should show the new password.

   select PROPERTY_KEY, PROPERTY_VALUE from P_ACTIVITY_PROPERTY ap
   where ACTIVITY_PROPERTY_ID in ( 
   	select ap.ACTIVITY_PROPERTY_ID from P_ACTIVITY a 
   	join P_PROCESS p on p.PROCESS_ID = a.PROCESS_ID 
   	join P_ACTIVITY_PROPERTY ap on a.ACTIVITY_ID = ap.ACTIVITY_ID 
   	where a.ARC_ACTOR_NAME in ('Purge Completed Workitems BIC', 'Flow Monitor BIC') 
   	and ap.PROPERTY_KEY = 'userPassword'
   )

7. Restart EPX services to make sure the password change goes into effect:
   1. Open a command line and go to:

      <drive>:\Enterworks\bin

   2. Run EPX Stop.cmd as an administrator.
   3. Run EPX Start.cmd as an administrator.