JDBC Data Source step not returning records when testcase executed outside ReadyAPI desktop client
We are using SpiraTest/RemoteLaunch as our testcase management tool and automation hub. When our tests are executed via RemoteLaunch, our data source step doesnt appear to be returning records from our postgres db. When the testcases are executed via ReadyAPI deskop client, the data source successfully returns the expected records from our db.
Here's our ReadyAPI test case setup:
1. The testcase ID from SpiraTest (TCID) is sent to our ReadyAPI project via Remote Launch (Spira) and stored as a project level property. (confirmed)
2. The TCID is then used as a query parameter in a JDBC data source step to fetch testcase specific data that will be populated into our parameterized REST request.
From the ReadyAPI log files, I can confirm the testcase is being executed, but the data source step appears to be retrieving zero rows from postgres. When executing a testcase from outside the desktop client, do we need to manage our db connection strings differently or is there additional configuration needed to be able to execute these queries in our data source step?