anand1
Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Dynamic query, temp table, insert select
Hi, I went thru this older post https://community.smartbear.com/t5/SoapUI-Pro/Stored-Proc-DYNAMIC-SQL-returns-no-rows/td-p/42621 And i also have the similar problem, I am creating a temp table, inserting the data using a SP and then doing some select based on my criteria I am using JDBC test step in my test case to execute this, whenever I am executing it, I am not getting any error, instead i m getting <Results> <UpdateCount>0</UpdateCount> </Results> Although, I expect the output of my Select query which is my last statement. I can see it use to be a bug in earlier version. Not sure if that is still an issue, or am I missing something. Thanks in advance. P.S: It is working fine if I am executing the same in SSMS(Sql Server Management Studio) Regards, Andy1.5KViews0likes3CommentsRe: Losing changes made to a script
HimanshuTayal Thanks for sharing the function, no offence but i m not using my Datagen test step for creating some random values for fields, I m using it for some other purpose. However if I have to generate some random or few specific conditioned data, I would prefer to use the DataSource---> Data Generator feature as it very easy and flexible to use. Fortunately after changing the settings in the Preference as mentioned in one of your earlier threads, for now I have observed my changes are not getting lost, still I will keep a tab on it for a while. sonya_m , you can mark this thread as resolved/Closed. Thank you all for your support.786Views0likes2CommentsRe: Losing changes made to a script
Thanks, yes i did the changes to set the interval time to 30 mins Cleared all the error logs/cache however whenever I save and relaunch the readyapi, i have noticed there is an error https://community.smartbear.com/t5/SoapUI-Pro/Error-while-loading-a-test-case-in-readyapi-3-2-5/m-p/202243#M46271 Not too sure if that helps. Thanks2.8KViews0likes9CommentsRe: Losing changes made to a script
Thanks HimanshuTayal In my test case there is a Datagen Test step and in that step I have added multiple like 10 or so script type variables and then based on my req, i am adding the script. It has been observed more than twice now that I saved my project, restarted the machine and then when executing the test case , lost changes in some of the variables. I am not able to find a pattern as to what all things are getting lost, but it is reverted back to some earlier version. And regarding the settings, the option to save and exit option by default, was default checked and i have provided the interval now which is 0 by default. Let me take some dig if I encounter the same issue again. Thanks2.8KViews0likes11CommentsLosing changes made to a script
I have followed this thread https://community.smartbear.com/t5/SoapUI-Pro/Soapui-Pro-losing-my-test-step-changes/m-p/171647#M39097 And I am a Local admin in my machine when I am using ReadyAPI, I am losing my changes many times, and as i am making changes to script type variables only. So most of the time my script is failing as the changes are not saved. Kindly let me know if there is something else that can be done to resolve it. I m @ 3.2.5 right now.Solved3.2KViews0likes13CommentsRe: Error while loading a test case in readyapi-3.2.5
Thanks richie I worked on by creating a new project altogether and i was still getting that error moment i added that step in my test case/ So i guess i will go with the first option as to Ignore it, as while execution i am not able to see any error in the logs.2.6KViews1like1CommentRe: Error while loading a test case in readyapi-3.2.5
Thanks richie Yes the error warning is generated when i am launching the readyapi and it launch with an existing workspace along with all the tests. And i did had multiple testsuite and testcases earlier , but I removed all except one which is the latest i m working, and the error warning still persists, so I am certain the error is coming from this test case/suite only. And then i digged in further, i am able find the element in a test step which is creating a problem, still not able to figure out, that why it is throwing an error So in my test case there is a DataGen Test step where in I have defined an element of type Template which is holding a value which is coming from the output of some previous step. So when i run the test case till this step, everything works fine, but when i close ready api and re-launch it again, the same error still persists It says like this :- https://pastebin.com/2z8zkaa9 Does that help to figure out what i m doing wrong..? Thanks for your support2.7KViews0likes4Comments