BAQ report sometimes gives "No Records Selected."

Yahoo Archive
1
Check into the xml file that matches the time for the task in system monitor...In the XML it will show the filter and options chosen - are they different?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tanya_denison
Sent: Thursday, July 25, 2013 4:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ report sometimes gives "No Records Selected."



I have a BAQ report that is based on an external BAQ. My user needs to run this 10-20 times per day, but lately 90% of the time the report does not print, and the detail says No Records Selected. The issue is, he's using the same parameter (supplier ID) every time.

In SQL Server, my view takes 13 seconds to run, so it doesn't seem like a timeout issue. It does complete successfully sometimes, using the same supplier ID that 3 minutes earlier threw the above error.

Has anyone run into intermittent "No Records Selected" errors? Thanks for any insight!



[Non-text portions of this message have been removed]
2
I have a BAQ report that is based on an external BAQ. My user needs to run this 10-20 times per day, but lately 90% of the time the report does not print, and the detail says No Records Selected. The issue is, he's using the same parameter (supplier ID) every time.

In SQL Server, my view takes 13 seconds to run, so it doesn't seem like a timeout issue. It does complete successfully sometimes, using the same supplier ID that 3 minutes earlier threw the above error.

Has anyone run into intermittent "No Records Selected" errors? Thanks for any insight!