Dears, 

There was an issue in implemented logic but it has been handled. 
Patch is needed: 3.7.0.1335

Regards, 
Mustapha

Dears @Abir Messaikeh, @Aurobinda Panda,

The duplicate entries in IPdata have been addressed. I applied the scripts to remove all entries that have a nodeID Null.
Please apply the latest patch, restart the server, and confirm once the changes are verified.
Best Regards,

Marwan Kanaan I Software Developer

Dear @Aurobinda Panda,

After rechecking, I found that the issue was caused by an incorrect node ID.

"screenshot attatched"

The problematic entry has been deleted, kindly restart the server and verify the changes.
Best Regards,

Marwan Kanaan I Software Developer

to check if the solution of LS-561 solved this issue

a clean up is needed for ips without nodeid and status is usedbynetowrk and free

Dear @Aurobinda Panda,

Kindly note that another cleanup script was executed today to address any IPs without a node ID and with a status of “UsedByNetwork” or “Free.” This aligns with the new IP data saving logic, which now deletes any IP entries lacking a node ID to prevent duplication.

Kindly verify when possible.

Changes will be checked post XML Import.

Dear @Marwan, As checked, Still issue not fixed post script run on 180 and prod. Please check again.

Dear @Aurobinda Panda,

Another clean script for IPS has been completed. Kindly check and verify it at your earliest convenience.

Best Regards,

Marwan Kanaan I Software Developer

Dear @aurobinda,

the last clean up done on .180.

Best Regards,
Marwan Kanaan I Software Developer

@marwan,
Still IPs found without NE. Please check again.

SS attached for your reference.

@aurobinda kindly add new details if the issue still exsit