{"action":"created","issue":{"url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/371","labels_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/371/labels{/name}","comments_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/371/comments","events_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/371/events","html_url":"https://github.com/HangfireIO/Hangfire/issues/371","id":76707122,"number":371,"title":"Hangfire tables are not case-sensitive","user":{"login":"ilessa","id":12459347,"avatar_url":"https://avatars.githubusercontent.com/u/12459347?v=3","gravatar_id":"","url":"https://api.github.com/users/ilessa","html_url":"https://github.com/ilessa","followers_url":"https://api.github.com/users/ilessa/followers","following_url":"https://api.github.com/users/ilessa/following{/other_user}","gists_url":"https://api.github.com/users/ilessa/gists{/gist_id}","starred_url":"https://api.github.com/users/ilessa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ilessa/subscriptions","organizations_url":"https://api.github.com/users/ilessa/orgs","repos_url":"https://api.github.com/users/ilessa/repos","events_url":"https://api.github.com/users/ilessa/events{/privacy}","received_events_url":"https://api.github.com/users/ilessa/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/HangfireIO/Hangfire/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/HangfireIO/Hangfire/labels/sql","name":"sql","color":"bfd4f2"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/HangfireIO/Hangfire/milestones/30","html_url":"https://github.com/HangfireIO/Hangfire/milestones/1.4.3","labels_url":"https://api.github.com/repos/HangfireIO/Hangfire/milestones/30/labels","id":1111977,"number":30,"title":"1.4.3","description":"","creator":{"login":"odinserj","id":1078718,"avatar_url":"https://avatars.githubusercontent.com/u/1078718?v=3","gravatar_id":"","url":"https://api.github.com/users/odinserj","html_url":"https://github.com/odinserj","followers_url":"https://api.github.com/users/odinserj/followers","following_url":"https://api.github.com/users/odinserj/following{/other_user}","gists_url":"https://api.github.com/users/odinserj/gists{/gist_id}","starred_url":"https://api.github.com/users/odinserj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/odinserj/subscriptions","organizations_url":"https://api.github.com/users/odinserj/orgs","repos_url":"https://api.github.com/users/odinserj/repos","events_url":"https://api.github.com/users/odinserj/events{/privacy}","received_events_url":"https://api.github.com/users/odinserj/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":4,"state":"open","created_at":"2015-05-15T11:48:37Z","updated_at":"2015-05-27T15:24:30Z","due_on":null,"closed_at":null},"comments":9,"created_at":"2015-05-15T12:05:12Z","updated_at":"2015-05-27T15:24:44Z","closed_at":"2015-05-27T15:21:46Z","body":"Hi, we're using a bin collation MSSQL database (necessary to support our customers) and recently received the following error (below) which we have isolated to the CountersAggregator class.\r\n\r\nWe require the table names to match the ones created (including case) so:\r\n\r\n```sql\r\nDELETE TOP (@count) [Hangfire].[Counter] with (readpast)\r\nOUTPUT DELETED.[Key], DELETED.[Value], DELETED.[ExpireAt] INTO @RecordsToAggregate\r\nSET NOCOUNT ON\r\nMERGE [Hangfire].[AggregatedCounter] AS [Target]\r\n```\r\n\r\nwould become\r\n\r\n```sql\r\nDELETE TOP (@count) [HangFire].[Counter] with (readpast)\r\nOUTPUT DELETED.[Key], DELETED.[Value], DELETED.[ExpireAt] INTO @RecordsToAggregate\r\nSET NOCOUNT ON\r\nMERGE [HangFire].[AggregatedCounter] AS [Target]\r\n```\r\n\r\nThanks.\r\n\r\n```\r\nError occurred during execution of 'SQL Counter Table Aggregator' component. Execution will be retried (attempt 10 of 2147483647) in 00:01:28 seconds.\r\nSystem.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Hangfire.Counter'.\r\nTransaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.\r\n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at System.Data.SqlClient.SqlInternalConnection.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.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)\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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)\r\n   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n   at Dapper.SqlMapper.ExecuteCommand(IDbConnection cnn, CommandDefinition& command, Action`2 paramReader)\r\n   at Dapper.SqlMapper.ExecuteImpl(IDbConnection cnn, CommandDefinition& command)\r\n   at Dapper.SqlMapper.Execute(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)\r\n   at Hangfire.SqlServer.CountersAggregator.Execute(CancellationToken cancellationToken)\r\n   at Hangfire.Server.AutomaticRetryServerComponentWrapper.ExecuteWithAutomaticRetry(CancellationToken cancellationToken)\r\nClientConnectionId:c952f859-8022-4a46-b934-bd75ae507334\r\nError Number:208,State:1,Class:16\r\n```"},"comment":{"url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/comments/105956581","html_url":"https://github.com/HangfireIO/Hangfire/issues/371#issuecomment-105956581","issue_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/371","id":105956581,"user":{"login":"ilessa","id":12459347,"avatar_url":"https://avatars.githubusercontent.com/u/12459347?v=3","gravatar_id":"","url":"https://api.github.com/users/ilessa","html_url":"https://github.com/ilessa","followers_url":"https://api.github.com/users/ilessa/followers","following_url":"https://api.github.com/users/ilessa/following{/other_user}","gists_url":"https://api.github.com/users/ilessa/gists{/gist_id}","starred_url":"https://api.github.com/users/ilessa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ilessa/subscriptions","organizations_url":"https://api.github.com/users/ilessa/orgs","repos_url":"https://api.github.com/users/ilessa/repos","events_url":"https://api.github.com/users/ilessa/events{/privacy}","received_events_url":"https://api.github.com/users/ilessa/received_events","type":"User","site_admin":false},"created_at":"2015-05-27T15:24:44Z","updated_at":"2015-05-27T15:24:44Z","body":"@odinserj Thanks! I'll keep an eye out for it"}}