Queue data in client 0 cannot be retrieved.

book

Article ID: 140788

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

Within client 0 --> click on Process Monitoring --> all Queues --> the following exception is thrown.

2019-08-27 10:20:52,654 http-bio-8443-exec-454 [ERROR] AE_DEV:0/USER/DEPARTMENT NOUI 0000000005391192 [controls.messageprovider.MessageProvider] - Error message shown to user: Queue data could not be retrieved.

java.lang.NullPointerException: null

Cause

NPE exception occurs because one of the listed queues (in All Queues) has an inconsitent STATE.

Java-Api/Backend/DB delivers wrong (null) value. Value (QueueStatus) should be either active, inactive, or deactivated (0,1,2).

Environment

Release : 12.2 and 12.3

Component : AUTOMIC WEB INTERFACE

Resolution

To solve this issue please do the following steps:

1. Check in the database if there is an invalid QUEUE entry using the following query

SELECT a.OUA_OH_Idnr
,a.OUA_IsStopped
,b.OH_Name
FROM OUA a, OH b
WHERE a.OUA_OH_Idnr = b.OH_Idnr and a.OUA_IsStopped not in ('0','1','2')

2. Login to AWI and open the Queue Table in the Administration perspective

3. Search for the affected Queues (Result of the Database query in step 1) in the table

4. Right Click on the Queue and select Stop or Start Queue (Database entry gets updated with a valid value)

5. Then set back the state to the desired one

6. Reload or open Process Monitoring again. Queues can now be loaded