JDBC SQL Server Channel Calling Stored Procedure Won't Return Result Set

[ChadRichardson]

Good afternoon, Experts

We're calling a stored procedure in a sender communcation channel. I can perform any SQL SELECT statement here, but for some reason when I execute the SP (EXECUTE StoredProcedureName) The Adapter Engine returns the following:

Database-level error reported by JDBC driver while executing statement 'DECLARE @UpdateRecords bit SET @UpdateRecords = 0 EXECUTE ExportToSAP @UpdateRecords'. The JDBC driver returned the following error message: 'com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.'. For details, contact your database server vendor.

Even stranger yet is is that this works just fine on our PI-DEV system. I created an identical communication channel connecting to the same database with the same UID and PWD and it won't work in PI-QAS.

Any help/ideas you could share would be greatly appreciated!!!

Thanks,

Chad

[former_member782228]

Hello, I want to ask how to configure the result set in MM

[ChadRichardson]

Turns out we were missing some of the MSSQL JDBC drivers on our PI-QAS box.

[former_member241146]

Hi Chad.

Normally, itu2019s a problem with your procedure. The Store Procedure is wrong and something is different between your DEV environment and QAS environment.

Try to ask to DB team check it.

Regards,

Bruno