FAILED TO LOAD CSV FILES FOR LinksInfo

[Wes Christensen]

This model (and several others) was running in v8.3 and producing the MDB output file. It now produces the CSV files during the run, fails to build the MDB file, and deletes all the intermediate CSV files. Otherwise the model appears to run with no issues.

There are discussions about this error ("The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine") but perhaps it should be addressed in MODSIM and/or at least documented for MODSIM users?

I am using Windows 8, 64-bit, MS Office 2013.

... 09/01/2005 00:00:00 Last Iter: 7 writing output Generating MDB output... The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. FAILED TO LOAD CSV FILES FOR LinksInfo

ERROR: System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. at System.Data.OleDb.OleDbConnection.CheckStateOpen(String method) at System.Data.OleDb.OleDbCommand.ValidateConnection(String method) at System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String method) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Csu.Modsim.NetworkUtils.ModelOutputMSDB.PopulateDBFromCSV() FAILED TO LOAD CSV FILES FOR NodesInfo

...(more error messages)

ERROR: System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. at System.Data.OleDb.OleDbConnection.CheckStateOpen(String method) at System.Data.OleDb.OleDbCommand.ValidateConnection(String method) at System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String method) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Csu.Modsim.NetworkUtils.ModelOutputMSDB.PopulateDBFromCSV() Error adjusting output columns datatypes with SQL nonquery string: ALTER TABLE TimeSteps ALTER COLUMN TSDate DateTimeSystem.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. at System.Data.OleDb.OleDbConnection.CheckStateOpen(String method) at System.Data.OleDb.OleDbCommand.ValidateConnection(String method) at System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String method) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Csu.Modsim.NetworkUtils.ModelOutputMSDB.AdjustDataTypeinTables() Done loading MDB Output. In :0.028 sec Successful completion of program MODSIM. Releasing model resources... Done (Elapsed: 1.03 mins.) Done

[Bob Lounsbury]

This error ("The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine") usually means one of two things.

1. You have 64-bit MS Office installed and you installed 32-bit MODSIM.

2. You have 32-bit MS Office installed and you installed 64-bit MODSIM.

If either of those are true you will need to follow the additional instructions here to be able to generate *.mdb model output.

[Bob Lounsbury]

I should also mention, if you are unable to complete the additional installation requirements from here, this means:

1. If you have 64-bit MS Office installed you must use 64-bit MODSIM.

2. If you have 32-bit MS Office installed you must use 32-bit MODSIM.

[Bob Lounsbury]

This is not a MODSIM bug, but a failure of Microsoft to distribute or make available 32-bit and 64-bit Microsoft Access Drivers. Long-term we would like to transition model output from Access to SQLite, which will eliminate this problem.

[Wes Christensen]

Thank you. Sorry for reporting it was a MODSIM bug.

[Bob Lounsbury]

No problem, it's a confusing piece that annoys all of us. For the next release, the installer will show a big warning dialog if it detects this issue and users will be directed to the wiki if they really want or need to use 32/64-bit MODSIM with 32/64-bit MS Office.