This article explains how to fix the policy push issue with the error message "statement has no contents". However, the configuration will be pushed successfully to the device. Here is the error message with a screenshot:

This issue will occur when the Security director tries to push the address object with no value as per the below screenshot

To fix the issue, please follow the below steps:

• Delete the unused address objects from UI using:

 Navigate to Configure > Shared objects > Addresses > More > Show Unused > Delete all the unused address objects.

• Once done, we need to run the below commands from the CLI to delete unmapped address objects with the publish table :

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') sm_db

SET FOREIGN_KEY_CHECKS=0;

delete from AddressCMEntity where designObjectUUID not in (select id from ADDRESSENTITY);

SET FOREIGN_KEY_CHECKS=1;