something similar we already worked on in previous org. for oracle probe and it is working successfully for bulk deployments .
This is what i can see in the logs
Oct 14 18:44:45:366 [14524] sqlserver: Checking no migration will be performed in this run
Oct 14 18:44:45:397 sqlserver: (NimCryptographerCfgKeyReadEncryptedValue) failed to decrypt value. RC=3
Oct 14 18:44:45:397 sqlserver: (NimCryptographerCfgKeyReadEncryptedValue) failed to decrypt value. RC=3
Oct 14 18:44:45:397 sqlserver: Profile: test/db_status, query checksum is not correct, query might have been manipulated - checkpoint deactivated
Oct 14 18:44:45:397 sqlserver: fwSave_alarm - called with invalid parameter
Oct 14 18:44:45:397 sqlserver: fwCreateCheckpoint active no
Oct 14 18:44:45:397 sqlserver: Profile: test/db_backup_status, query checksum is not correct, query might have been manipulated - checkpoint deactivated
Oct 14 18:44:45:413 sqlserver: fwSave_alarm - called with invalid parameter
Oct 14 18:44:45:413 sqlserver: fwCreateCheckpoint active no
------------------------------
HCL Technologies
------------------------------
Original Message:
Sent: 10-14-2020 12:52 PM
From: Gene HOWARD
Subject: custom query and check point - query is coming up blank and checkpoint as not active chcked - Sql servr probe
this is expected because of the MD5 Hash check.
If you check the loglevel 5 logs you will see that is says the MD5 Hash does not match and will not process.
------------------------------
Gene Howard
Principal Support Engineer
Broadcom
Original Message:
Sent: 10-14-2020 12:51 PM
From: Sid
Subject: custom query and check point - query is coming up blank and checkpoint as not active chcked - Sql servr probe
i played here and there
I now see the checkpoint and query is also populating , but in the template it is not coming up as active even after i have put it like ACTIVE =YES in cfx
------------------------------
HCL Technologies
Original Message:
Sent: 10-14-2020 09:03 AM
From: Gene HOWARD
Subject: custom query and check point - query is coming up blank and checkpoint as not active chcked - Sql servr probe
So I am not sure you can do a bulk config of a custom checkpoint.
The reason being is the probe stores and MD5 Hash of the custom checkpoint after it is tested in the GUI.
Once this is done then every time the checkpoint is run this is checked against the local file to make sure it has not been tampered with as a security measure.
When you create this on one system but then copy it to another this will cause the MD5 hash to change and so when deployed to a new system the checkpoint will not be executed.
You should be able to see this happening in the loglevel 5 logs.
Maybe some others have found a way to get this to work and can comment further.
------------------------------
Gene Howard
Principal Support Engineer
Broadcom
Original Message:
Sent: 10-14-2020 03:20 AM
From: Sid
Subject: custom query and check point - query is coming up blank and checkpoint as not active chcked - Sql servr probe
I tested it on the probe on many servers, I am getting the output as expected.
But when I use it for bulk deployment via CFX it comes up blank.
What am i missing cant understand....
------------------------------
HCL Technologies
------------------------------