unable to delete device from cisco prime infrastructure 3.4.0

[Nadia Bbz]

Dear Team ;

i'm trying to delete device from cisco prime 3.4.0 but i'm getting

xx.xx.xx.xx, Please check the following logs for failure reason: ifm_inventory.log,inventory.log, existenceInventory.log,persistence.log under /opt/CSCOlumos/logs Directory.

we have tried this method but nothing happen

ade # cd /opt/CSCOlumos/bin/
ade # ./sql_execution.sh "delete from ipaddress where replace(ipaddress_address,' ','') in ('xx.xx.xx.xx')";

0 rows deleted.

ade # ./sql_execution.sh "commit";

Commit complete.

[Mark Elsen]

 - Verify if the real-value if the device ip address is correct.

 M

[Nadia Bbz]

hi @Mark Elsen ;

thanks for your reply 

the ip address of device is correct