DataSourceValueID' is constrained to be unique.

[askthomas]

Hej

Får följande fel i SwitchKing Loggen

Level 1) Column 'DataSourceValueID' is constrained to be unique. Value '853' is already present.

Stänster stoppar efter ca 10 sekunder, hinner inte in i swicthking och kolla vad som är fel. Skulle giss på temperatur data.

Någon som vet hur men ec reensr sqllite databsen från kassa värden. Felet börjde med nör jag koppa in en nexa dimmer, och den dök upp dubbelt i telldus, så det kan vara den som bråkar med i swichking.

/Taomas

[askthomas]

Hela felmedlande kankse är bra att se.

Code: Select all

Level 1) Column 'DataSourceValueID' is constrained to be unique.  Value '853' is already present.

StackTrace for Level 1:
   at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at SwitchKing.Server.DataAccess.ExternalData.DataSources.DataSourceValueDataAccess.InternalAccessor.Get()
   at SwitchKing.Server.DataAccess.ExternalData.DataSources.DataSourceValueDataAccess.GetDataSourceValues()
   at SwitchKing.Server.BusinessAccess.DataCollection.DataSourceAccess.DataSourceValueEntity.GetDataSourceValues()
   at SwitchKing.Server.BusinessAccess.DataCollection.DataSourceAccess.DataSourceValueEntity.GetAll()
   at SwitchKing.Server.BusinessAccess.Cache.DataSourceValueCache.Initialize()
   at SwitchKing.Server.BusinessAccess.Cache.DataSourceValueCache.GetAllFlattened()
   at SwitchKing.Server.BusinessAccess.DataCollection.DataSourceAccess.DataSourceEntity.GetDataSources(Boolean includeValueData)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.EventDataSourceMapper.GetApplicableDataSources(NativeDeviceEvent evt, DataSourceEntity dataSourceAccess)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.EventDataSourceMapper.Map(NativeDeviceEvent evt, DataSourceEntity dataSourceAccess, DataSourceValueEntity dataSourceValueAccess)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.ExternalEventProcessor.ProcessEntry(NativeDeviceEvent entry)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.ExternalEventProcessor.ProcessEntry(NativeEntityEvent entry)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.ExternalEventProcessor.ProcessQueue()
   at SwitchKing.Server.WinSvcServiceHost.InvocationService.ProcessExternalEvents()
   at SwitchKing.Server.WinSvcServiceHost.InvocationService.ProcessDeviceEvents()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
{UnhandledExceptionController_Framework} --<Critical> -- 2015-05-08 20:37:01 -- Exception: 
System.Data.ConstraintException

Level 1) Column 'DataSourceValueID' is constrained to be unique.  Value '853' is already present.

StackTrace for Level 1:
   at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at SwitchKing.Server.DataAccess.ExternalData.DataSources.DataSourceValueDataAccess.InternalAccessor.Get()
   at SwitchKing.Server.DataAccess.ExternalData.DataSources.DataSourceValueDataAccess.GetDataSourceValues()
   at SwitchKing.Server.BusinessAccess.DataCollection.DataSourceAccess.DataSourceValueEntity.GetDataSourceValues()
   at SwitchKing.Server.BusinessAccess.DataCollection.DataSourceAccess.DataSourceValueEntity.GetAll()
   at SwitchKing.Server.BusinessAccess.Cache.DataSourceValueCache.Initialize()
   at SwitchKing.Server.BusinessAccess.Cache.DataSourceValueCache.GetAllFlattened()
   at SwitchKing.Server.BusinessAccess.DataCollection.DataSourceAccess.DataSourceEntity.GetDataSources(Boolean includeValueData)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.EventDataSourceMapper.GetApplicableDataSources(NativeDeviceEvent evt, DataSourceEntity dataSourceAccess)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.EventDataSourceMapper.Map(NativeDeviceEvent evt, DataSourceEntity dataSourceAccess, DataSourceValueEntity dataSourceValueAccess)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.ExternalEventProcessor.ProcessEntry(NativeDeviceEvent entry)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.ExternalEventProcessor.ProcessEntry(NativeEntityEvent entry)
   at SwitchKing.Server.BusinessAccess.Invocation.ExternalEventHandling.ExternalEventProcessor.ProcessQueue()
   at SwitchKing.Server.WinSvcServiceHost.InvocationService.ProcessExternalEvents()
   at SwitchKing.Server.WinSvcServiceHost.InvocationService.ProcessDeviceEvents()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

[askthomas]

Server version info

Code: Select all

{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- Running version 3.2.3.1 of server and version 2.5.5 of DB.
{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- Build date and time for this version is 2013-07-23 12:22:17.
{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- Telldus version is 2.1.2.
{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- Validating database version and executing upgrade scripts.
{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- No upgrade performed. Database version is already up to date.
{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- Status of license is Valid.
{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- Opening service channel for Framework.
{Framework Service - Startup} --<Status> -- 2015-05-08 20:46:25 -- Service channel for Framework opened.
{WCFServices - Service Request} --<Error> -- 2015-05-08 20:46:34 -- Request failed for GetDataSources.