Sharing here so that it can be beneficial for others having similar issue.
The issue was identified as wrong lun pathid entry in DFM DB for a particular filer and it was causing the acquisition to fail.
We worked with engineering and got this fixed.
We were provided with custom SQL update using following:
dfm query run -f "update ------------------->
Thanks!
Deepak