Issue:

On attaching a service template to an existing Device Group, after you click the OK button, you get an exception like the following:

The error is: “Duplicate key sdwan-post-staging…”

This is seen in 21.2.1, due to defect: http://bugzilla.versa-networks.com/show_bug.cgi?id=69641

Conditions:

This is seen in a case where a device/device-group was using a previous post-staging template and then the post-staging template was changed to something new in the device group.

Workaround:

Identify the devices that are impacted by running the following query in the postgres database. This will list the devices that are referring to more than one post-staging template.

1. Log into pqsl with psql -U vnms -d vnms -h localhost

password: Versa@123

vnms=# select device_name, count(*) from template_binddata td, template_metadata tm where tm.name=td.template_name and tm.template_type= 'sdwan-post-staging' group by device_name having count(*) > 1;

vnms=> select * from template_binddata where device_name ='<device-name>';

Note: This list will also include the current post-staging template and service-templates, which need to be preserved.

To confirm which is the active post-staging template used by the device, go to Director UI – Workflow- Devices – Device – Bind-data – Post-staging-template.

Other than the actively used post-staging template, remove the reference to other templates shown in above query.

You can use either of the options to mitigate the error:

Option-1 (Preferred):

Delete unused device post-staging template from template workflow if it is no longer needed for any device. This is preferred option, if this is not feasible then use #2.

Before deleting other unused post-staging templates, confirm that they are not being used by other devices. To confirm, go to Director UI – Commit – Tenant-name – Template-name, this should NOT show any devices under the templated intended for deletion.

Alternatively, this query can be used from the database to find whether this template is used by any other devices.

select * from device_group where staging_template= '<stale-template-name>' OR poststaging_template = '<stale-tempalte-name>';

This query should return 0 rows.

Option-2:

                If option-1 is not possible in case other devices are using the templates that were targeted for deletion, run the postgres query on device-level to remove spurious references.

Run query on point-c to identify the template id of the additional templates and delete them.

vnms=> select * from template_binddata where device_name ='<device-name>';

vnms=> delete from template_binddata where id = '<id-of-additional-template-seen-in-the-above-output>';

Eg:

Lastly,

                Re-run the query from point-c above to confirm that the device is listing only one active post-staging template.