Forum Discussion

mpourali's avatar
mpourali
Occasional Contributor
8 years ago

running a simple sql in ReadyAPI, sometimes returns partial response. Fails the assertion.

I had to add a "waitfor delay" and "Top 100" to force the complete response to be displayed. This increases the chance of getting the complete response, but still fails once-a-while.

 

Randomly, SoapUI NG Pro (version 1.8.5) return the xml response in fewer # of lines, which fails the assertions. Running it again, it again, I will get the full (complete) response.

 

WAITFOR DELAY '000:00:15'
SELECT TOP 100 * FROM [DBname].[dbo].[Tablename]
where servername = 'Servername' AND UniqueID = 'NNNN'

order by InsertedDts DESC

 

Question: is there a 'sure' workaround to fix this (ie. to get the complete response all the time). Once a while, there is an error in the response which is not too informative.

 

Thanks,

No RepliesBe the first to reply