Unable to add network element data error

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

Issue: 

Seeing messages like the the following, in the system.log: 

"Unable to add network element' data to the database" and 

"Unable to execute 'CREATE TABLE nh_stats0_nnnnnnn MONITORING LOGGING PTCTFREE 10 PCTUSED 75 TABLESPACE NH_DATA01 AS SELECT * FROM NH_RLP_STATS '(ORA-01658: unable to create INITAL extent for segment in tablespace N)" 

 

Environment:  

   Applicable to all versions of eHealth

 

Cause

    The current datafile for a given tablespace has filled up, reaching 32GB in size

 

Resolution: 

       1. Determine which datafiles need to be created, by running "$NH_HOME/bin/sys/nhiShowDbSpace all"

           This will return 3 reports; one on "tablespaces", one on "file system"  and one on "datafiles". It is the third one that we want to look at. (Datafiles for tablespace NH_DATA01 will be named as follows; NH_DATA01A, NH_DATA01B, NH_DATA01C, etc.)

Look at the latest file, in this example, NH_DATA01C. If this is listed as being 32GB, you'll need to create an additional data file for the NH_DATA01 tablespace

      2. Use nhManageDbSpace, to create the datafile   (DB must be running)

nhManageDbSpace -add -newPath <directory> -tablespace NH_DATA01 -size 2000M

This will create an additional 2GB datafile for the NH_DATA01 tablespace, named, in this example, "NH_DATA01D". This all depends on how many datafiles have already been used, by this tablespace. 

This new datafile will automatically grow, until it reaches 32GB

      3. Restart eHealth