utk
Posts: 47
Joined: Tue Feb 07, 2012 3:26 am
Location: Canada
Contact: Website

EX_READERDBEXCEPTION error

Sat Jul 26, 2014 2:26 am

I am having issues setting up Event Rules. When I click on event rules with a specific application, I get the warning EX_READERDBEXCEPTION

Any feedback on this as i can't figure it out. All my other apps allow events to be set up.

User avatar
johan
GpsGate
Posts: 15404
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: EX_READERDBEXCEPTION error

Sat Jul 26, 2014 8:07 am

Check in the error log for more details. You find the error log under C:\GpsGateServer\ErrorLog

Regards,
Johan

GpsGate Support

utk
Posts: 47
Joined: Tue Feb 07, 2012 3:26 am
Location: Canada
Contact: Website

RE: EX_READERDBEXCEPTION error

Mon Jul 28, 2014 9:17 pm

Here is the log info
2014-07-28 10:03:42.7727 | Error | 6 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Error executing reader (Franson.DAO.ReaderDBException)
at Franson.DAO.DAOReaderBase.<Execute>d__0.MoveNext()
at GpsGate.Online.Directory.DAO.DeviceReaderDAOSQL.<GetByDeviceTypesInTags>d__33.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at GpsGate.Online.Notification.Sms.SmsNotifier.<Validate>d__0.MoveNext()
at Franson.Validation.CustomValidationAttribute.<Check>d__0.MoveNext()
at Franson.Validation.Validator.<Validate>d__9.MoveNext()
at GpsGate.Online.Event.EventExpressionEvaluatorWriter.<CheckNotifiers>d__1b.MoveNext()
at Franson.Validation.CustomValidationAttribute.<Check>d__0.MoveNext()
at Franson.Validation.Validator.<Validate>d__9.MoveNext()
at GpsGate.Admin.Service.EventRuleFacade.GetRules(Int32 iApplicationID)
at GpsGate.Admin.Service.json.EventRule.GetRules(Int32 appId)
ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.19]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tag_id IN (286)' at line 1 (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOReaderBase.<Execute>d__0.MoveNext()

User avatar
johan
GpsGate
Posts: 15404
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: EX_READERDBEXCEPTION error

Mon Jul 28, 2014 11:28 pm

As a first step, please make sure all your plugins are up to date. All "green" under SiteAdmin -> Plugins.

Regards,
Johan

GpsGate Support

utk
Posts: 47
Joined: Tue Feb 07, 2012 3:26 am
Location: Canada
Contact: Website

RE: EX_READERDBEXCEPTION error

Tue Jul 29, 2014 3:01 am

All are updated

User avatar
johan
GpsGate
Posts: 15404
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: EX_READERDBEXCEPTION error

Tue Jul 29, 2014 11:44 am

Please send a login to your application to support @ gpsgate.com and we will take a look at this. Please specify the name of the event rule you have problems with.

Regards,
Johan

GpsGate Support

utk
Posts: 47
Joined: Tue Feb 07, 2012 3:26 am
Location: Canada
Contact: Website

RE: EX_READERDBEXCEPTION error

Tue Jul 29, 2014 8:55 pm

Corrected the problem by saving as a template then terminating the original application and reentering the vehicles and users. Maybe not the best way but I needed this done for a demo I had planned.

utk
Posts: 47
Joined: Tue Feb 07, 2012 3:26 am
Location: Canada
Contact: Website

RE: EX_READERDBEXCEPTION error

Thu Aug 07, 2014 10:16 pm

Sorry i was mistaken. The problem has come back. Will send you the info requested.

Return to “GpsGate Server - How to setup and use”