BAQ External Queries

Yahoo Archive
5
I do development in Test, then move to Live. Â We have a test appserver and database that are separate from production.


Tanya Denison | IT Manager | NRS, Inc.
2009 S. Main Street, Moscow, IDÂ 83843
c: 208.301.0599 | p: 208.883.7834 Ext 277 | f: 208.882.1744


On Fri, Nov 1, 2013 at 11:50 AM, <bruce.d.ordway@...> wrote:

 
<div>
  
  
  <p></p><p>Hi Tanya,</p><p> <br></p><p>&gt;&gt; view to run within 10 seconds in SQL Server<br></p><p>&gt;&gt;to consistently get within 30 seconds when run from Epicor</p><p>Good to know.<br></p><p style="font-style:normal;font-size:13px;background-color:transparent;font-family:arial, helvetica, clean, sans-serif;">

I wonder, does this mean you work in live instead of using a test system?

I've been using test so far & still need to verify I can export and import an external BAQ.




Thanks





---In vantage@yahoogroups.com, <tdenison@...> wrote:

I use external BAQs quite a bit, since the BAQ builder is very limited in functionality. The biggest obstacle is that external BAQs have a hard-stop at a 30 second time-out. Â What I have found is that I have to get my view to run within 10 seconds in SQL Server in order to consistently get within 30 seconds when run from Epicor. Â When the external BAQ times out, a BAQ report will error out with "No records selected" as the error. Â Epicor is unable to explain to me why this is inconsistent. Â They were able to tell me that being able to modify the time-out value is in an unscheduled SCR. Â


One thing that I am going to experiment with is using Transact-SQL to provide data back to Epicor, in order to improve performance.



Tanya Denison | IT Manager | NRS, Inc.
2009 S. Main Street, Moscow, IDÂ 83843


On Thu, Oct 31, 2013 at 4:22 PM, <bruce.d.ordway@...> wrote:

 
<div>
  
  
  <p>Just wondering if anybody has any feedback on using External Queries.<br><br>I&#39;ve been experimenting with building some of my more complex SQL views.<br>I have seen one bug so far...a view name can&#39;t be longer than 30 characters.<br>

Otherwise they seem to display in BAQs OK.

Thanks

</div>
 


<div style="color:#fff;"></div>


</div>
 


<div style="color:#fff;min-height:0;"></div>