{"action":"created","issue":{"url":"https://api.github.com/repos/azavar/SST-API/issues/64","repository_url":"https://api.github.com/repos/azavar/SST-API","labels_url":"https://api.github.com/repos/azavar/SST-API/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/azavar/SST-API/issues/64/comments","events_url":"https://api.github.com/repos/azavar/SST-API/issues/64/events","html_url":"https://github.com/azavar/SST-API/issues/64","id":131724579,"number":64,"title":"BulkRegistration returns exception with multiple registrations","user":{"login":"johnwadlow","id":1168069,"avatar_url":"https://avatars.githubusercontent.com/u/1168069?v=3","gravatar_id":"","url":"https://api.github.com/users/johnwadlow","html_url":"https://github.com/johnwadlow","followers_url":"https://api.github.com/users/johnwadlow/followers","following_url":"https://api.github.com/users/johnwadlow/following{/other_user}","gists_url":"https://api.github.com/users/johnwadlow/gists{/gist_id}","starred_url":"https://api.github.com/users/johnwadlow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnwadlow/subscriptions","organizations_url":"https://api.github.com/users/johnwadlow/orgs","repos_url":"https://api.github.com/users/johnwadlow/repos","events_url":"https://api.github.com/users/johnwadlow/events{/privacy}","received_events_url":"https://api.github.com/users/johnwadlow/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2016-02-05T18:53:26Z","updated_at":"2016-02-08T20:45:56Z","closed_at":"2016-02-08T20:45:56Z","body":"I got the follow response when trying to submit multiple registrations\r\n\r\n```xml\r\n<s:Body u:Id=\"_2\">\r\n<Fault xmlns=\"http://www.w3.org/2003/05/soap-envelope\">\r\n  <Code>\r\n\t<Value>Receiver</Value>\r\n\t<Subcode>\r\n\t  <Value xmlns:a=\"http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher\">a:InternalServiceFault</Value>\r\n\t</Subcode>\r\n  </Code>\r\n  <Reason>\r\n\t<Text xml:lang=\"en-US\">The DELETE statement conflicted with the REFERENCE constraint \"FK_TransmissionBodies_Transmissions\". The conflict occurred in database \"SSTGB_Staging\", table \"dbo.TransmissionBodies\", column 'TransmissionId'.\r\nThe statement has been terminated.</Text>\r\n  </Reason>\r\n  <Detail>\r\n\t<ExceptionDetail xmlns=\"http://schemas.datacontract.org/2004/07/System.ServiceModel\" xmlns:i=\"http://www.w3.org/2001/XMLSchema-instance\">\r\n\t  <HelpLink i:nil=\"true\" />\r\n\t  <InnerException i:nil=\"true\" />\r\n\t  <Message>The DELETE statement conflicted with the REFERENCE constraint \"FK_TransmissionBodies_Transmissions\". The conflict occurred in database \"SSTGB_Staging\", table \"dbo.TransmissionBodies\", column 'TransmissionId'.\r\n               The statement has been terminated.</Message>\r\n\t  <StackTrace>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n                     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n                     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)\r\n                     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n                     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, SqlDataReader ds)\r\n                     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean asyncWrite)\r\n                     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)\r\n                     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n                     at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)\r\n                     at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)\r\n                     at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)\r\n                     at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicDelete(TrackedObject item)\r\n                     at System.Data.Linq.ChangeDirector.StandardChangeDirector.Delete(TrackedObject item)\r\n                     at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)\r\n                     at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)\r\n                     at SST.ApiService.BulkRegistration(BulkRegistrationTransmissionType bulkRegistrationTransmission)\r\n                     at SyncInvokeBulkRegistration(Object , Object[] , Object[] )\r\n                     at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]&amp; outputs)\r\n                     at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc&amp; rpc)\r\n                     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc&amp; rpc)\r\n                     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc&amp; rpc)\r\n                     at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)</StackTrace>\r\n\t  <Type>System.Data.SqlClient.SqlException</Type>\r\n\t</ExceptionDetail>\r\n  </Detail>\r\n</Fault>\r\n</s:Body>\r\n```\r\n\r\nRequest \r\n[Request_160205_104840.txt](https://github.com/azavar/SST-API/files/119683/Request_160205_104840.txt)\r\n\r\nResponse\r\n[Response_160205_104847.txt](https://github.com/azavar/SST-API/files/119685/Response_160205_104847.txt)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/azavar/SST-API/issues/comments/181560309","html_url":"https://github.com/azavar/SST-API/issues/64#issuecomment-181560309","issue_url":"https://api.github.com/repos/azavar/SST-API/issues/64","id":181560309,"user":{"login":"muaz-azavar","id":15657366,"avatar_url":"https://avatars.githubusercontent.com/u/15657366?v=3","gravatar_id":"","url":"https://api.github.com/users/muaz-azavar","html_url":"https://github.com/muaz-azavar","followers_url":"https://api.github.com/users/muaz-azavar/followers","following_url":"https://api.github.com/users/muaz-azavar/following{/other_user}","gists_url":"https://api.github.com/users/muaz-azavar/gists{/gist_id}","starred_url":"https://api.github.com/users/muaz-azavar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/muaz-azavar/subscriptions","organizations_url":"https://api.github.com/users/muaz-azavar/orgs","repos_url":"https://api.github.com/users/muaz-azavar/repos","events_url":"https://api.github.com/users/muaz-azavar/events{/privacy}","received_events_url":"https://api.github.com/users/muaz-azavar/received_events","type":"User","site_admin":false},"created_at":"2016-02-08T20:45:56Z","updated_at":"2016-02-08T20:45:56Z","body":"Can you please check it now? It should be resolved.\r\nIf it is not resolved then please provide the TransmissionId.\r\nThank you"}}