I get a successful connection to a SQL Server, DAXBuilder database. I can successfully run the same query (which calls a stored procedure) against that database in Microsoft SQL Server Management Studio:
When I attempt to run that same query in Katalon Studio, using Data Files > Test Data > Database Data, even though the connection to the database is successful…
I get this error:
Wrong number of parameters: expected 4, was given 0 Query: EXECUTE EmployeeCallPerformanceAverageTpaScore @AccountJSON = '[]', @SiteJSON = '[]', @StartDate = '2018,1,4', @EndDate = '2018,3,5' Parameters: []
How do I correct this error and get the query to successfully return results?
Realized that I did not use the bug template, but was not sure this was a bug, here is that info:
To help us reducing time in analyzing a bug and also help you to quickly resolve your issue, it’s recommended that you use below template to post your issue.
Realized that I did not use the bug template, but was not sure this was a bug, here is that info:
To help us reducing time in analyzing a bug and also help you to quickly resolve your issue, it’s recommended that you use below template to post your issue.
I see nothing in the log that seems relevant and has a valid timestamp.
**## Expected Behavior - **to be able to run the query successfully and return data
**## Actual Behavior - **get this error “Wrong number of parameters: expected 4, was given 0 Query: EXECUTE EmployeeCallPerformanceAverageTpaScore @AccountJSON = ‘[]’, @SiteJSON = ‘[]’, @StartDate = ‘2018,1,4’, @EndDate = ‘2018,3,5’ Parameters: []”
## Screenshots / Videos
please see screenshots above
Thank you in advance for your help!
Hello Brad,
I am using latest version of katalon but still i am facing similar issues while running SQL stored Procedure and unable to run procedure using Katalon database checkpoints. Please let me if this issues resolved or not. Or is there any workaround in Katalon to execute stored procedure using database checkpoints.
