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.
• Following log entries seen in NSX manager logs at /var/run/log/proton/nsxapi.log:

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"}
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


Environment

• NSX 4.2 or older
• NSX-T 3.2.4 or older

Cause

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

Resolution

This issue is resolved in VMware NSX 4.2.1