SYMPTOMS

GRT Wizard is getting locked/hanged with the message shown - 

GRT process is currently in progress at terminal <TERMINAL> by <USER>. Please wait for the process to be complete. 

CAUSE

The GRT Wizard gets locked, if for some reason, one user who was using the GRT Wizard kills the process from Task Manager . Other users whose sessions were thus killed cannot use the GRT Wizard module thereafter.

RESOLUTION

Follow the steps as given to resolve the issue.

1. Open the database using any of the following tools - TOAD, SQL Plus, SQL Developer.
2. Log onto the client schema.
3. In the OPERATION_LOG table - 
   1. Click on the Data button, to see the list of current users of Ginesys HO. 
   2. Delete the record of the source terminal (who has locked GRTWizard) as shown in the error message as "terminal <TERMINAL>" .

GRT Wizard should now work fine.

This should resolve your issue, in case you face it again please contact our Ginesys Care portal - https://care.ginesys.in/ 

RELATED ARTICLES