cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
197
Views
0
Helpful
2
Replies
Beginner

Tablespace TS_TRAFFIC is at 99.99866% out of the maximum size of 100GB and has violated threshold limit of 90%. Reduce the retention period / make sure the daily pure job is running

Hi All,

 

Anyone seen below error in Cisco Prime Infrastructure

 

Tablespace TS_TRAFFIC is at 99.99866% out of the maximum size of 100GB and has violated threshold limit of 90%. Reduce the retention period / make sure the daily pure job is running

 

++ CPI running on 3.4.0.0.348
++ Running on a VM 
++ Checked the space in DB. Shows below
++ ade # df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/smosvg-localdiskvol
130G 76G 48G 62% /localdisk
/dev/mapper/smosvg-optvol
705G 274G 396G 41% /opt

 

Will this get fixed if the Local Disk space is cleared or if we perform a ncs cleanup.

 

Any suggestions would be appreciated.

 

Regards

Binny

2 REPLIES 2
Rising star

Re: Tablespace TS_TRAFFIC is at 99.99866% out of the maximum size of 100GB and has violated threshold limit of 90%. Reduce the retention period / make sure the daily pure job is running

 

  - ncs cleanup will be your favorite here.

  M.

Beginner

Re: Tablespace TS_TRAFFIC is at 99.99866% out of the maximum size of 100GB and has violated threshold limit of 90%. Reduce the retention period / make sure the daily pure job is running

Hi Marc,

 

Cleanup did not work.

 

I had to reach out Cisco for this where in they have suggested to upgrade since we are hitting a Bug. They are suspecting this as a Bug and they have some workaround but they recommend to go with the upgrade for permanent fix.

 

TABLESPACE_NAME       Current_Size   Max_Size      AUT

TS_TRAFFIC                       100                100             YES

 

 

CSCvg46100 - PI's performance is impacted when the Data Cleanup job fails to clean job entries

 

[] [seqtaskexecutor-232] [xmp_prune] [ERROR] - Caught exception in deleteRecordInChunk        java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (WCSDBA.FK473D99AA1E968491) violated - child record found

 

 

CSCvm53104 -  High disk I/O read on Prime Infrastructure application

 

/opt/CSCOlumos/bin/sql_execution.sh "select pruneorder from dmm_pruningservicedata where tablename='JOBMESSAGE' and whereclause like '%jobspecification_i%'";

 

          PRUNEORDER

        --------------------

                   1

 

 

If someone comes around this issue, Upgrade the Cisco Prime to 3.5 would be recommended.

 

Regards

Binny

 

CreatePlease to create content
Content for Community-Ad
July's Community Spotlight Awards