issue analysis and script executed and post result check

i have shared logs from jk circle to dev team for some ipdata and ipv6 data deletion .

tested the scenerio for generating duplicates at local before code change not able to reoccur with available xml..found duplicates ip in xml..shared with marwan and bessem checked another case where ip present in db but not reflecting in nep checked logs and condstructed updation queries and deletion

checked the prod data for changes and updation checked the report at prod discussed with integartion regarding script excution requested latestest logs checked logs still the exception during load of logical interface regiving scripts.

DATA VALIDATION FOR DUPLICATE IP ENTRY

checked logs contacted integration for exact time of query execution last and activity description happend during that time..had discussion with bessem reviewed script..reupdated the script found ipdatav6id missing reupdated script tested at local double checked with bessem and re released for execution on PROD

i have run deletion queries on JK prod after that restarted the services .

Internal discussion with team for the issue.

checked prod for if the blanks and ip not reflecting error solved after query execution checked logs aswell as prod data had discussion with marwan for further testing of root cause and its solvation process asked the telco for two small xml with same sample node diff ip config

we have Executed the SQL queries on the DL and JK databases after that restated the services then shared logs with priyasha

we have triggred xml on .37 server

copied dumps and generated xml for IP Count Mismatch in DL Circle IN IP Report

xml generated and shared with priyasha for Count Mismatch in DL Circle IN IP Report

shared static sheet from JK circle for IP Count Mismatch in DL Circle IN IP Report

XML shared with sample cases whose interface ,phy conifg are changing

had discussion with marwan require a new small xml with full physical config as the shared one have only logical config ...checked the related config on prod if the sample case shared have proper info or not

new sample case to L3 as requested

i have extract FSCT564 node from JK circle logical IP and shared on mail .

coordinating with AI team for XML file for single node of ericssion

i shared dumps from jk prod server

checked the xml shared by telco not proper re requested again xml shared in evening as checked is ok

internal and call and validating the sample case with l3 team

CALL WI l3

checking the xml shared last importing in local checking the flow for saving of nodeinterface and ipdata debugging on that

checking the on reimport the flow debugging

CALL WITH l2 AND l3 FOR DELETION SCRIPT

migrated the code and give it to srishti to test it

applied patch shared by marwan for ip added attribute in DB and manipulated xml ...some regression in code not building correcting workspace