Error Initializing Cross Reference Cache in Application Modules Diagnostic View

Issue
Unable to edit sources or measurements on existing gadget or create new gadget. The application modules diagnostic view will include the following message:
Error initializing cross reference cache. ---> Framework.Common.Exceptions.ModuleException: Data Source Device [*****] is defined multiple times. where [*****] is the name of a device in the system.

Product Line

Power Monitoring Expert 7.2

Power Monitoring Expert 8.x

Power Monitoring Expert 9.x

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment
SQL Server Management Studio

Cause
Multiple entries in the [ApplicationModules].[DataSourceBus].[DataSourceDevice] and/or [ApplicationModules].[DataSourceBus].[LogicalDevice]  tables

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
A) Determine the LogicalDeviceId in the DataSourceDevice table
1) Use Applicationmodule
Select Description, count(*) from [DataSourceBus].[DataSourceDevice] group by [description]
having count(*) > 1

2) Use the description field in the query below;
Use Applicationmodules
Select Description, LogicalDeviceID, from [DataSourceBus].[DataSourceDevice] where [description] like '*******'

B) Remove the duplicate entries
1) Make backup of AppicaltionModuless database
2) Shut down the AppMods services
3) Run ApplicationModules-DeleteAllDeviceMetadata.sql attached (the device metadata will get rebuilt)
4) Run the following query where aaa,bbb,ccc are LogicalDeviceIds found in section A
-- delete duplicate devices
delete from DataSourceBus.datasourcedevice where DatasourcedeviceID in (aaa,bbb,ccc)
delete from DataSourceBus.logicaldevice where logicaldeviceID in (aaa,bbb,ccc)
5) Start the AppMods services
6) Check the Diagnostics.LogEvent table to verify that Data Source Bus initialized correctly

게시 대상: 슈나이더 일렉트릭 Korea