04-10-2019 11:58 PM
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
04-11-2019 01:22 AM
- ncs cleanup will be your favorite here.
M.
05-13-2019 08:14 PM
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
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: