I had a view which was not in the destination. this view is used by several sps.

but in the scripts for sps, sp_refreshview 'oldview' statment is written which returns an error.