Highlighted
Super Contributor.
Super Contributor.
144 views

2017SP4 ZDC: tg_IsRetired_Ins_Upd: Definition hash mismatch

Hi,

have a ZCM 2017SP4. When run ZDC (ZENworksDiagnosticCenter_17.4.0.zip) I got

Severity Description

ERROR Mismatch in table 'zDevice' structure.
Object type: [Trigger] , Object name: [tg_IsRetired_Ins_Upd]
Expected: [Name: tg_IsRetired_Ins_Upd, Table: zDevice, Definition hash: e7f02406]
Found: [Name: tg_IsRetired_Ins_Upd, Table: zDevice, Definition hash: c18223fa]

 

Does this mean there is a repair needed?

(I run ZDC as preperation for DB-Migration Sybase -> PostgreSQL)

If there is a repair needed, is there a howto anywhere?

Labels (1)
0 Likes
2 Replies
Highlighted
Honored Contributor.
Honored Contributor.

Re: 2017SP4 ZDC: tg_IsRetired_Ins_Upd: Definition hash mismatch

I was showing about 20 trigger errors before my 2017-2020 DB migration.  DId a SR at the time and was told   triggers get dropped and recreated during the database migration.

https://community.microfocus.com/t5/ZCM-User-Discussions/2017-Appliance-to-Zenworks-2020/td-p/2702528

 

Jim

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: 2017SP4 ZDC: tg_IsRetired_Ins_Upd: Definition hash mismatch

Good to know. So I will go forward ...
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.