Installation error

[ian312]

I installed on the EC2 instance setting up and getting error:
SQL logic error or missing database
near "?": syntax error

[admin]

There seems to be a problem accessing the database file. Please check if you have read/write access to:

C:\ProgramData\AutomatiCloud\AutomatiCloud.sqlite

If you don't see the file at all please uninstall and reinstall AutomatiCloud.

Stephan

[ian312]

I gave the user I am logged in with Full Permissions on the File with the same error being produced.
Then I re-installed the software. Including downloading an fresh copy.
I can provide the Stack Trace of that will help to troublehshoot.

[admin]

please start AutomatiCloud as Administrator and end send the logfile AutomatiCloudLog.txt.

Stephan

[ian312]

thanks for taking a look Stephan

[admin]

The logfile is fine. When does this error come? Can you send me the stack trace please.

Stephan

[ian312]

at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at Globals.SaveSettings() in L:\PROJECTS\CloudScheduler\CloudScheduler\Globals.cs:line 199
at AutomatiCloud.frmSettings.geDhbk5har(Object , EventArgs ) in L:\PROJECTS\CloudScheduler\CloudScheduler\SettingsForm.cs:line 82
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[admin]

this seems to happen when you save the settings. Can you please please fill only the two fields "Access Key" and "Secret Key" and leave all other fields empty.

Stephan

[ian312]

thanks for all your help.
Im all setup and creating a new job.