The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to register at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

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

 

4 REPLIES 4

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 

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

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

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.

abhit
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public