Global sync failed

Products

• Network Observability

Issue/Introduction

Global sync failed in stage Global Domain Groups Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO temp_changed (ItemID, DomainGroupID, ItemType, ItemSubType) SELECT t.ItemID, tg.ItemID, i.ItemType, t.ItemSubType FROM t_network_path t INNER JOIN items i ON t.ItemID=i.ItemID INNER JOIN t_group tg ON tg.OwnerItemID=t.DomainID WHERE i.UpdatedOn>=1679762807];

 

This occurred after the Spectrum data source was upgraded to 22.2

Environment

Release : 21.2

Cause

The DX Netops Spectrum data source was upgraded to 22.2.1 or later, with the Portal and the rest of DX Netops Performance Management still at 21.2.x or earlier, and a sync happened between the two.

DX Netops Performance Management is REQUIRED to be upgraded first, or the DX Netops Spectrum data source should be disabled before upgrading it and not re-enabled until both the DX Netops Performance Management and DX Netops Spectrum are on the same version

Resolution

The following actions are required before upgrading the DX Netops Portal. Upgrading will not resolve this issue.

 

1) Stop the Portal services (not mysql)

2) Login to MySql

mysql netqosportal -u netqos -p

Enter the mysql password when prompted

3) Run the SQL commands that follow. Note that the drop table will report Query OK 0 rows affected, this is normal

drop table t_network_path;

delete from item_property_types where itemtype=(select distinct itemtype from item_types where itemtypename='network_path' limit 1);

delete from item_types where itemtypename='network_path';

delete from ds_item_types where itemtypename='network_path';

4) Start the portal services.

Additional Information

See the DX Netops Upgrade documentation for the proper order in which to upgrade the DX Netops Components