Page 1 of 1
DataSourceValueID' is constrained to be unique.
Posted: Fri 08 May 2015, 19:41
by 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
Re: DataSourceValueID' is constrained to be unique.
Posted: Fri 08 May 2015, 19:42
by 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()
Re: DataSourceValueID' is constrained to be unique.
Posted: Fri 08 May 2015, 19:49
by 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.