Hi Aron,

It's unlikely that the platform upgrade from OS10 to OS11 would introduce changes in the way it executes the SQL query you shared.

Is it possible that the team responsible for the maintenance of the GW_PEEK_ASYNC stored procedure changed it so that either the procedure signature or something inside the procedure requires a new parameter? If the procedure was not changed, I suggest that you investigate if it uses a dependency that was changed. One such dependency could be the OutSystems data model, if you are accessing it directly inside the said stored procedure.

With the information you give its difficult to understand the issue. Please share more findings, it will help to drill down on the issue.

Cheers,

   Frederico

Aron,

It is quite possible that the Stored Procedure definition, or signature may have changed. Frederico has pointed towards same.

If your DBuser has sufficient privilege, you should be able to query the remote database to check the definition and the parameters.

1. EXEC sp_helptext N'DatabaseName.dbo.GW_PEEK_ASYNC';  
   

2. SELECT * 
   FROM sys.parameters 
   INNER JOIN sys.procedures ON parameters.object_id = procedures.object_id 
   INNER JOIN sys.types ON parameters.system_type_id = types.system_type_id AND parameters.user_type_id = types.user_type_id
   WHERE procedures.name = 'GW_PEEK_ASYNC'

Regards,

Swatantra

Hi Aron, 

Are you sure the log is output when you calling the stored procedure?

Not the after step?

Regards,