Hi Vineela,
Sorry for the delay in getting back on this. I am able to identify the issue. The issue is in your action configuration. The query you are trying to run is the select query and you are anticipating a result-set out but in your configuration you have mentioned that
Is Update =true, which make this query an update query and it will just result out how many records are getting impacted but not the result set.
This the reason you are getting
"Actual Affected Lines" 1.
Please make
Is Update= false to run it as a select query returning result set.
I verified the same in lab and it worked fine for me.
Regards,
Saurabh
------------------------------
Regards,
Saurabh
------------------------------
Original Message:
Sent: 08-12-2019 09:59 AM
From: Vineela N
Subject: Getting an empty result for SQL command execution in CA Release Automation Tool.
Hi Team,
We are getting an empty result set for SQL command execution through CA Release Automation Tool. Manually if we execute the sql command it is working but through tool it is not executing.
SQL Query execution result snapshot through tool is posted.Please go through it.
Here if u observe in the second snapshot,clearly it is showing like empty result for sql command.
Please suggest me on this.How can i correct it to get exact output.
Thanks and Regards,
Vineela