Cannot resolve collation conflict for equal to operation. [SQLSTATE 42000] (Error 446) standby [SQLSTATE 01000] (Error 0) Associated statement is not prepared [SQLSTATE HY007] (Error 0).

Hi Experts

I got this error when i try to run a job  ( This Job restore databases  from dump folder )

code :

declare @err int
exec @err= sp__restorestandby 'd:\dba\log\mssql_monitor.log','d:\dba\log\RESTORE.log','PROD','standby'
if @err <> 0
begin
declare @error varchar(500)
set @error = 'MSQL_ERR_RESTOREDB_PROD: '+ ':Server=' + @@servername+ ':Status= Job Failed :Date =' + convert(varchar(25),getdate(),109)+':Err =' +convert(varchar(10),@err )
exec master..sp__appendtofile 'D:\DBA\LOG\mssql_monitor.log', @error
end


error :
Cannot resolve collation conflict for equal to operation. [SQLSTATE 42000] (Error 446)  standby [SQLSTATE 01000] (Error 0)  Associated statement is not prepared [SQLSTATE HY007] (Error 0).  The step failed.



Please help me out to fix this error