IBM Support

Exported CSV file from a graph is missing older data

Troubleshooting


Problem

When export a graph to CSV file, and if data range selected for it is longer than one day, the exported CSV file will only contain the data of the past 24 hours.

Symptom

In RTM 9.1.4, when you export a graph to CSV file, and if data range selected for this graph is longer than one day, the exported CSV file will only contain the data of last 24 hours. The earlier data on the graph are not being exported to the CSV file.

Cause

This is a known issue in Cacti 0.8.8.b version, and RTM 9.1.4 is based on Cacti 0.8.8.b. This issue has already been fixed in Cacti 0.8.8.d and above versions

Resolving The Problem

In order to fix this, you can backup the existing ${RTM_TOP}/cacti/graph_xport.php (default ${RTM_TOP} is /opt/IBM). Download Cacti 0.8.8.d or above from Cacti web site and extract file graph_xport.php from it and save it to ${RTM_TOP}/cacti, then exported CVS file will contain correct data.

In order to find the cacti version for the RTM installation, we can run the following command to verify:


# mysql cacti -e "select * from version"
+--------+
| cacti |
+--------+
| 0.8.8b |
+--------+

[{"Product":{"code":"SSVMSD","label":"Platform RTM"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1.4","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

isg3T1023129

Page Feedback