Database Error ORA-08103 object no longer exists appears in OneClick when we try to display the details under Polling Management

Products

• CA eHealth

Issue/Introduction

Description:

The database error below appears in OneClick when we try to display the details of polling errors under "Polling Management". Once we click on "OK", the pop-up disappears and the "All Errors" tree branch appears.

 Database Error: 
 ------------------------------------------------------------   
 ORA-08103: object no longer exists [ KSQL:ExecQuery : OCIStmtExecute ]   
 ------------------------------------------------------------   
 select error_type, count(distinct BP.machine_id || BP.element_id ||   
 error_type)   
 from NHV_STATS_POLL_ERROR_ELEMENT BP, NH_ELEMENT E   
 where error_utc >= 1293095660   
 and (BP.machine_id=E.machine_id and BP.element_id=E.element_id)   
 group by error_type   
 ----   
 0 num rows affected... 

 Problem Ticket: PRD00032578

Solution:

This error message appears in OneClick when the "poll info" table is being rebuilt by the Poller while we try to expand "Polling Management" details.

To fix the issue we have improved the performance of SQL query to extend the wait/sleep time between the retries so that it does not throw the error

The issue documented above has been resolved in the following release(s):

eHealth 6.3 D05

eHealth Service Packs are available for download from support.ca.com. Please review the README file for each Service Pack prior to installing. CA Technologies recommends that users always keep eHealth current by installing the latest Service Pack available.

Environment

Release: LHBASC99000-6.2-eHealth-Live Health Upgrade Elements
Component: