I am created a bulk delete job on asyncoperation entity. The job executes successfully in QA however it errors out in production. I get generic SQL Server error. There isn't any specific error message displayed in CRM however here's the error message from logs:
[2008-09-03 21:00:33.6] Process:CrmAsyncService |Organization:a5327d48-c55f-40d3-95e5-f11fefa59d0d |Thread: 15 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error | BulkDeleteOperation.RetrieveRecordsAndPopulateTemporaryTable
at BulkDeleteOperation.RetrieveRecordsAndPopulateTemporaryTable(AsyncEvent asyncEvent, String tableName, List`1 queryExpressionList, Boolean pauseChildJobs)
at BulkDeleteOperation.InternalExecute(AsyncEvent asyncEvent)
at AsyncOperationCommand.Execute(AsyncEvent asyncEvent)
at AsyncHostHandler.Handle(AsyncEvent asyncEvent)
at PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
at PoolHandler.InvokeHandlerInPool(Object state)
at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at ExecutionContext.runTryCode(Object userData)
at RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)
>Error In Retrieving data set for deletion
Please help if you can. Thanks in advance.
