Zeta crashing when try to export to Excel

39 views
Skip to first unread message

Anthony Harel

unread,
Oct 10, 2022, 7:37:29 AM10/10/22
to Zeta Resource Editor
Hi, 

With Zeta resource Editor v2.3.33.0, I've got the following error when trying to export data to Excel :



System.Data.SQLite.SQLiteException

-----------------

unable to open database file

-----------------

at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
   at System.Data.SQLite.SQLiteConnection.Open()
   at ZetaResourceEditor.RuntimeBusinessLogic.Snapshots.SnapshotControllerBase.doesTableExist(String tableName) in c:\P\zeta-resource-editor\Source\RuntimeBusinessLogic\Snapshots\SnapshotControllerBase.cs:line 123
   at ZetaResourceEditor.RuntimeBusinessLogic.Snapshots.SnapshotControllerBase.checkTablesCreated() in c:\P\zeta-resource-editor\Source\RuntimeBusinessLogic\Snapshots\SnapshotControllerBase.cs:line 96
   at ZetaResourceEditor.RuntimeBusinessLogic.Snapshots.SnapshotControllerBase.Initialize() in c:\P\zeta-resource-editor\Source\RuntimeBusinessLogic\Snapshots\SnapshotControllerBase.cs:line 20
   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.doProcess(PreparedInformation preparedInformation, BackgroundWorker bw, Int32 fileGroupsLength, ICollection`1 savedFiles) in c:\P\zeta-resource-editor\Source\RuntimeBusinessLogic\ExportImportExcel\Export\ExcelExportController.cs:line 319
   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.Process(BackgroundWorker bw) in c:\P\zeta-resource-editor\Source\RuntimeBusinessLogic\ExportImportExcel\Export\ExcelExportController.cs:line 304
   at ZetaResourceEditor.UI.ExportImportExcel.ExcelExportWizardForm.progressBackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) in c:\P\zeta-resource-editor\Source\Main\UI\ExportImportExcel\ExcelExportWizardForm.cs:line 662
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

SQLiteException
{
    ResultCode=CantOpen,
    ErrorCode=14,
    IsTransient=False,
    SqlState=null,
    BatchCommand=null,
    TargetSite=RuntimeMethodInfo: Open,
    Message="unable to open database file",
    Data=
    [
    ]
,
    InnerException=null,
    HelpLink=null,
    Source="System.Data.SQLite",
    HResult=-2147481601,
    StackTrace="   at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)\\r\\n   at System.Data.SQLite.SQLiteConnection.Open()\\r\\n   at ZetaResourceEditor.RuntimeBusinessLogic.Snapshots.SnapshotControllerBase.doesTableExist(String tableName) in c:\\P\\zeta-resource-editor\\Source\\RuntimeBusinessLogic\\Snapshots\\SnapshotControllerBase.cs:line 123\\r\\n   at ZetaResourceEditor.RuntimeBusinessLogic.Snapshots.SnapshotControllerBase.checkTablesCreated() in c:\\P\\zeta-resource-editor\\Source\\RuntimeBusinessLogic\\Snapshots\\SnapshotControllerBase.cs:line 96\\r\\n   at ZetaResourceEditor.RuntimeBusinessLogic.Snapshots.SnapshotControllerBase.Initialize() in c:\\P\\zeta-resource-editor\\Source\\RuntimeBusinessLogic\\Snapshots\\SnapshotControllerBase.cs:line 20\\r\\n   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.doProcess(PreparedInformation preparedInformation, BackgroundWorker bw, Int32 fileGroupsLength, ICollection`1 savedFiles) in c:\\P\\zeta-resource-editor\\Source\\RuntimeBusinessLogic\\ExportImportExcel\\Export\\ExcelExportController.cs:line 319\\r\\n   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.Process(BackgroundWorker bw) in c:\\P\\zeta-resource-editor\\Source\\RuntimeBusinessLogic\\ExportImportExcel\\Export\\ExcelExportController.cs:line 304\\r\\n   at ZetaResourceEditor.UI.ExportImportExcel.ExcelExportWizardForm.progressBackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) in c:\\P\\zeta-resource-editor\\Source\\Main\\UI\\ExportImportExcel\\ExcelExportWizardForm.cs:line 662\\r\\n   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)\\r\\n   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)"
}

Gabriel Stabentheiner

unread,
Nov 30, 2022, 11:14:33 AM11/30/22
to Zeta Resource Editor
Ich habe das gleiche Problem! Wäre sehr froh um Hilfe!

Mir ist aufgefallen, dass in der Fehlermeldung als Pfadangabe steht:  "c:\P\zeta-resource-editor\..."
Der richtige Pfad wäre "c:\Program Files" ...

Hier die komplette Meldung:
Reply all
Reply to author
Forward
0 new messages