{"action":"created","issue":{"url":"https://api.github.com/repos/Particular/ServiceControl/issues/820","repository_url":"https://api.github.com/repos/Particular/ServiceControl","labels_url":"https://api.github.com/repos/Particular/ServiceControl/issues/820/labels{/name}","comments_url":"https://api.github.com/repos/Particular/ServiceControl/issues/820/comments","events_url":"https://api.github.com/repos/Particular/ServiceControl/issues/820/events","html_url":"https://github.com/Particular/ServiceControl/issues/820","id":185318084,"number":820,"title":"Overriding default schema name \"dbo\" doesn't seem to work","user":{"login":"buyshans-cegeka","id":22443597,"avatar_url":"https://avatars.githubusercontent.com/u/22443597?v=3","gravatar_id":"","url":"https://api.github.com/users/buyshans-cegeka","html_url":"https://github.com/buyshans-cegeka","followers_url":"https://api.github.com/users/buyshans-cegeka/followers","following_url":"https://api.github.com/users/buyshans-cegeka/following{/other_user}","gists_url":"https://api.github.com/users/buyshans-cegeka/gists{/gist_id}","starred_url":"https://api.github.com/users/buyshans-cegeka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/buyshans-cegeka/subscriptions","organizations_url":"https://api.github.com/users/buyshans-cegeka/orgs","repos_url":"https://api.github.com/users/buyshans-cegeka/repos","events_url":"https://api.github.com/users/buyshans-cegeka/events{/privacy}","received_events_url":"https://api.github.com/users/buyshans-cegeka/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-10-26T07:37:21Z","updated_at":"2016-10-27T08:22:09Z","closed_at":null,"body":"Hello\r\n\r\nThe schema name seems to be fixed to \"dbo\" for the AuditQueue and ErrorQueue setting. \r\n\r\nWe are currently storing our audit and error table in the schema \"nsb\". When trying to setup ServiceControl to enable ServiceInsight, an error gets logged when attempting to access these tables.\r\n\r\nThere has already been a similar issue that was closed that suggested to try the following setup.\r\n\r\nThe \"ServiceControl.exe.config\" file contains the following settings:\r\n\r\n        <add key=\"ServiceBus/AuditQueue\" value=\"nsb.audit\" />\r\n        <add key=\"ServiceBus/ErrorQueue\" value=\"nsb.error\" />\r\n\r\nWhen starting the service, eventually an error is logged in the logfile that looks like this:\r\n\r\n> 016-10-26 09:24:34.4853|9|Fatal|NServiceBus|Repeated failures when communicating with SQL\r\n> System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.nsb.error'.\r\n>   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& dataReady)\r\n>   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n>   at System.Data.SqlClient.SqlDataReader.get_MetaData()\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& task, Boolean >asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n>   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, >RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, >Int32 timeout, Task& task, Boolean asyncWrite)\r\n>   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, >RunBehavior runBehavior, Boolean returnStream, String method)\r\n>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)\r\n>   at NServiceBus.Transports.SQLServer.TableBasedQueue.ExecuteReader(SqlCommand command) in >C:\\Build\\src\\NServiceBus.SqlServer\\TableBasedQueue.cs:line 117\r\n>   at NServiceBus.Transports.SQLServer.TableBasedQueue.ReceiveWithNativeTransaction(String sql, >SqlConnection connection, SqlTransaction transaction) in >C:\\Build\\src\\NServiceBus.SqlServer\\TableBasedQueue.cs:line 110\r\n>   at NServiceBus.Transports.SQLServer.TableBasedQueue.TryReceive(SqlConnection connection, >SqlTransaction transaction) in C:\\Build\\src\\NServiceBus.SqlServer\\TableBasedQueue.cs:line 100\r\n>   at >NServiceBus.Transports.SQLServer.NativeTransactionReceiveStrategy.TryReceiveFrom(TableBasedQueu>e queue) in C:\\Build\\src\\NServiceBus.SqlServer\\NativeTransactionReceiveStrategy.cs:line 44\r\n>   at NServiceBus.Transports.SQLServer.AdaptivePollingReceiver.Try(Boolean& success) in >C:\\Build\\src\\NServiceBus.SqlServer\\AdaptivePollingReceiver.cs:line 55\r\n>   at NServiceBus.Transports.SQLServer.AdaptiveExecutor`1.ReceiveLoop(Object obj) in >C:\\Build\\src\\NServiceBus.SqlServer\\AdaptiveExecutor.cs:line 110\r\n>   at System.Threading.Tasks.Task.Execute()\r\n>ClientConnectionId:000cabc5-3e26-4579-bc8e-a87b919d89d9\r\n>Error Number:208,State:1,Class:16"},"comment":{"url":"https://api.github.com/repos/Particular/ServiceControl/issues/comments/256578330","html_url":"https://github.com/Particular/ServiceControl/issues/820#issuecomment-256578330","issue_url":"https://api.github.com/repos/Particular/ServiceControl/issues/820","id":256578330,"user":{"login":"buyshans-cegeka","id":22443597,"avatar_url":"https://avatars.githubusercontent.com/u/22443597?v=3","gravatar_id":"","url":"https://api.github.com/users/buyshans-cegeka","html_url":"https://github.com/buyshans-cegeka","followers_url":"https://api.github.com/users/buyshans-cegeka/followers","following_url":"https://api.github.com/users/buyshans-cegeka/following{/other_user}","gists_url":"https://api.github.com/users/buyshans-cegeka/gists{/gist_id}","starred_url":"https://api.github.com/users/buyshans-cegeka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/buyshans-cegeka/subscriptions","organizations_url":"https://api.github.com/users/buyshans-cegeka/orgs","repos_url":"https://api.github.com/users/buyshans-cegeka/repos","events_url":"https://api.github.com/users/buyshans-cegeka/events{/privacy}","received_events_url":"https://api.github.com/users/buyshans-cegeka/received_events","type":"User","site_admin":false},"created_at":"2016-10-27T08:22:09Z","updated_at":"2016-10-27T08:22:09Z","body":"That seems to be doing the trick, thank you very much. \r\n\r\nI tried to find this in the documentation, but I was unable to find it. "}}
{"actor":{"display_login":"buyshans-cegeka"}}