Skip to content

Instantly share code, notes, and snippets.

@ccondry
Created December 4, 2019 20:26
Show Gist options
  • Save ccondry/3654b45c39c07ba381e9d51cde86757a to your computer and use it in GitHub Desktop.
Save ccondry/3654b45c39c07ba381e9d51cde86757a to your computer and use it in GitHub Desktop.
Close open or stuck ECE activities

Close open or stuck ECE activities

  1. Find the open activity IDs by running this SQL query against the ECE eGActiveDb database in MSSQL Management Studio:
SELECT * FROM egpl_casemgmt_activity 
WHERE activity_status !=9000 
AND assigned_to= (SELECT user_id FROM egpl_user WHERE user_name LIKE 'georgmcc')
  1. Copy the activity IDs to a text editor, and make them a comma-separated list of IDs (or just one ID by itself is fine)
  2. Log in to ECE partition administration (Management and Administration) as pa user. Go to Tools from the main menu, then at the top of the Tools admin page, click on the Utilities button. There is a utility called Complete Activities.
  3. Run Complete Activities utility, and enter your comma-separated list of activity IDs. Click Show Details button.
  4. If your activities can be completed (i.e. they are open/not completed yet), the Complete button will be active. Click Complete to complete out those activities.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment