Active IQ Unified Manager Discussions

Configuring DataExportDump.pl command line

__Lenny_Blum_15126
3,544 Views

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

5 REPLIES 5

adaikkap
3,544 Views

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

__Lenny_Blum_15126
3,544 Views

Thanks that was helpful.

What about documentation regarding DataExportDump?

shridhar
3,544 Views

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

__Lenny_Blum_15126
3,544 Views

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

__Lenny_Blum_15126
3,544 Views

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.

Public