NSX Error code: [500065]. Message: [Unable to reorder security policies. Internal Failure with sequence_number -1] when using revise API.

Products

• VMware NSX

Issue/Introduction

Deployments using API calls to create firewall rules sections fail on the 200th policy using insert_bottom.

Environment

 Versions up to NSX 4.2 and NSX-T 3.2.4

Cause

When creating all security policies with /nsxapi/api/v1/infra/domains/default/security-policies/Bell?action=revise&operation=insert_bottom API, on reaching 200 it assigning wrong sequence no (out of range) which is causing above exception.

Resolution

This issue is resolved in VMware NSX 4.2.1

Additional Information

Checking the nsx manager logs in /var/run/log/proton/nsxapi.log we see the following log entry:

2024-06-16T05:48:45.219Z  INFO http-nio-127.0.0.1-7440-exec-39 NsxBaseRestController 4131 SYSTEM [nsx@6876 comp="nsx-manager" level="INFO" subcomp="manager"] Error in API /nsxapi/api/v1/infra/domains/default/security-policies/0af92186-####-####-####-####?action=revise&operation=insert_bottom caused by exception com.vmware.nsx.management.policy.policyframework.exceptions.InternalFailureException:  {"moduleName":"Policy","errorCode":500065,"errorMessage":"Unable to reorder security policies. Internal Failure with sequence_number -1"}
2024-06-16T05:48:45.219Z  INFO http-nio-127.0.0.1-7440-exec-39 NsxBaseRestController 4131 SYSTEM [nsx@6876 audit="true" comp="nsx-manager" level="INFO" subcomp="manager"] >UserName:'admin' ModuleName:'Policy' Operation:'POST@/api/v1/infra/domains/default/security-policies/0af92186-####-####-####-####' Operation status: 'failure' Error: Unable to reorder security policies. Internal Failure with sequence_number -1