Unable to extend eHealth database tablespace due to disk full problem (Legacy KB ID CNC TS11694 )
Article ID: 52323
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.
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.
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.