Unable to extend eHealth database tablespace due to disk full problem (Legacy KB ID CNC TS11694 )

Products

• CA eHealth

Issue/Introduction

CA is currently aware of this issue, and requests that you contact CA Technical Support for further assistance and reference this solution ID

Related Issues/Questions:
Unable to extend eHealth database tablespace due to disk full problem
Statistics rollup failure due to unique constraint violation
Disk partition at 100%
Statistics index failure due to unique constraint violation
Poor report performance due to table index failure
Error: Sql Error occurred during operation: 'ORA-00001: unique constraint (EHEALTH.NH_STATS1_1027051199_IX1) violated
NH_STATS0 tables have small number of rows and have inaccurate create dates.

Ex:

        Table Name                          Num Rows   Create Date
        NH_STATS0_1027007999   3                  24-02-2003-08:18:03

        NH_STATS0_1027015199   6                  24-02-2003-08:18:00

        NH_STATS0_1027018799   4                  24-02-2003-08:18:01

        NH_STATS0_1027025999   16                24-02-2003-08:17:59
NH_STATS1 tables have small number of rows and have inaccurate create dates.

Ex:

       Table Name                          Num Rows   Create Date
       NH_STATS1_1026878399    6                 21-02-2003-20:03:20

       NH_STATS1_1026964799    2                 21-02-2003-20:03:24

       NH_STATS1_1027051199    11               21-02-2003-20:03:27

Problem Environment:
eHealth 5.5
Oracle

Causes of this problem:
' As-polled' ( NH_STATS0 ) statistic tables were created after rollups occurred preventing further rollups due to the fact that associated NH_STATS1 tables were already created.


(Legacy KB ID CNC TS11694 )

Environment

Release:
Component: EHCON