Deployments using API calls to create firewall rules sections fail on the 200th policy using insert_bottom.
Versions up to NSX 4.2 and NSX-T 3.2.4
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.
This issue is resolved in VMware NSX 3.2.5
This issue is resolved in VMware NSX 4.2.1
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