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

[TiMatrix]

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

[abhit]

Have you ruled out the encoding issues pointed by Sinhaa in the post.

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

Regards

Abhi

[rkiran]

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]

@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 

[TiMatrix]

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