积极答复者
对CRM信息进行分派时报错~

问题
-
如题,报错,似乎跟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)
答案
-
我找到解决方案了,我在导入组织时,我打了补丁10,我导入组织后,我把补丁10给卸载了,现在进行信息记录分派可以了,你可以试试把你的补丁卸载了看看怎么样
刘祖君- 已建议为答案 刘祖君(Eric Liu) 2011年10月18日 0:44
- 已标记为答案 Batistuta CaiModerator 2011年10月26日 13:41
全部回复
-
同样问题,期待高手解答,谢谢!楼主你可以留个联系方式吗?我的QQ:724263150
刘祖君
- 已编辑 刘祖君(Eric Liu) 2011年10月14日 8:54
-
我找到解决方案了,我在导入组织时,我打了补丁10,我导入组织后,我把补丁10给卸载了,现在进行信息记录分派可以了,你可以试试把你的补丁卸载了看看怎么样
刘祖君- 已建议为答案 刘祖君(Eric Liu) 2011年10月18日 0:44
- 已标记为答案 Batistuta CaiModerator 2011年10月26日 13:41