Issue while running MS SQL server stored procedures

We are using metabase with H2 database for developing charts for our client. customer database is MSSQL Server. while making charts using stored procedures we are facing few issues.

  1. a stored procedure returning data while running on sql server is showing empty result set when same is used in Metabase as query.

  2. during each refresh, same stored procedure is returning different values. (no such issue while running directly).

caching is disabled in metabase admin settings.

First of all move away from h2. Secondly post troubleshooting info