Exception updating newsgroups

Jul 10, 2013 at 2:01 PM
Adding to DB: id:17542607 (6de0db29-898b-4292-b2d1-76bc8439c03d), NNTP#: 1392
Adding to DB: id:17542825 (d1c73681-7cdb-4423-beee-b4b618cf6a83), NNTP#: 1393
[Client 5] DataReceived failed: Exception:
Type System.Data.UpdateException
Source: System.Data.Entity
Message: An error occurred while updating the entries. See the inner exception for details.
Stack-Trace:
at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
at StackAppBridge.MsgNumberManagement.ProcessNewArticles(ForumNewsgroup group, IEnumerable1 newArticles, List1 articles, Boolean firstTime)
at StackAppBridge.MsgNumberManagement.UpdateGroupFromWebService(ForumNewsgroup group, Action1 progress, Action1 articleConverter)
at StackAppBridge.DataSourceStackApps.GetNewsgroup(String clientUsername, String groupName, Boolean updateFirstLastNumber, Boolean& exceptionOccured)
at StackAppBridge.NNTPServer.NntpCommandGroup.GetSelectedNewsgroup(String groupName, Client client)
at StackAppBridge.NNTPServer.NntpCommandGroup.Parse(String parameters, Action1 writeAction, Client client)
at StackAppBridge.NNTPServer.NntpServer.DataReceived(String data, Int32 clientNumber)Exception:
Type System.Data.SqlServerCe.SqlCeException
Source: SQL Server Compact ADO.NET Data Provider
Message: A duplicate value cannot be inserted into a unique index. [ Table name = Mappings,Constraint name = idxMappingsMessageNumber ]
Stack-Trace:
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary
2 identifierValues, List`1 generatedValues)
at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
Jul 10, 2013 at 2:24 PM
Several newsgroups also report this kind of exception:

GetQuestion: id:17558344
[Client: 5] Received: Response: 1302 How do you add a "Build Runtime Licenses" command to the context menu when you right click on a .licx file in VisualStudio 2012? Chris Tue, 9 Jul 2013 21:14:12 +0000 <6f0e010b-5266-4283-93ec-8bd78cbee354$stackappnntpbridge.codeplex.com> 874 88 LOCALHOST.StackAppBridge StackOverflow.Visual-Studio:1302

[Client 5] DataReceived failed: Exception:
Type Newtonsoft.Json.JsonReaderException
Source: Newtonsoft.Json
Message: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.
Stack-Trace:
at Newtonsoft.Json.JsonTextReader.ParseValue()
at Newtonsoft.Json.JsonTextReader.ReadInternal()
at Newtonsoft.Json.JsonTextReader.Read()
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType(JsonReader reader, JsonContract contract, Boolean hasConverter)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
at Stacky.SerializationHelper.DeserializeJson[T](String json)
at Stacky.JsonResponse1.Parse(String json, JsonResponse1 response)
at Stacky.JsonResponse1..ctor(String json)
at Stacky.JsonProtocol.GetResponse[T](String message)
at Stacky.StackyClient.ParseResponse[T](HttpResponse httpResponse)
at Stacky.StackyClient.GetAnswers(IEnumerable
1 answerIds, String site_, String filter_)
at StackAppBridge.MsgNumberManagement.InternalGetMsgById(ForumNewsgroup group, Mapping map)
at StackAppBridge.MsgNumberManagement.GetMessageByMsgNo(ForumNewsgroup forumNewsgroup, Int32 articleNumber)
at StackAppBridge.DataSourceStackApps.GetArticlesByNumberToStream(String clientUsername, String groupName, Int32 firstArticle, Int32 lastArticle, Action1 articlesProgressAction)
at StackAppBridge.NNTPServer.NntpCommandXOver.Parse(String parameters, Action
1 writeAction, Client client)
at StackAppBridge.NNTPServer.NntpServer.DataReceived(String data, Int32 clientNumber)
Jul 10, 2013 at 2:28 PM
Both exceptions are intermittent. If I wait a few minutes and try to update the newsgroup again, it seems to work.
Jul 12, 2013 at 3:39 AM
Using 1.2.0.0, I'm still getting:

Exception:
Type System.Data.SqlServerCe.SqlCeException
Source: SQL Server Compact ADO.NET Data Provider
Message: A duplicate value cannot be inserted into a unique index. [ Table name = Mappings,Constraint name = idxMappingsMessageNumber ]

I thought I saw in the change-log that this was fixed?

Thanks,
David
Coordinator
Jul 12, 2013 at 3:51 AM
Can you sent me the debug files? Either via the menu or directly?

Von: dcsoft
Gesendet: 12.07.2013 05:39
An: [email removed]
Betreff: Re: Exception updating newsgroups [stackappnntpbridge:449572]

From: dcsoft

Using 1.2.0.0, I'm still getting:

Exception:
Type System.Data.SqlServerCe.SqlCeException
Source: SQL Server Compact ADO.NET Data Provider
Message: A duplicate value cannot be inserted into a unique index. [ Table name = Mappings,Constraint name = idxMappingsMessageNumber ]

I thought I saw in the change-log that this was fixed?

Thanks,
David
Jul 12, 2013 at 3:58 AM

Sent, let me know if you need me to reproduce anything, thanks.