Hi,

If you alter the view or procedure from which you are calling remote view then it will also resolve your issue of this error.

Alter the view and you will have solution.

Also you can use "DBCC FREEPROCCACHE" at your local server to remove the cache.

Thanks,

Anuj Soni