topic Re: Configuring DataExportDump.pl command line in Active IQ Unified Manager Discussions

Configuring DataExportDump.pl command line

__Lenny_Blum_15126 — Thu, 05 Jun 2025 07:30:35 GMT

2 questions.

1. Looking for documentation regarding the configuration and possible options for DataExportDump and dfm data export/schedule. I have used the help option provided in the command line, but was looking for something more comprehensive

2. running into an issue when running DataExportDump.

-> Use of uninitialized value in concatenation (.) or string at <<install>>\DataExportDump.pl line 112.

followed by

Use of uninitialized value in concatenation (.) or string at <<install>>/DumpData.pm line 385.

DBD::mysql::db do failed: Column count doesn't match value count at row 1 at <<Perl>>/lib/DumpData.pm line 385.

Use of uninitialized value in die at <<Perl>>/lib/DumpData.pm line 388.

Died at <<Perl>> /lib/DumpData.pm line 388.

any help would be greatly appreciated.

Lenny

Re: Configuring DataExportDump.pl command line

adaikkap — Tue, 17 Feb 2009 21:45:12 GMT

Hi Lenny,

Pls take a look at TR 3690 "Access to DataFabric Manager and Performance Advisor Data Using Database Access and Data Export"

http://media.netapp.com/documents/tr-3690.pdf

Regards,

adai

Re: Configuring DataExportDump.pl command line

__Lenny_Blum_15126 — Tue, 17 Feb 2009 23:19:07 GMT

Thanks that was helpful.

What about documentation regarding DataExportDump?

Re: Configuring DataExportDump.pl command line

shridhar — Wed, 18 Feb 2009 11:47:04 GMT

Hi Lenny,

Can we know your exact requirement.

Please note that DataExportDump.pl is a sample Perl script to load exported DFM/PA data (present in CSV/TAB seperated files)
to MySQL database.

If that is what you want to do then extract OM_DataExport_Tool.zip on your local DFM server.
The OM_DataExport_Tool.zip contains README.txt and DataExportDump_Flow.doc which explains the
pre-requisites and working of DataExportDump.pl respectively. Follow the instructions mentioned
in README.txt. You need to specify DFM server and MySQL server details in config.txt

Before executing the script, the Data Export feature has to be run atleast once. You can set a schedule to do periodic data export
using the cli 'dfm data export schedule set'.

Once DFM and PA data had been exported to CSV/Tab seperated text files, you can execute DataExportDump from your DFM server as follows:

$> perl DataExportDump.pl -p /opt/NTAPdfm/dataExport/ -c config.txt

The -p option specifies the path where your exported files exist. By default, on a Linux server DFM/PA data gets exported to
/opt/NTAPdfm/dataExport/ and on a Windows server it will be C:\Program Files\NetApp\DataFabric\DFM\dataExport\

Regards,

Shridhar

Re: Configuring DataExportDump.pl command line

__Lenny_Blum_15126 — Wed, 18 Feb 2009 18:35:22 GMT

That is what I have done. In fact, I just tried it again, and I got the same error.

Would be great to have some additional documentation on DataExport

Re: Configuring DataExportDump.pl command line

__Lenny_Blum_15126 — Wed, 18 Feb 2009 19:28:46 GMT

I needed to export the Performance Data. Not sure if I needed to do only for the first time or not, time will tell.

Seems like the dbexporttrack was depending on the PA date. not sure why.