Hi,
Im trying to migrate our NPM database to another Server which is configured with Orion 11.5.2 but when running configuration wizard we are getting below error: This question has been raised by other users but not yet answered.
Logs:
-- C:\Projects\OrionCore\CurrentKSR\DEV\Main\Orion\Core\Src\Config\SQL Scripts\Restructure\UpdateLimitationTypes.sql
--
-- related to NodeSplit feature, during upgrade we need to update LimitationTypes to use table NodesData (NodesCustomProperty) instead of table Nodes
-- we need do this update here in Restructure script, because processing .DBStructure causes data duplication
IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LimitationTypes' and TABLE_TYPE = 'BASE TABLE' )
AND EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'CustomPropertyMetadata' and TABLE_TYPE = 'BASE TABLE' )
BEGIN
UPDATE [dbo].[LimitationTypes]
SET [LimitationTypeTable] = N'NodesData'
WHERE [LimitationTypeTable] = N'Nodes'
and not exists (select * from [CustomPropertyMetadata] cpm where [LimitationTypeField] = cpm.[Name] and cpm.[TargetEntity] = N'Orion.NodesCustomProperties')
UPDATE [dbo].[LimitationTypes]
SET [LimitationTypeTable] = N'NodesCustomProperties'
WHERE [LimitationTypeTable] = N'Nodes'
and exists (select * from [CustomPropertyMetadata] cpm where [LimitationTypeField] = cpm.[Name] and cpm.[TargetEntity] = N'Orion.NodesCustomProperties')
END
2017-08-02 05:59:48,861 [6] ERROR ConfigurationProgressScene - Error while executing script- Invalid column name 'TargetEntity'.
SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Invalid column name 'TargetEntity'.
at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)
at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.Process(IDbConnection connection, ConfigurationProgressDelegate progress, String scriptFile, ConfigurationLogDelegate logger)
at SolarWinds.ConfigurationWizard.Plugin.Orion.OrionMainPlugin.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate logger)
at SolarWinds.ConfigurationWizard.Plugin.Orion.OrionMainPlugin.DoConfigure(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate logger)
at SolarWinds.ConfigurationWizard.Plugin.Common.OrionConfigPlugin.SolarWinds.ConfigurationWizard.Common.IOrionConfigPlugin.DoConfig(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
at SolarWinds.ConfigurationWizard.Host.Presentation.CommonConfiguration.ConfigurationProgressScene.DoConfigForComponent(IOrionConfigHost host, Int32 componentId)
