Mpeterson
Occasional Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Testexecute not running as task
I have been using testexecute to run my overnight tests. I have the tests configured to redirect and close the remote desktop session and continue. The TestExecute test is called by Task scheduler in server 2012, the trigger, is my logon from my local machine, and that is a scheduled task to run at 3:00am. This allows my test to run in a redirected RDP session. This has worked for an extensive period, but has suddenly stopped working for all my tests. I cannot get testexecute to run from either a Task or a Batch file, if called from a task. (they do run if manually triggered). On the "Slave" server, testexecute is seen running ( no icon or activity) as an apparent "Ghost" If I manually trigger TestExecute after a Task has called it, it starts again and you have two instances shown in Task Manager. If you again manually start testexecute, it produces a box stating you cannot launch it again. So why would triggering TestExecute from Task Scheduler result in this Ghost? Thanks, MarkProvide oAuth2 "Resource owner credentials grant" fuctionality.
Utilizing oAuth2 tokens; LoadComplete cannot handle passing the token while running load tests in the format required, when using "resource owner credentials grant". This cause the "Data" variable in the Authorization header to contain corupt or incomplete date failing the step. Please add this fuctionality.Re: Is there a bug in the SQL Query Wizard in Ready API 1.3.1?
Using Ready! API Pro 1.4.1 Build Date: 20150909-1157 Another issue with the SQL interface. I have created a connection to my SQL server 2012 using the MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver. The connection is successful. I created a JDBC test step selected my connection, and entered {call CallSequence;1} in the SQL Query field to call my stored procedure. The problem is 1.) My procedure is hardcoded to return a static value, 10000.(for proof of course) USE [Attendance] GO /****** Object: StoredProcedure [dbo].[CallSequence] Script Date: 10/12/2015 8:43:22 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[CallSequence] AS DECLARE @WebCallSequence bigint; UPDATE dbo.WebCallSequence SET @WebCallSequence = WebCallSequence = WebCallSequence + 1 WHERE WebCallSequenceID = 1; SELECT @WebCallSequence AS WebCallSequence; return 10000 When run the response is in the tool is : <Results> <UpdateCount>1</UpdateCount> </Results> And that brings me to issue 2.) When selecting the "Select if this is a stored procedure Checkbox" and selecting the Create Query icon I get an error "Line 1: Invalid procedure number (0) Must be between 1 and 32767" What is interesting is the call is correct and does cal the stored proc, (I can watch the table and see the values changing). My issue does appear to be similar to the thread in this forum: "Stored Proc, DYNAMIC SQL returns no rows" but no soulion is posted. So Am I missing something simple here? Do I need to use the Sourceforge driver? Why is a simple proc with a static value unable to return a value in the JDBC teststep? Thanks, MarkRe: Is there a bug in the SQL Query Wizard in Ready API 1.3.1?
Installed ready API 1.4.0 Build Date: 20150811-1357 The condition is unchanged. Create a Datasource> select the connection (sql)> Build querry> select table and column in querry builder> click the SQL Preview arrow> Specify max rows as "0"> "OK" Query is: Select [API Attendance Values].PersonReferenceId From [API Attendance Values] Six rows of valid data are returned and displayed. Click "OK" The value in the sql Query window is now: Select [API Attendance Values].PersonReferenceId as [API Attendance Values]_PersonReferenceId From [API Attendance Values] There is now a property called "[API Attendance Values]_PersonReferenceId" Click the green "run" arrow at the top of the page> specify max rows as "0" > click "ok" Error pop up appears "Incorrect Syntax near '_PersonReferenceId' "Is there a bug in the SQL Query Wizard in Ready API 1.3.1?
Im connecting to SQL Server 2012, using the MSSQL SQLServerDriver provided with the Ready API Tool. I create and test the connection, it's valid. Using the "Build Query" wizard I select the table and the one field i desire. Select the "Test Query" arrow, select max rows (0 = all) the desired results are displayed. The query is quite simple: Select [API Attendance Values].PersonReferenceId From [API Attendance Values] I click ok and the property is created with the name "[API Attendance Values]_PersonReferenceId" When Ran in the window an incorrect Syntax error is produced, and it's right, the value in the window is now: Select [API Attendance Values].PersonReferenceId as [API Attendance Values]_PersonReferenceId From [API Attendance Values] Ok thats Bad, but if I edit the Query window puting the original working query in, the query runs, tells me it runs, with the time it took.... but no data is displayed in the window, just empty rows. I have not added any custom drivers or configuation to the software. Please Advise, MarkRe: Oauth; Differences in Content from Postman?
Ok I am revisiting this issue, I see that the latest version of SoapUIPro (5.1.1) contained a fix for the RequestFilter.filter.request event. So I ran a basic OAuth test and i was pleased to see the header appended to the request, however I note that I have a new error "Receiving response: HTTP/1.1 401 Invalid timestamp 0. Exceeds configured time to live 00:15:00." So I did a side by side compare of the OAuth headers values: The string produced by Soap is: oauth_consumer_key="6E65A733-B50B-4BAF-A15F-XXXXXXXXXXXX", oauth_nonce="-3337028399705576308", oauth_signature="TMuDrjeiH0mab%2FPCUehZtBJ65WI%3D", oauth_signature_method="HMAC-SHA1", oauth_timestamp="1406739280", oauth_token="a166bbd7-3145-4c47-b0d3-dd0c707db047", oauth_version="1.0" The string produced by Postman is: oauth_consumer_key="6E65A733-B50B-4BAF-A15F-XXXXXXXXXXXX",oauth_token="ca2340d3-3af5-4c0a-990a-15e4cd8ca856",oauth_signature_method="HMAC-SHA1",oauth_timestamp="1406739431",oauth_nonce="TfZ051",oauth_version="1.0",oauth_signature="IbrcWa1G%2B1nWy%2BDtC9or6v7d4g8%3D" Both strings have seemly valid values, and do contain a value for time stamp, but they do have two differences in format. The pattern of the data is different, and the soap string contains spaces after the comma prior to each new value. I don't know if that is the actual cause for the host failing to find the value for "timestamp" but i was wondering if there is a method of removing the spaces or altering the data format. Thanks, MarkRe: TestComplete's .Exists Function
I have found using the plugin "Wait for Object" works best when trying to determine if an object exists. it does provide the result in Jscript, however it maybe helpful to get a grip on the object your checking. It can be found here: http://blog.smartbear.com/software-quality/a-new-wait-for-object-script-extension-for-testcomplete/
