Active IQ Unified Manager Discussions

Custom Schema and Dictionary - Error "Row 1 doesn't contain data for all columns"

TiMatrix
3,912 Views

Hi guys,

 

I want to import a list of backups created via SMSAP into WFA db.

 

 

This list looks like (all columns are separated by tabs):

 

2016-03-30 12:30:15 SUCCESS FULL ONLINE EXISTS F_A_20160330083017EDT
2016-03-30 11:30:15 SUCCESS FULL ONLINE EXISTS F_A_20160330073041EDT
2016-03-30 11:00:25 SUCCESS FULL ONLINE EXISTS F_A_20160330070056EDT
2016-03-30 10:30:15 SUCCESS FULL ONLINE EXISTS F_A_20160330063018EDT
2016-03-30 10:17:58 SUCCESS FULL ONLINE EXISTS F_A_20160330061831EDT
2016-03-30 10:10:16 SUCCESS FULL ONLINE EXISTS F_A_20160330061038EDT
2015-05-06 01:55:43 SUCCESS FULL ONLINE EXISTS F_A_20150505215543EDT

 

This list will be exported to a file. I have done this according to this thread:

 

http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Discussions/Failure-in-data-acquisition-for-a-custom-data-source-type-csv/td-p/98...

 

The file looks like:

\N 2016-03-30 12:30:15 SUCCESS FULL ONLINE EXISTS F_A_20160330083017EDT
\N 2016-03-30 11:30:15 SUCCESS FULL ONLINE EXISTS F_A_20160330073041EDT
\N 2016-03-30 11:00:25 SUCCESS FULL ONLINE EXISTS F_A_20160330070056EDT
\N 2016-03-30 10:30:15 SUCCESS FULL ONLINE EXISTS F_A_20160330063018EDT
\N 2016-03-30 10:17:58 SUCCESS FULL ONLINE EXISTS F_A_20160330061831EDT
\N 2016-03-30 10:10:16 SUCCESS FULL ONLINE EXISTS F_A_20160330061038EDT
\N 2015-05-06 01:55:43 SUCCESS FULL ONLINE EXISTS F_A_20150505215543EDT

 

When I try an "acquire now", I get the error "Row 1 doesn't contain data for all columns".

 

The table has 7 columns.

 

Where can I find to root cause, why WFA throws this error?

 

Thanks,

Tino

 

4 REPLIES 4

abhit
3,892 Views

rkiran
3,884 Views

I am not seeing the issue. I have created a custom scheme, dictionary entry and a data source acquisition script in Perl. Tried to read the file content (same as mentioned below) and saved into a .CSV file. I was able to see the data in the SQL table.

sinhaa
3,881 Views

@TiMatrix

 

This error shows that your CSV files that got created doesn't have all columns for one or more dictionary items. See, your CSV file will be like a copy of how your DB for a table will look like. 

 

There is some error in your Data Source acquistion script. All columns for every table( i.e. dictionary) are not getting added by the script. You need to check that

 

sinhaa 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

TiMatrix
3,854 Views

Thank you all for the input. I have imported the file to Excel (had the file opened in Notepad++ and Wordpad) and run the function 'text-to-columns'. There is no TAB (`n) between each columns. I have to correct this.

 

Thanks,

Tino

Public