507A Bug? BAQ that uses QuoteHed does not return rows?

Hi Joe

I just tested it and it works fine

we are on 9.04.507A and i applied the BAQ hotfix already



On Tue, Jan 25, 2011 at 3:11 PM, Joe Rojas <jrojas@...> wrote:

>
>
> Hi All,
>
> I was debugging a BAQ when I stumbled upon an issue when using the
> QuoteHed table.
>
> To test, I created a whole new BAQ that had just the QuoteHed table. I
> didn't put any criteria against QuoteHed, added a couple of display
> columns, pressed Test and no rows are returned even though I have 30 to
> 40 Quotes in the system.
>
> Can someone else on this patch level do a similar test?
>
> I've called Epicor to log a call but I wanted to check if it's just an
> issue for me or is it wide spread.
>
> Thanks!
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 <tel:+17815730291> | cell: 781-408-9278<tel:+17814089278>| fax:
> 781-232-5191 <tel:+17812325191>
> jrojas@... <jrojas%40matsinc.com> | www.matsinc.com Ask us about
> our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Hi All,



I was debugging a BAQ when I stumbled upon an issue when using the
QuoteHed table.



To test, I created a whole new BAQ that had just the QuoteHed table. I
didn't put any criteria against QuoteHed, added a couple of display
columns, pressed Test and no rows are returned even though I have 30 to
40 Quotes in the system.



Can someone else on this patch level do a similar test?

I've called Epicor to log a call but I wanted to check if it's just an
issue for me or is it wide spread.



Thanks!










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
We have a 9.05.602 Instance Tried doing what you suggested and I get

Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
Please contact your System Administrator.

NO sure if its related or not but very odd


*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Tue, Jan 25, 2011 at 3:11 PM, Joe Rojas <jrojas@...> wrote:

>
>
> Hi All,
>
> I was debugging a BAQ when I stumbled upon an issue when using the
> QuoteHed table.
>
> To test, I created a whole new BAQ that had just the QuoteHed table. I
> didn't put any criteria against QuoteHed, added a couple of display
> columns, pressed Test and no rows are returned even though I have 30 to
> 40 Quotes in the system.
>
> Can someone else on this patch level do a similar test?
>
> I've called Epicor to log a call but I wanted to check if it's just an
> issue for me or is it wide spread.
>
> Thanks!
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <jrojas%40matsinc.com> | www.matsinc.com Ask us about
> our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Thanks Jose.

It probably is related.
507A has been a nightmare for us. Each turn we take seems to reveal a
new issue.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Tuesday, January 25, 2011 3:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 507A Bug? BAQ that uses QuoteHed does not return
rows?

We have a 9.05.602 Instance Tried doing what you suggested and I get

Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
Please contact your System Administrator.

NO sure if its related or not but very odd


*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Tue, Jan 25, 2011 at 3:11 PM, Joe Rojas <jrojas@...> wrote:

>
>
> Hi All,
>
> I was debugging a BAQ when I stumbled upon an issue when using the
> QuoteHed table.
>
> To test, I created a whole new BAQ that had just the QuoteHed table. I

> didn't put any criteria against QuoteHed, added a couple of display
> columns, pressed Test and no rows are returned even though I have 30
> to
> 40 Quotes in the system.
>
> Can someone else on this patch level do a similar test?
>
> I've called Epicor to log a call but I wanted to check if it's just an

> issue for me or is it wide spread.
>
> Thanks!
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <jrojas%40matsinc.com> | www.matsinc.com Ask us
> about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Sounds like I have a lovely road ahead!

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Tue, Jan 25, 2011 at 3:22 PM, Joe Rojas <jrojas@...> wrote:

>
>
> Thanks Jose.
>
> It probably is related.
> 507A has been a nightmare for us. Each turn we take seems to reveal a
> new issue.
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <jrojas%40matsinc.com> | www.matsinc.com Ask us about
> our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> -----Original Message-----
>
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf
> Of Jose Gomez
> Sent: Tuesday, January 25, 2011 3:18 PM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Subject: Re: [Vantage] 507A Bug? BAQ that uses QuoteHed does not return
> rows?
>
> We have a 9.05.602 Instance Tried doing what you suggested and I get
>
> Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
> Please contact your System Administrator.
>
> NO sure if its related or not but very odd
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@... <jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Tue, Jan 25, 2011 at 3:11 PM, Joe Rojas <jrojas@...<jrojas%40matsinc.com>>
> wrote:
>
> >
> >
> > Hi All,
> >
> > I was debugging a BAQ when I stumbled upon an issue when using the
> > QuoteHed table.
> >
> > To test, I created a whole new BAQ that had just the QuoteHed table. I
>
> > didn't put any criteria against QuoteHed, added a couple of display
> > columns, pressed Test and no rows are returned even though I have 30
> > to
> > 40 Quotes in the system.
> >
> > Can someone else on this patch level do a similar test?
> >
> > I've called Epicor to log a call but I wanted to check if it's just an
>
> > issue for me or is it wide spread.
> >
> > Thanks!
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@... <jrojas%40matsinc.com> <jrojas%40matsinc.com> |
> www.matsinc.com Ask us
> > about our clean, green and beautiful matting and flooring
> >
> > This message is intended only for the individual named. If you are not
>
> > the named addressee you should not disseminate, distribute or copy
> this e-mail.
> > Please notify the sender immediately by e-mail if you have received
> > this e-mail by mistake. Please note that any views or opinions
> > presented in this email are solely those of the author and do not
> > necessarily represent those of the company.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]
9.05.601B works fine FYI.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Tuesday, January 25, 2011 3:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 507A Bug? BAQ that uses QuoteHed does not return rows?



Hi All,

I was debugging a BAQ when I stumbled upon an issue when using the
QuoteHed table.

To test, I created a whole new BAQ that had just the QuoteHed table. I
didn't put any criteria against QuoteHed, added a couple of display
columns, pressed Test and no rows are returned even though I have 30 to
40 Quotes in the system.

Can someone else on this patch level do a similar test?

I've called Epicor to log a call but I wanted to check if it's just an
issue for me or is it wide spread.

Thanks!







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.

[Non-text portions of this message have been removed]



---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]