eHealth is stopping and we see this error: Error,Pgm nhiPoller[Net]: Append to table nh_stats_poll_info failed (ORA-30036: unable to extend segment by 8 in undo tablespace 'NH_ROLLBA).

Document ID : KB000044614
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

eHealth is stopping and we see this error:

Error,Pgm nhiPoller[Net]: Append to table nh_stats_poll_info failed (ORA-30036: unable to extend segment by 8 in undo tablespace 'NH_ROLLBA).

System admin has already added more space to the drive, but it didn’t help. 

 

Environment: 

EHealth 6.3.x on any supported platform

 

Cause:

The error indicates that an oracle datafile is full, and not the actual drive.

Datafiles can only grow to 32g and then a new one must be added manually.

 

Resolution:

The NH_ROLLBACK datafile is handled differently from other datafiles in oracle.

Here are the steps to add a new one:

1.     Stop eHealth processes

   nhServer stop

   nhHttpd stop

 

2.     get the dbconnectstring:

   env | grep -i connect

 

3.     Start sqlplus as the sysdba user using the info from the above command:

   sqlplus "sys/ehealth@dbconnectstring as sysdba"

  

4.     Add a new datafile with the following command:

   alter tablespace NH_ROLLBACK add datafile 'D:\OracleDB\oradata\EHBECSA\NH_ROLLBACK02.dbf' size 102400000 autoextend on next 52428800 maxsize 32767M;

Make sure there is enough space at the location specified (file will start

at 1024M, but grow to 32GB), if not choose a location with sufficient space.

 

5.     Confirm that there are now two rollback files with this query:

 select file_name,bytes from dba_data_files where tablespace_name='NH_ROLLBACK';

You should have NH_ROLLBACK01.DBF and NH_ROLLBACK02.DBF

 

Additional Information:

To see the procedure to add a regular datafile, please see:

 

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec514690.aspx