Hi @vineethpa202,
During a migration that I am working on right now from v7 to v13, I ran into this error and it was a couple of nodes that were without name (that does not means null, as you searched).
I could not find them via DB (I must confess that I am not very good at SQL rather than C#) but I did find them using uSync.
I simply ran the original site, installed uSync Content Edition, configured it to use UUID instead of names and then made a clean full export. The site was large so it took a while but then with Notepad++ I made a Search in files using regular expressions to find files that have the field nodeName empty or with whitespace. In my case, I found two, copied apart their id’s, got to the backend, corrected those two and it worked.
Hope this helps.
Greetings,
Daniel.