none
对CRM信息进行分派时报错~ RRS feed

  • 问题

  • 如题,报错,似乎跟sql有关,但是又看不出什么!不是一个特定实体,是对所有实体的信息进行分派都会报这个错,那个什么P S Y 字段真不知是啥...

    at SoapExtensionExceptionHandlerBase.GetCrmException(Exception exception)
    at SoapExtensionExceptionHandlerBase.GetCrmException(Exception exception)
    at CrmExceptionHandler.RetrieveCrmException(Exception exception)
    at InProcessCrmService.Execute(Object request)
    at PlatformCommand.ExecuteInternal()
    at DataSource.Route(Guid sourceQueueId, Guid targetQueueId, RouteType routeType, EntityType entityType, Guid entityId)
    at AssignRouteOnCreateUpdateListener.RouteEntity(Entity entity, LookupValue owner)
    at AssignRouteOnCreateUpdateListener.AssignRouteEntity(Entity entity, LookupValue owner)
    at AssignRouteOnCreateUpdateListener.HandlePostEvent(PlatformCommand command, Response response, Boolean wasForUpdate)
    at CommunicationListener.HandlePostEvent(PlatformCommand command, Response response)
    at PlatformCommand.ExecuteInternal()
    at RescheduleCommand.Execute()
    at DataSource.Reschedule(Entity activity)
    at ActivitiesWebService.Reschedule(Guid id, XmlNode content, Int32 typeCode)
    at RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at LogicalMethodInfo.Invoke(Object target, Object[] values)
    at WebServiceHandler.Invoke()
    at WebServiceHandler.CoreProcessRequest()
    at SyncSessionlessHandler.ProcessRequest(HttpContext context)
    at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    at ApplicationStepManager.ResumeSteps(Exception error)
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
    at HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >Crm Exception: Message: , ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException: 列名 'q' 无效。
    列名 's' 无效。
    列名 'y' 无效。
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
    at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
    at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command)
    at Microsoft.Crm.BusinessEntities.CrmCascadeDBCollection.Collect(CascadeActionType actionType, Guid entityId, Int32 entityOtc, Guid ownerId)
    at Microsoft.Crm.BusinessEntities.CascadeEngine.AssignDB(BusinessEntityMoniker moniker, SecurityPrincipal assignee, ExecutionContext context)
    at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Assign(BusinessEntityMoniker moniker, SecurityPrincipal assignee, ExecutionContext context)
    at Microsoft.Crm.ObjectModel.GenericActivityServiceBase.Route(BusinessEntityMoniker moniker, Guid sourceQueueId, Int32 routeTypeCode, Guid endpointId, ExecutionContext context)


     

    2011年10月9日 2:29

答案

  • 我找到解决方案了,我在导入组织时,我打了补丁10,我导入组织后,我把补丁10给卸载了,现在进行信息记录分派可以了,你可以试试把你的补丁卸载了看看怎么样


    刘祖君
    2011年10月17日 8:22

全部回复