Importing custom solution (CRM 2011)

• 2012년 5월 21일 월요일 오전 10:50

   

   
  

  0

  Hi guys and girls,

  When I try to import a solution i get the following error: "a SQL Server error occured."

  Please note, I have had another team member to install the solution,  and they do not experience any issues.

  I have run a CRM trace on the error and I get the following:

  at SqlHelper.ExecuteBatches(IDbTransaction transaction, IDbCommand sqlCommand)
  at SqlHelper.ExecuteBatches(ISqlExecutionContext context, String sqlCommand)
  at ViewGenerator.RegenerateReportViews(Guid[] entityIds, Dictionary`2 viewSet)
  at ViewGenerator.RegenerateViews(ViewGenerationInfoDictionary viewGenerationSet, SqlViewTypes viewTypes, Boolean grantDatabaseAccessToReportViews)
  at MetadataHelper.RegenerateViews()
  at MetadataHelper.ProcessQueue()
  at ImportEntityRelationshipHandler.ImportItem()
  at ImportHandler.Import()
  at RootImportHandler.RunImport(String[] ImportEntities)
  at ImportXml.RunImport(String[] ImportEntities)
  at ImportXml.RunImport()
  at ImportXmlService.ImportSolution(Boolean overwriteUnmanagedCustomizations, Boolean publishWorkflows, Byte[] customizationFile, Guid importJobId, Boolean convertToManaged, ExecutionContext context)
  at RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType 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 InternalOperationPlugin.Execute(IServiceProvider serviceProvider)
  at V5PluginProxyStep.ExecuteInternal(PipelineExecutionContext context)
  at VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)
  at Pipeline.Execute(PipelineExecutionContext context)
  at MessageProcessor.Execute(PipelineExecutionContext context)
  at InternalMessageDispatcher.Execute(PipelineExecutionContext context)
  at ExternalMessageDispatcher.ExecuteInternal(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId, Version endpointVersion)
  at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)
  at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)
  at InprocessServiceProxy.ExecuteCore(OrganizationRequest request)
  at PlatformCommand.XrmExecuteInternal()
  at ImportSolutionCommand.Execute()
  at DataSource.ImportSolution(Byte[] customizationFile, Boolean overwriteUnmanagedCustomizations, Boolean publishWorkflows, Guid importJobId, Boolean convertToManaged, IOrganizationContext context)
  at SolutionImportProcessPage.ImportSolution()
  at SolutionImportProcessPage.ProcessRequestData()
  at AppUIPage.OnPreRender(EventArgs e)
  at Control.PreRenderRecursiveInternal()
  at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  at Page.ProcessRequest()
  at Page.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 ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
  >Exception when executing batches query:
  --
  -- report view for queueitem
  --
  create view dbo.[FilteredQueueItem] (
  [createdby],
  [createdbydsc],
  [createdbyname],
  [createdbyyominame],
  [createdon],
  [createdonutc],
  [createdonbehalfby],
  [createdonbehalfbydsc],
  [createdonbehalfbyname],
  [createdonbehalfbyyominame],
  [enteredon],
  [enteredonutc],
  [exchangerate],
  [importsequencenumber],
  [modifiedby],
  [modifiedbydsc],
  [modifiedbyname],
  [modifiedbyyominame],
  [modifiedon],
  [modifiedonutc],
  [modifiedonbehalfby],
  [modifiedonbehalfbydsc],
  [modifiedonbehalfbyname],
  [modifiedonbehalfbyyominame],
  [objectid],
  [objectidname],
  [objectidtypecode],
  [objecttypecode],
  [objecttypecodename],
  [organizationid],
  [organizationiddsc],
  [organizationidname],
  [overriddencreatedon],
  [overriddencreatedonutc],
  [ownerid],
  [owneridtype],
  [owningbusinessunit],
  [owninguser],
  [priority],
  [queueid],
  [queueidname],
  [queueitemid],
  [sender],
  [state],
  [statecode],
  [statecodename],
  [status],
  [statuscode],
  [statuscodename],
  [timezoneruleversionnumber],
  [title],
  [torecipients],
  [transactioncurrencyid],
  [transactioncurrencyidname],
  [utcconversiontimezonecode],
  [versionnumber],
  [workerid],
  [workeridmodifiedon],
  [workeridmodifiedonutc],
  [workeridname],
  [workeridtype],
  [workeridyominame]
  ) with view_metadata as
  select
  [QueueItem].[CreatedBy],
  --[QueueItem].[CreatedByDsc]
  0,
  [QueueItem].[CreatedByName],
  [QueueItem].[CreatedByYomiName],
  dbo.fn_UTCToTzSpecificLocalTime([QueueItem].[CreatedOn],
  us.TimeZoneBias,
  us.TimeZoneDaylightBias,
  us.TimeZoneDaylightYear,
  us.TimeZoneDaylightMonth,
  us.TimeZoneDaylightDay,
  us.TimeZoneDaylightHour,
  us.TimeZoneDaylightMinute,
  us.TimeZoneDaylightSecond,
  0,
  us.TimeZoneDaylightDayOfWeek,
  us.TimeZoneStandardBias,
  us.TimeZoneStandardYear,
  us.TimeZoneStandardMonth,
  us.TimeZoneStandardDay,
  us.TimeZoneStandardHour,
  us.TimeZoneStandardMinute,
  us.TimeZoneStandardSecond,
  0,
  us.TimeZoneStandardDayOfWeek),
  [QueueItem].[CreatedOn],
  [QueueItem].[CreatedOnBehalfBy],
  --[QueueItem].[CreatedOnBehalfByDsc]
  0,
  [QueueItem].[CreatedOnBehalfByName],
  [QueueItem].[CreatedOnBehalfByYomiName],
  dbo.fn_UTCToTzSpecificLocalTime([QueueItem].[EnteredOn],
  us.TimeZoneBias,
  us.TimeZoneDaylightBias,
  us.TimeZoneDaylightYear,
  us.TimeZoneDaylightMonth,
  us.TimeZoneDaylightDay,
  us.TimeZoneDaylightHour,
  us.TimeZoneDaylightMinute,
  us.TimeZoneDaylightSecond,
  0,
  us.TimeZoneDaylightDayOfWeek,
  us.TimeZoneStandardBias,
  us.TimeZoneStandardYear,
  us.TimeZoneStandardMonth,
  us.TimeZoneStandardDay,
  us.TimeZoneStandardHour,
  us.TimeZoneStandardMinute,
  us.TimeZoneStandardSecond,
  0,
  us.TimeZoneStandardDayOfWeek),
  [QueueItem].[EnteredOn],
  [QueueItem].[ExchangeRate],
  [QueueItem].[ImportSequenceNumber],
  [QueueItem].[ModifiedBy],
  --[QueueItem].[ModifiedByDsc]
  0,
  [QueueItem].[ModifiedByName],
  [QueueItem].[ModifiedByYomiName],
  dbo.fn_UTCToTzSpecificLocalTime([QueueItem].[ModifiedOn],
  us.TimeZoneBias,
  us.TimeZoneDaylightBias,
  us.TimeZoneDaylightYear,
  us.TimeZoneDaylightMonth,
  us.TimeZoneDaylightDay,
  us.TimeZoneDaylightHour,
  us.TimeZoneDaylightMinute,
  us.TimeZoneDaylightSecond,
  0,
  us.TimeZoneDaylightDayOfWeek,
  us.TimeZoneStandardBias,
  us.TimeZoneStandardYear,
  us.TimeZoneStandardMonth,
  us.TimeZoneStandardDay,
  us.TimeZoneStandardHour,
  us.TimeZoneStandardMinute,
  us.TimeZoneStandardSecond,
  0,
  us.TimeZoneStandardDayOfWeek),
  [QueueItem].[ModifiedOn],
  [QueueItem].[ModifiedOnBehalfBy],
  --[QueueItem].[ModifiedOnBehalfByDsc]
  0,
  [QueueItem].[ModifiedOnBehalfByName],
  [QueueItem].[ModifiedOnBehalfByYomiName],
  [QueueItem].[ObjectId],
  [QueueItem].[ObjectIdName],
  [QueueItem].[ObjectIdTypeCode],
  [QueueItem].[ObjectTypeCode],
  ObjectTypeCodePLTable.Value,
  [QueueItem].[OrganizationId],
  --[QueueItem].[OrganizationIdDsc]
  0,
  [QueueItem].[OrganizationIdName],
  dbo.fn_UTCToTzSpecificLocalTime([QueueItem].[OverriddenCreatedOn],
  us.TimeZoneBias,
  us.TimeZoneDaylightBias,
  us.TimeZoneDaylightYear,
  us.TimeZoneDaylightMonth,
  us.TimeZoneDaylightDay,
  us.TimeZoneDaylightHour,
  us.TimeZoneDaylightMinute,
  us.TimeZoneDaylightSecond,
  0,
  us.TimeZoneDaylightDayOfWeek,
  us.TimeZoneStandardBias,
  us.TimeZoneStandardYear,
  us.TimeZoneStandardMonth,
  us.TimeZoneStandardDay,
  us.TimeZoneStandardHour,
  us.TimeZoneStandardMinute,
  us.TimeZoneStandardSecond,
  0,
  us.TimeZoneStandardDayOfWeek),
  [QueueItem].[OverriddenCreatedOn],
  [QueueItem].[OwnerId],
  [QueueItem].[OwnerIdType],
  [QueueItem].[OwningBusinessUnit],
  [QueueItem].[OwningUser],
  [QueueItem].[Priority],
  [QueueItem].[QueueId],
  [QueueItem].[QueueIdName],
  [QueueItem].[QueueItemId],
  [QueueItem].[Sender],
  [QueueItem].[State],
  [QueueItem].[StateCode],
  StateCodePLTable.Value,
  [QueueItem].[Status],
  [QueueItem].[StatusCode],
  StatusCodePLTable.Value,
  [QueueItem].[TimeZoneRuleVersionNumber],
  [QueueItem].[Title],
  [QueueItem].[ToRecipients],
  [QueueItem].[TransactionCurrencyId],
  [QueueItem].[TransactionCurrencyIdName],
  [QueueItem].[UTCConversionTimeZoneCode],
  [QueueItem].[VersionNumber],
  [QueueItem].[WorkerId],
  dbo.fn_UTCToTzSpecificLocalTime([QueueItem].[WorkerIdModifiedOn],
  us.TimeZoneBias,
  us.TimeZoneDaylightBias,
  us.TimeZoneDaylightYear,
  us.TimeZoneDaylightMonth,
  us.TimeZoneDaylightDay,
  us.TimeZoneDaylightHour,
  us.TimeZoneDaylightMinute,
  us.TimeZoneDaylightSecond,
  0,
  us.TimeZoneDaylightDayOfWeek,
  us.TimeZoneStandardBias,
  us.TimeZoneStandardYear,
  us.TimeZoneStandardMonth,
  us.TimeZoneStandardDay,
  us.TimeZoneStandardHour,
  us.TimeZoneStandardMinute,
  us.TimeZoneStandardSecond,
  0,
  us.TimeZoneStandardDayOfWeek),
  [QueueItem].[WorkerIdModifiedOn],
  [QueueItem].[WorkerIdName],
  [QueueItem].[WorkerIdType],
  [QueueItem].[WorkerIdYomiName]
  from QueueItem
  join SystemUserBase u on (u.SystemUserId = dbo.fn_FindUserGuid() and u.IsDisabled = 0)
  left join UserSettingsBase us on us.SystemUserId = u.SystemUserId
  left join OrganizationBase o on u.OrganizationId = o.OrganizationId
  left outer join StringMap [ObjectTypeCodePLTable] on
  ([ObjectTypeCodePLTable].AttributeName = 'objecttypecode'
  and [ObjectTypeCodePLTable].ObjectTypeCode = 2029
  and [ObjectTypeCodePLTable].AttributeValue = [QueueItem].[ObjectTypeCode]
  and [ObjectTypeCodePLTable].LangId =
  case us.UILanguageId
  when 0 then o.LanguageCode
  else us.UILanguageId
  end)
  left outer join StringMap [StateCodePLTable] on
  ([StateCodePLTable].AttributeName = 'statecode'
  and [StateCodePLTable].ObjectTypeCode = 2029
  and [StateCodePLTable].AttributeValue = [QueueItem].[StateCode]
  and [StateCodePLTable].LangId =
  case us.UILanguageId
  when 0 then o.LanguageCode
  else us.UILanguageId
  end)
  left outer join StringMap [StatusCodePLTable] on
  ([StatusCodePLTable].AttributeName = 'statuscode'
  and [StatusCodePLTable].ObjectTypeCode = 2029
  and [StatusCodePLTable].AttributeValue = [QueueItem].[StatusCode]
  and [StatusCodePLTable].LangId =
  case us.UILanguageId
  when 0 then o.LanguageCode
  else us.UILanguageId
  end)
  cross join dbo.fn_GetMaxPrivilegeDepthMask(2020) pdm
  where
  (
  -- privilege check
  pdm.PrivilegeDepthMask is not null and
  (
  -- Owner check
  --
  [QueueItem].OwnerId in
  ( -- returns only principals with Basic Read privilege for entity
  select pem.PrincipalId from PrincipalEntityMap pem (NOLOCK)
  join SystemUserPrincipals sup (NOLOCK) on pem.PrincipalId = sup.PrincipalId
  where sup.SystemUserId = u.SystemUserId
  and pem.ObjectTypeCode = 2020
  )
  -- role based access
  or
  exists
  (
  select
  1
  where
  (
  -- deep/local security
  (((pdm.PrivilegeDepthMask & 0x4) != 0) or ((pdm.PrivilegeDepthMask & 0x2) != 0)) and
  [QueueItem].[OwningBusinessUnit] in (select BusinessUnitId from SystemUserBusinessUnitEntityMap (NOLOCK) where SystemUserId = u.SystemUserId and ObjectTypeCode = 2020)
  )
  or
  (
  -- global security
  ((pdm.PrivilegeDepthMask & 0x8) != 0) and
  [QueueItem].[OwningBusinessUnit] is not null
  )
  )
  -- object shared to the user
  or
  [QueueItem].[QueueId] in
  (
  select  POA.ObjectId from PrincipalObjectAccess POA
  join SystemUserPrincipals sup (NOLOCK) on POA.PrincipalId = sup.PrincipalId
  where sup.SystemUserId = u.SystemUserId and
  POA.ObjectTypeCode = 2020 and
  ((POA.AccessRightsMask | POA.InheritedAccessRightsMask) & 1)=1
  )
  )
  )
  Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ObjectIdTypeCode'.
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
  at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
  at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
  at Microsoft.Crm.Metadata.SqlHelper.ExecuteBatches(IDbTransaction transaction, IDbCommand sqlCommand)

  Any ideas?????

  Kelvin

  ---

  Kind regards, Kelvin

  • 응답
  • 인용