Page 1 of 1

Installation error

Posted: Fri Feb 26, 2016 8:18 pm
by ian312
I installed on the EC2 instance setting up and getting error:
SQL logic error or missing database
near "?": syntax error

Re: Installation error

Posted: Fri Feb 26, 2016 10:05 pm
by 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

Re: Installation error

Posted: Sat Feb 27, 2016 12:56 am
by 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.

Re: Installation error

Posted: Sat Feb 27, 2016 5:52 pm
by admin
please start AutomatiCloud as Administrator and end send the logfile AutomatiCloudLog.txt.

Stephan

Re: Installation error

Posted: Mon Feb 29, 2016 11:55 pm
by ian312
thanks for taking a look Stephan

Re: Installation error

Posted: Tue Mar 01, 2016 10:01 pm
by admin
The logfile is fine. When does this error come? Can you send me the stack trace please.

Stephan

Re: Installation error

Posted: Tue Mar 01, 2016 10:26 pm
by 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)

Re: Installation error

Posted: Tue Mar 01, 2016 10:32 pm
by 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

Re: Installation error

Posted: Wed Mar 02, 2016 11:35 pm
by ian312
thanks for all your help.
Im all setup and creating a new job.