Toad World® Forums

Import SharePoint 2010 List - Error Message

Hi,

Has anyone come across the following error message when importing a list from SharePoint?

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or [] are not allowed. Change the alias to a valid name.
I have checked the SharePoint List and all columns have unique names…

Any help you can offer welcome.

Thank you in advance.

Regards

David

Can you post a screenshot of the exception? I cannot reproduce the issue and I wonder where did it occur.

Thanks!

Hi Kiki,

I have attached a screenshot…

Also attached the Event log text.

Hope this helps.

Regards

David
TDA_EventLog.txt (258 KB)

Hi Kiki,

I have attached a screenshot...

Also attached the Event log text.

Hope this helps.

Regards

David

Thanks. The screenshot and log file are very helpful. It seems the issue occured during executng the insert statements in Sql Server connection. We need to see what exact insert statements Toad is executing.
Please try the following steps:

  1. Check “To File” in Tools | Execution trace ( you can check to output as well to see it in output pane)
  2. Click “Delete logfile” in Tools | Execution trace to clear the log file
  3. Do the Importing sharePoint list action again to reproduce the issue you had.
  4. Now the insert statements should be captured in the ConnectionTrace.log file located in Application data directory ( There’s a link to in about box)

Please send this log file to me for further investigation.

Thanks!