How to clear the state of UC user using SQL command ?

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to clear the state of UC user using SQL command .

Environment

Release : 12.3

Component : ANALYTICS ON PREMISE

Resolution

UC user state will be stored in INI table ECC.userState. 

These are the steps to clear the state using SQL command. 

1.  Backup INI table

2. Run the Below Query:

delete from ini where ini_idnr='5' and ini_section='ECC.userState';
commit;