MS SQL Stored procedure failing

Products

• CA API Gateway

Issue/Introduction

Following stored procedure is failing testing using Peform JDBC Query assertion.

EXEC [NCD_CS-ValidateTicket] (9DA8B277-0564-4CD6-882F-0A4A77CEFAF0,Y,TCK,400855026,CRP,'1234567890',NULL,WEB,0)

Environment

API Gateway 11.x

Cause

Issue with default MS SQL driver.

Resolution

Download latest MS SQL driver from Microsoft Website.

https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16#download

Filename: mssql-jdbc-12.6.3.jre11.jar

Installed as per the product documentation Install Your Own JDBC Drivers

Also, remove the brackets [] in the query.

eg: EXEC NCD_CS-ValidateTicket (9DA8B277-0564-4CD6-882F-0A4A77CEFAF0,Y,TCK,400855026,CRP,'1234567890',NULL,WEB,0)