Sree_sri , if you take a look at my first post this is exactly what I did but got an error.

well anyways I was able to find a solution for the problem.

It was because global_names was set to true in my sid7 database and was false in the sid8 database hence this conflict.

I set it to false and it works fine now.

Thanks a lot for your patience and helping me out.