piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

SharedBatch update error.

Sat Jul 11, 2015 12:24 am

Hi Support,

Since yesterday 10/June/2015 from NMEA log error file I get thousand of error message like this:

2015-07-11 03:11:37.7640 | Error | 30 | NmeaConnection.Dispose | Error disposing | System.InvalidOperationException: DataTable internal index is corrupted: '5'.
at System.Data.DataTable.RestoreIndexEvents(Boolean forceReset)
at System.Data.Merger.MergeTable(DataTable src, DataTable dst)
at System.Data.Merger.MergeTableData(DataTable src)
at System.Data.Merger.MergeDataSet(DataSet source)
at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction)
at System.Data.DataSet.Merge(DataSet dataSet)
at Franson.DAO.SharedBatch._BatchDAO._Update()
at Franson.DAO.SharedBatch._BatchDAO.RemoveRow(String strTableName, DataRow row)
at Franson.DAO.DAOBase.Dispose()
at GpsGate.Online.GateUser.Dispose()
at GpsGate.Online.Net.NmeaConnection.Dispose()
2015-07-11 03:11:38.0921 | Error | 40 | _BatchDAO._TimerUpdate | SharedBatch update error. Key: | System.InvalidOperationException: DataTable internal index is corrupted: '5'.
at System.Data.DataTable.RestoreIndexEvents(Boolean forceReset)
at System.Data.Merger.MergeTable(DataTable src, DataTable dst)
at System.Data.Merger.MergeTableData(DataTable src)
at System.Data.Merger.MergeDataSet(DataSet source)
at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction)
at System.Data.DataSet.Merge(DataSet dataSet)
at Franson.DAO.SharedBatch._BatchDAO._Update()
at Franson.DAO.SharedBatch._BatchDAO._TimerUpdate(Object oState)
Please help.

Best Regards,
piter197

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

RE: SharedBatch update error.

Sat Jul 11, 2015 1:10 am

This is a known error. It is harmless, but it fills up the error log.

To get rid of it you can restart the Service under SiteAdmin -> Service

1. Login to SiteAdmin
2. Go to Service
3. Click on Stop and wait for 30 seconds.
4. Click on Start to start the service again.

There is an issue when restarting the service that "BlockEnabled" stays enabled. To avoid that update Patch.v4 from beta.gpsgate.com

We will look into why this error sometimes happens, and have a fix in a coming update.

Regards,
Johan

GpsGate Support

piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

RE: SharedBatch update error.

Sat Jul 11, 2015 1:29 am

Hi Johan,

Restarting Service solve the problem. FYI before this happen, I already install recent update of Patch.v4 from beta.gpsgate.com.

Thank you.

Best Regards,
piter197

grigor
Posts: 90
Joined: Mon May 14, 2012 6:41 pm
Location: Albania
Contact: Facebook Twitter Skype

RE: SharedBatch update error.

Sun Sep 13, 2015 12:18 pm

Hello dear,

I have the same problem on error log, please could some one give suggestion:

2015-09-12 19:56:39.5645 | Error | 111 | _BatchDAO._TimerUpdate | SharedBatch update error. Key: | System.InvalidOperationException: DataTable internal index is corrupted: '13'.
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.DataTable.FindByIndex(Index ndx, Object[] key)
at System.Data.DataTable.FindMergeTarget(DataRow row, DataKey key, Index ndx)
at System.Data.Merger.MergeTable(DataTable src, DataTable dst)
at System.Data.Merger.MergeTableData(DataTable src)
at System.Data.Merger.MergeDataSet(DataSet source)
at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction)
at System.Data.DataSet.Merge(DataSet dataSet)
at Franson.DAO.SharedBatch._BatchDAO._Update()
at Franson.DAO.SharedBatch._BatchDAO._TimerUpdate(Object oState)

Thanks and regards,
Grigor

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

RE: SharedBatch update error.

Sun Sep 13, 2015 8:15 pm

This is fixed since the August release of Patch.v4

Regards,
Johan

GpsGate Support

way4net_krumnow
Posts: 38
Joined: Thu Mar 07, 2013 1:31 pm
Location: Germany

RE: SharedBatch update error.

Wed Oct 28, 2015 9:40 am

We have for some days registered a SharedBatch update error taking some space in the errorlog. As it is a little different I post it here. Seems to have no negative issues other than blowing the errorlog for some kbytes:

2015-10-28 00:04:29.1964 | Error | 11 | _BatchDAO._TimerUpdate | SharedBatch update error. Key: | Error updating database table gate_event (Franson.DAO.UpdateDBException)
at Franson.DAO.DAOBase.Update()
at Franson.DAO.SharedBatch._BatchDAO._Update()
at Franson.DAO.SharedBatch._BatchDAO._TimerUpdate(Object oState)
Concurrency violation: the batched command affected 1 of the expected 2 records. (System.Data.DBConcurrencyException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Update()

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

RE: SharedBatch update error.

Wed Oct 28, 2015 11:39 am

Are you using MySQl or MSSQL?

I assume you have updated Patch.v4 from beta.gpsgate.com. Please update Patch.v4 again and see if the error is resolved.

Regards,
Johan

GpsGate Support

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