Nevron Forum

NGraphDataSourceImporter error log?

https://www.nevron.com/Forum/Topic8397.aspx

By Michael Hachen - Friday, January 10, 2014

Hi there

I try to get the NGraphDataSourceImporter working with no luck. Is there any error log or can I get any error message why the Import fails?

I have created two sqldataadapters (Pages and Links), the SQL Connection is valid, the select Statements are valid... however I can't get it working. So I need some information about what is going wrong during the import process.

Thanks for your help!
Mike Hachen
By Nevron Support - Friday, January 10, 2014

Hi,

Check out the Visual Studio Output window for any error messages or exceptions that have occured during the import process. Also make sure that you have properly creates the Pages and Links tables and all rows have data for the columns used by the importer. You can take a look at the "Graph Data Import" example for a sample implementation.
By Michael Hachen - Friday, January 10, 2014

Hi,

Thank you for your reply.

The only message I get in the Output window is the following:

Graph datasource import failed. Exception was: The connection was not closed. The connection's current state is open.

Sorry, I don't get it... Is the Problem that the Connection is open? I set a breakpoint right befor graphImporter.Import(); --> the connection is closed. I get the same error when I manually open the connection right bevor the Import() call.

Do you have a sample Project where you use a SqlCommand as VertexDataSource and EdgeDataSource?

Thank you for your help!
Mike Hachen
By Nevron Support - Sunday, January 12, 2014

Hi,

Please, debug your database connection, make sure you don't leave an open connection to the database somewhere in your code, etc. You can also try reading the data tables you want to import to a .NET data set and use that data set for the import process to see if that solves your database problem.