search cancel

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

book

Article ID: 213785

calendar_today

Updated On:

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;