FROM: Mark Rose, St Vincents Pathology

We have been unable to print the Undelivered Results report in ATTrak for the last few days, getting a timeout message. I have restarted the ATTrak service, but still can't get the report.

FROM: Glen Kleidon

Can you do a query on the SQL server enterprise manager or Query manager?

With regards to the ATTrak report, I can connect to the database through SQL, so that is not an issue. It does not matter which machine I run the application , I can't get the report.

FROM: Glen Kleidon

I'll send you the query that is actually performed and see what happens on the SQL server.

TO :Jason Khoi FROM: Glen KLeidon

Jason, can you pull out the SQL query that runs when you select the undelivered report in ATTrack Client?

Then could you forward it to Mark

TO: Mark Rose FROM: Jason Khoi

Hi Mark,

Please try the following SQL query and see what results you get:

<SNIP>

FROM: Mark Rose:

Thanks Jason.

The script gave the same results as what we would usually get in the report.

Mark

FROM: Glen Kleidon

How long did it take mark?

FROM: Mark Rose

On average around 35 seconds

FROM: Glen Kleidon

Ah-HA!

That would do it. Default timeouts for ATTrack queries is 30 Seconds.

I have posted an update to the ATTrack client on the website

(Timeouts are now 5 minutes).

Glen.