This article has been archived. It is offered "as is" and will no longer be updated.
Consider the following scenario in the Turkish version of Microsoft Dynamics CRM 4.0. You create a contract. Then, you specify yesterday as the date in the Start Date field and in the End Date field. Therefore, you expect that the contract is expired. Next, you run the Resume function for the Update Contract States job. In this scenario, the Resume function does not work as expected.
When this problem occurs, the status of the contract is not set to Expired. Additionally, you receive the following error message:
Select status from statusmap where organizationid = 'b0cc31a3-0e5d-44fd-98f2-c3d1264cdc30' and objecttypecode = 1010 and state = 5 and isdefault = 1 [DateTime] Process:CrmAsyncService |Organization:b0cc31a3-0e5d-44fd-98f2-c3d1264cdc30 |Thread: 18 |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error | UpdateContractStatesOperation.InternalExecute at UpdateContractStatesOperation.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.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at _ThreadPoolWaitCallback.PerformWaitCallback(Object state) >AsyncHandler::UpdateContractStatesOperation could not complete because of exception Invalid column name 'organizationid'. Invalid column name 'isdefault'.
Note The Update Contract States job is a system job.
This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards