Error when creating MSSQL Dbase

[ryderhaggard]

Error Message:

An Unhandled Exception has occured and the program will now close. Copy the data below and send to developer.

Source: ImportTranslationLanguages Message: No connection associated with this command Raw Error Text: System.InvalidOperationException: No connection associated with this command at System.Data.SQLite.SQLiteCommand.InitializeForReader() at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at EVE_SDE_Database_Builder.SQLiteDB.SelectfromTable(List1 SelectFieldValues, String SelectTableName, List1 SelectWhereClause, Boolean& RecordsFound) at EVE_SDE_Database_Builder.SQLiteDB.DropTable(String TableName) at EVE_SDE_Database_Builder.SQLiteDB.CreateTable(String TableName, List`1 TableStructure) at EVE_SDE_Database_Builder.YAMLTranslations.ImportTranslationLanguages(ImportParameters Params, Boolean ImportTable, Boolean ShowProgress) at EVE_SDE_Database_Builder.frmMain.BuildEVEDatabase(Object UpdateDatabase, DatabaseType DatabaseType) at EVE_SDE_Database_Builder.frmMain.btnBuildDatabase_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Database is created, translationColumns table is created, no data is imported and error occurs.

[Darconica]

I got different error message when creating MSSQL Dbase

An Unhandled Exception has occured and the program will now close. Copy the data below and send to developer.

Source: Message: Kan een aantal of alle id-verwijzingen niet omzetten. Raw Error Text: System.Security.Principal.IdentityNotMappedException: Kan een aantal of alle id-verwijzingen niet omzetten. bij Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) bij Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure) bij Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) bij Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) bij EVE_SDE_Database_Builder.frmMain.BuildEVEDatabase(Object UpdateDatabase, DatabaseType DatabaseType) bij EVE_SDE_Database_Builder.frmMain.btnBuildDatabase_Click(Object sender, EventArgs e) bij System.Windows.Forms.Control.OnClick(EventArgs e) bij System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) bij System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) bij System.Windows.Forms.Control.WndProc(Message& m) bij System.Windows.Forms.ButtonBase.WndProc(Message& m) bij System.Windows.Forms.Button.WndProc(Message& m) bij System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[Zifrian]

Thank you both, I pushed a patch to fix a related error. Let me know if this isn't working correctly.

[Darconica]

I update to the latest version aviable and I'm still getting the same error on creatien Mssql Dbase.

[Zifrian]

I update to the latest version aviable and I'm still getting the same error on creatien Mssql Dbase.

Can you tell me more? When does this happen? I'm not having any issues with creation. What settings are you using? Thanks

[Darconica]

I'm using the default settings and english as language setting. Also I was mistaken it was not during mssql dbase creation but during ms acces dbase creation

[Zifrian]

Thanks. I made several bug fixes to translations, and the ms Access DB import is working. Let me know if you still get the error and when. Thanks

[ryderhaggard]

Downloaded latest version, deleted the aborted attempt to create the Dbase, and re-ran. got the following error still.

An Unhandled Exception has occured and the program will now close. Copy the data below and send to developer.

Source: ImportTranslationLanguages Message: No connection associated with this command Raw Error Text: System.InvalidOperationException: No connection associated with this command at System.Data.SQLite.SQLiteCommand.InitializeForReader() at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at EVE_SDE_Database_Builder.SQLiteDB.SelectfromTable(List1 SelectFieldValues, String SelectTableName, List1 SelectWhereClause, Boolean& RecordsFound) at EVE_SDE_Database_Builder.SQLiteDB.DropTable(String TableName) at EVE_SDE_Database_Builder.SQLiteDB.CreateTable(String TableName, List`1 TableStructure) at EVE_SDE_Database_Builder.YAMLTranslations.ImportTranslationLanguages(ImportParameters Params, Boolean ImportTable, Boolean ShowProgress) at EVE_SDE_Database_Builder.frmMain.BuildEVEDatabase(Object UpdateDatabase, DatabaseType DatabaseType) at EVE_SDE_Database_Builder.frmMain.btnBuildDatabase_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[ryderhaggard]

Bit more info:

The database is created, the following table is created: translationColumns

with the following structure columnName nvarchar(128) Checked masterID nvarchar(128) Checked tableName nvarchar(256) Checked tcGroupID smallint Checked tcID smallint Checked Unchecked

No content is populated.

[Zifrian]

Downloaded latest version, deleted the aborted attempt to create the Dbase, and re-ran. got the following error still.

An Unhandled Exception has occured and the program will now close. Copy the data below and send to developer.

Source: ImportTranslationLanguages Message: No connection associated with this command Raw Error Text: System.InvalidOperationException: No connection associated with this command at System.Data.SQLite.SQLiteCommand.InitializeForReader() at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at EVE_SDE_Database_Builder.SQLiteDB.SelectfromTable(List1 SelectFieldValues, String SelectTableName, List1 SelectWhereClause, Boolean& RecordsFound) at EVE_SDE_Database_Builder.SQLiteDB.DropTable(String TableName) at EVE_SDE_Database_Builder.SQLiteDB.CreateTable(String TableName, List`1 TableStructure) at EVE_SDE_Database_Builder.YAMLTranslations.ImportTranslationLanguages(ImportParameters Params, Boolean ImportTable, Boolean ShowProgress) at EVE_SDE_Database_Builder.frmMain.BuildEVEDatabase(Object UpdateDatabase, DatabaseType DatabaseType) at EVE_SDE_Database_Builder.frmMain.btnBuildDatabase_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I've tried several times and options to reproduce this error and I can't get it to pop up. Can you send a screen of the form with the options you are using?

[Darconica]

I keep getting errors on ms acces dbase creation.

An Unhandled Exception has occured and the program will now close. Copy the data below and send to developer.

Source: Message: Some or all identity references could not be translated. Raw Error Text: System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated. at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) at EVE_SDE_Database_Builder.frmMain.BuildEVEDatabase(Object UpdateDatabase, DatabaseType DatabaseType) at EVE_SDE_Database_Builder.frmMain.btnBuildDatabase_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[Zifrian]

Some or all identity references could not be translated.

I need more information. Can you post a screenshot? Are you using a username/password for the file?