Hi Tomaž,
thanks for the answer.surly am the providing log details.
------------------------------------------------------------------------------------------------------------------------------------------------------------
| Error| Installer Complete: OrganizationUpgrader - Error encountered
| Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationUpgrader:
Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed.
InnerException:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. --->
Microsoft.Crm.CrmException: SqlException: Invalid column name 'New_name'.
Invalid column name 'New_bd_GoalDetails'.
Invalid column name 'New_Test'., View Script: if exists (select * from sysobjects where name = 'New_bd_action' and xtype = 'V')
begin
drop view [New_bd_action]
end
go
--
-- base view for New_bd_action
--
create view dbo.[New_bd_action]
(
-- logical attributes
[New_Account_ActionName],
[New_OppurtunityWeaknessIdName],
[ModifiedByName],
[New_OpportunityIdName],
[New_GenericActionIdName],
[New_bd_CompetitorStrengthIdName],
[New_CompetitorStrengthIdName],
[New_Account_ActionYomiName],
[New_Action_CopetitorStrengthValueIdName],
[New_Action_CustWeaknsIdName],
[New_Action_GoalIdName],
[New_action_bdoprntyIdName],
[New_bd_CompetitorStrengthIdYomiName],
[CreatedByName],
-- ownership entries
OwnerId,
OwnerIdName,
OwnerIdYomiName,
OwnerIdDsc,
OwnerIdType,
OwningUser,
OwningTeam,
-- physical attributes
[New_bd_actionId],
[CreatedOn],
[CreatedBy],
[ModifiedOn],
[ModifiedBy],
[OwningBusinessUnit],
[statecode],
[statuscode],
[VersionNumber],
[ImportSequenceNumber],
[OverriddenCreatedOn],
[TimeZoneRuleVersionNumber],
[UTCConversionTimeZoneCode],
[New_name],
[New_bd_GoalDetails],
[New_CompetitorStrengthId],
[New_bd_CompetitorStrengthId],
[New_OppurtunityWeaknessId],
[New_GenericActionId],
[New_Test],
[New_Account_Action],
[New_OpportunityId],
[New_Action_GoalId],
[New_action_bdoprntyId],
[New_Action_CustWeaknsId],
[New_Action_CopetitorStrengthValueId],
[New_actionbased]
) with view_metadata as
select
-- logical attributes
[new_account_new_bd_action].[Name],
[new_bd_custweakness_bd_actionExt].[New_name],
[lk_new_bd_action_modifiedby].[FullName],
[new_opportunity_new_bd_action].[Name],
[new_bd_genericaction_new_bd_actionExt].[New_name],
[new_bd_competitor_action].[Name],
[new_bd_custstrength_new_bd_actionExt].[New_name],
[new_account_new_bd_action].[YomiName],
[new_new_competitorstrength_new_bd_actionExt].[New_name],
[new_new_custweakness_new_bd_actionExt].[New_name],
[new_new_goals_new_bd_actionExt].[New_name],
[new_new_bd_oppurtunity_new_bd_actionExt].[New_bd_oppurtunity],
[new_bd_competitor_action].[YomiName],
[lk_new_bd_action_createdby].[FullName],
-- ownership entries
OwnerId = [New_bd_actionBase].OwnerId,
OwnerName = XXowner.Name,
OwnerYomiName = XXowner.YomiName,
OwnerDsc = 0, -- DSC is removed, stub it to 0
OwnerIdType = XXowner.OwnerIdType,
OwningUser = case
when XXowner.OwnerIdType= 8 then XXowner.OwnerId
else null
end,
OwningTeam = case
when XXowner.OwnerIdType= 9 then XXowner.OwnerId
else null
end,
-- physical attribute
[New_bd_actionBase].[New_bd_actionId],
[New_bd_actionBase].[CreatedOn],
[New_bd_actionBase].[CreatedBy],
[New_bd_actionBase].[ModifiedOn],
[New_bd_actionBase].[ModifiedBy],
[New_bd_actionBase].[OwningBusinessUnit],
[New_bd_actionBase].[statecode],
[New_bd_actionBase].[statuscode],
[New_bd_actionBase].[VersionNumber],
[New_bd_actionBase].[ImportSequenceNumber],
[New_bd_actionBase].[OverriddenCreatedOn],
[New_bd_actionBase].[TimeZoneRuleVersionNumber],
[New_bd_actionBase].[UTCConversionTimeZoneCode],
[New_bd_actionExtensionBase].[New_name],
[New_bd_actionExtensionBase].[New_bd_GoalDetails],
[New_bd_actionExtensionBase].[New_CompetitorStrengthId],
[New_bd_actionExtensionBase].[New_bd_CompetitorStrengthId],
[New_bd_actionExtensionBase].[New_OppurtunityWeaknessId],
[New_bd_actionExtensionBase].[New_GenericActionId],
[New_bd_actionExtensionBase].[New_Test],
[New_bd_actionExtensionBase].[New_Account_Action],
[New_bd_actionExtensionBase].[New_OpportunityId],
[New_bd_actionExtensionBase].[New_Action_GoalId],
[New_bd_actionExtensionBase].[New_action_bdoprntyId],
[New_bd_actionExtensionBase].[New_Action_CustWeaknsId],
[New_bd_actionExtensionBase].[New_Action_CopetitorStrengthValueId],
[New_bd_actionExtensionBase].[New_actionbased]
from [New_bd_actionBase]
inner join [New_bd_actionExtensionBase] on ([New_bd_actionBase].[New_bd_actionId] = [New_bd_actionExtensionBase].[New_bd_actionId])
left join [SystemUserBase] [lk_new_bd_action_createdby] with(nolock) on ([New_bd_actionBase].[CreatedBy] = [lk_new_bd_action_createdby].[SystemUserId])
left join [SystemUserBase] [lk_new_bd_action_modifiedby] with(nolock) on ([New_bd_actionBase].[ModifiedBy] = [lk_new_bd_action_modifiedby].[SystemUserId])
left join [AccountBase] [new_account_new_bd_action] on ([New_bd_actionExtensionBase].[New_Account_Action] = [new_account_new_bd_action].[AccountId])
left join [CompetitorBase] [new_bd_competitor_action] on ([New_bd_actionExtensionBase].[New_bd_CompetitorStrengthId] = [new_bd_competitor_action].[CompetitorId])
left join [New_custstrengthExtensionBase] [new_bd_custstrength_new_bd_actionExt] on ([New_bd_actionExtensionBase].[New_CompetitorStrengthId] = [new_bd_custstrength_new_bd_actionExt].[New_custstrengthId])
left join [New_custweaknessExtensionBase] [new_bd_custweakness_bd_actionExt] on ([New_bd_actionExtensionBase].[New_OppurtunityWeaknessId] = [new_bd_custweakness_bd_actionExt].[New_custweaknessId])
left join [New_genericactionExtensionBase] [new_bd_genericaction_new_bd_actionExt] on ([New_bd_actionExtensionBase].[New_GenericActionId] = [new_bd_genericaction_new_bd_actionExt].[New_genericactionId])
left join [New_bd_oppurtunityExtensionBase] [new_new_bd_oppurtunity_new_bd_actionExt] on ([New_bd_actionExtensionBase].[New_action_bdoprntyId] = [new_new_bd_oppurtunity_new_bd_actionExt].[New_bd_oppurtunityId])
left join [New_competitorstrengthExtensionBase] [new_new_competitorstrength_new_bd_actionExt] on ([New_bd_actionExtensionBase].[New_Action_CopetitorStrengthValueId] = [new_new_competitorstrength_new_bd_actionExt].[New_competitorstrengthId])
left join [New_custweaknessExtensionBase] [new_new_custweakness_new_bd_actionExt] on ([New_bd_actionExtensionBase].[New_Action_CustWeaknsId] = [new_new_custweakness_new_bd_actionExt].[New_custweaknessId])
left join [New_goalsExtensionBase] [new_new_goals_new_bd_actionExt] on ([New_bd_actionExtensionBase].[New_Action_GoalId] = [new_new_goals_new_bd_actionExt].[New_goalsId])
left join [OpportunityBase] [new_opportunity_new_bd_action] on ([New_bd_actionExtensionBase].[New_OpportunityId] = [new_opportunity_new_bd_action].[OpportunityId])
left join OwnerBase XXowner with(nolock) on ([New_bd_actionBase].OwnerId = XXowner.OwnerId)
go
---> System.Data.SqlClient.SqlException: Invalid column name 'New_name'.
Invalid column name 'New_bd_GoalDetails'.
Invalid column name 'New_Test'.
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)
at Microsoft.Crm.Metadata.SqlHelper.ExecuteBatches(ISqlExecutionContext context, String sqlCommand)
at Microsoft.Crm.Metadata.ViewGenerator.RegeneratePlatformViews(Guid[] entityIds, Dictionary`2 viewSet)
--- End of inner exception stack trace ---
at Microsoft.Crm.Metadata.ViewGenerator.RegeneratePlatformViews(Guid[] entityIds, Dictionary`2 viewSet)
at Microsoft.Crm.Metadata.ViewGenerator.RegenerateViews(ViewGenerationInfoDictionary viewGenerationSet, SqlViewTypes viewTypes, Boolean grantDatabaseAccessToReportViews)
at Microsoft.Crm.Metadata.ViewGenerator.RegenerateEntityViews(String[] entityPlatformNames, SqlViewTypes viewTypes, Boolean grantDatabaseAccessToReportViews)
at Microsoft.Crm.Setup.DiffBuilder.RegenerateAllViews(String isServerMode)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.Crm.Setup.Database.DllMethodAction.Execute()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
InnerException:
Microsoft.Crm.CrmException: SqlException: Invalid column name 'New_name'.
Invalid column name 'New_bd_GoalDetails'.
Invalid column name 'New_Test'., View Script: if exists (select * from sysobjects where name = 'New_bd_action' and xtype = 'V')
begin
drop view [New_bd_action]
end
go
--
-- base view for New_bd_action
--
create view dbo.[New_bd_action]
(
-- logical attributes
------------------------------------------------------------------------------------------------------------------------------------
