BAQ Table Relations Issue

Yahoo Archive
1
There is a bug in this version that bit us also... BAQs in 9.04.507A cannot properly relate more than two tables.

Call Epicor support and request SCR 78693.

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com, "mike.numbers" <mnumbers@...> wrote:
>
> I have a BAQ that has 5 tables. When I look at the table relations, all of the tables have the same relationships, even though the fields are not in the table. When I look at the General view the relationships are confirmed on that screen. Right now the BAQ is working, but I need to add a new table and when I do that I get an error saying I have "More that 1 root table". When I delete the relationships from one table, they get deleted from all table relationships. Any ideas on how the fix this?
> 9.04.507a
> Mike
>
2
I have a BAQ that has 5 tables. When I look at the table relations, all of the tables have the same relationships, even though the fields are not in the table. When I look at the General view the relationships are confirmed on that screen. Right now the BAQ is working, but I need to add a new table and when I do that I get an error saying I have "More that 1 root table". When I delete the relationships from one table, they get deleted from all table relationships. Any ideas on how the fix this?
9.04.507a
Mike
3
It sounds like the BAQ has gotten corrupt somehow. I've seen this happen a
few times. Try exporting and importing the BAQ or just copying the query.
If I recall, that has fixed them once or twice for me.

If that doesn't do it, you may be stuck rebuilding the query. Hopefully
with only five tables it shouldn't be too bad.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Sep 26, 2012 at 11:13 AM, mike.numbers <mnumbers@...> wrote:

> **
>
>
> I have a BAQ that has 5 tables. When I look at the table relations, all of
> the tables have the same relationships, even though the fields are not in
> the table. When I look at the General view the relationships are confirmed
> on that screen. Right now the BAQ is working, but I need to add a new table
> and when I do that I get an error saying I have "More that 1 root table".
> When I delete the relationships from one table, they get deleted from all
> table relationships. Any ideas on how the fix this?
> 9.04.507a
> Mike
>
>
>


[Non-text portions of this message have been removed]
4
I tried exporting and importing got the same relationships. Tried copying
got the same relationships. Tried to start a new BAQ and ended up with all
relationships being the same even though some of the fields were not in each
of the tables.
Sounds like a Epicor BAQ problem?

Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, September 26, 2012 11:28 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Table Relations Issue

It sounds like the BAQ has gotten corrupt somehow. I've seen this happen a
few times. Try exporting and importing the BAQ or just copying the query.
If I recall, that has fixed them once or twice for me.

If that doesn't do it, you may be stuck rebuilding the query. Hopefully with
only five tables it shouldn't be too bad.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Sep 26, 2012 at 11:13 AM, mike.numbers <mnumbers@...> wrote:

> **
>
>
> I have a BAQ that has 5 tables. When I look at the table relations,
> all of the tables have the same relationships, even though the fields
> are not in the table. When I look at the General view the
> relationships are confirmed on that screen. Right now the BAQ is
> working, but I need to add a new table and when I do that I get an error
saying I have "More that 1 root table".
> When I delete the relationships from one table, they get deleted from
> all table relationships. Any ideas on how the fix this?
> 9.04.507a
> Mike
>
>
>


[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
5
What tables are you trying to join? When dragging tables on the design tablet, it will try to make a join based on what it thinks from field names and other information. This join may not be a good one and you may need to tweak/correct. Also depending on the order you bring the tables in the direction of the joins may be off. Generally the arrows should point in one direction UP or Down the hierarchy of the tables.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "Mike Numbers" <mnumbers@...> wrote:
>
> I tried exporting and importing got the same relationships. Tried copying
> got the same relationships. Tried to start a new BAQ and ended up with all
> relationships being the same even though some of the fields were not in each
> of the tables.
> Sounds like a Epicor BAQ problem?
>
> Mike
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> John Driggers
> Sent: Wednesday, September 26, 2012 11:28 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BAQ Table Relations Issue
>
> It sounds like the BAQ has gotten corrupt somehow. I've seen this happen a
> few times. Try exporting and importing the BAQ or just copying the query.
> If I recall, that has fixed them once or twice for me.
>
> If that doesn't do it, you may be stuck rebuilding the query. Hopefully with
> only five tables it shouldn't be too bad.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Wed, Sep 26, 2012 at 11:13 AM, mike.numbers <mnumbers@...> wrote:
>
> > **
> >
> >
> > I have a BAQ that has 5 tables. When I look at the table relations,
> > all of the tables have the same relationships, even though the fields
> > are not in the table. When I look at the General view the
> > relationships are confirmed on that screen. Right now the BAQ is
> > working, but I need to add a new table and when I do that I get an error
> saying I have "More that 1 root table".
> > When I delete the relationships from one table, they get deleted from
> > all table relationships. Any ideas on how the fix this?
> > 9.04.507a
> > Mike
> >
> >
> >
>
>
> [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
>
6
Just to double check, you're clicking on the links themselves correct? Not
the table? If you click the table it won't update the relationship view and
you'll just keep seeing the same stuff.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Sep 26, 2012 at 12:38 PM, jckinneman <jckinneman@...> wrote:

> **
>
>
> What tables are you trying to join? When dragging tables on the design
> tablet, it will try to make a join based on what it thinks from field names
> and other information. This join may not be a good one and you may need to
> tweak/correct. Also depending on the order you bring the tables in the
> direction of the joins may be off. Generally the arrows should point in one
> direction UP or Down the hierarchy of the tables.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
>
> --- In vantage@yahoogroups.com, "Mike Numbers" <mnumbers@...> wrote:
> >
> > I tried exporting and importing got the same relationships. Tried copying
> > got the same relationships. Tried to start a new BAQ and ended up with
> all
> > relationships being the same even though some of the fields were not in
> each
> > of the tables.
> > Sounds like a Epicor BAQ problem?
> >
> > Mike
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > John Driggers
> > Sent: Wednesday, September 26, 2012 11:28 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] BAQ Table Relations Issue
> >
> > It sounds like the BAQ has gotten corrupt somehow. I've seen this happen
> a
> > few times. Try exporting and importing the BAQ or just copying the query.
> > If I recall, that has fixed them once or twice for me.
> >
> > If that doesn't do it, you may be stuck rebuilding the query. Hopefully
> with
> > only five tables it shouldn't be too bad.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
>
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> >
> >
> > On Wed, Sep 26, 2012 at 11:13 AM, mike.numbers <mnumbers@...> wrote:
> >
> > > **
> > >
> > >
> > > I have a BAQ that has 5 tables. When I look at the table relations,
> > > all of the tables have the same relationships, even though the fields
> > > are not in the table. When I look at the General view the
> > > relationships are confirmed on that screen. Right now the BAQ is
> > > working, but I need to add a new table and when I do that I get an
> error
> > saying I have "More that 1 root table".
> > > When I delete the relationships from one table, they get deleted from
> > > all table relationships. Any ideas on how the fix this?
> > > 9.04.507a
> > > Mike
> > >
> > >
> > >
> >
> >
> > [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]
7
Problem solved. My laptop died last week and my new one was loaded with a
"bad" version of Epicor. Reloaded Epicor904 and all is well.
Thank you everyone for your input.
Mike

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
John Driggers
Sent: Wednesday, September 26, 2012 1:28 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BAQ Table Relations Issue

Just to double check, you're clicking on the links themselves correct? Not
the table? If you click the table it won't update the relationship view and
you'll just keep seeing the same stuff.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Sep 26, 2012 at 12:38 PM, jckinneman <jckinneman@...> wrote:

> **
>
>
> What tables are you trying to join? When dragging tables on the design
> tablet, it will try to make a join based on what it thinks from field
> names and other information. This join may not be a good one and you
> may need to tweak/correct. Also depending on the order you bring the
> tables in the direction of the joins may be off. Generally the arrows
> should point in one direction UP or Down the hierarchy of the tables.
>
> Jim Kinneman
> Encompass Solutions, Inc
>
>
> --- In vantage@yahoogroups.com, "Mike Numbers" <mnumbers@...> wrote:
> >
> > I tried exporting and importing got the same relationships. Tried
> > copying got the same relationships. Tried to start a new BAQ and
> > ended up with
> all
> > relationships being the same even though some of the fields were not
> > in
> each
> > of the tables.
> > Sounds like a Epicor BAQ problem?
> >
> > Mike
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > John Driggers
> > Sent: Wednesday, September 26, 2012 11:28 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] BAQ Table Relations Issue
> >
> > It sounds like the BAQ has gotten corrupt somehow. I've seen this
> > happen
> a
> > few times. Try exporting and importing the BAQ or just copying the
query.
> > If I recall, that has fixed them once or twice for me.
> >
> > If that doesn't do it, you may be stuck rebuilding the query.
> > Hopefully
> with
> > only five tables it shouldn't be too bad.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog <http://usdoingstuff.com/>. How useful is
> > that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
>
> > :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> >
> >
> > On Wed, Sep 26, 2012 at 11:13 AM, mike.numbers <mnumbers@...> wrote:
> >
> > > **
> > >
> > >
> > > I have a BAQ that has 5 tables. When I look at the table
> > > relations, all of the tables have the same relationships, even
> > > though the fields are not in the table. When I look at the General
> > > view the relationships are confirmed on that screen. Right now the
> > > BAQ is working, but I need to add a new table and when I do that I
> > > get an
> error
> > saying I have "More that 1 root table".
> > > When I delete the relationships from one table, they get deleted
> > > from all table relationships. Any ideas on how the fix this?
> > > 9.04.507a
> > > Mike
> > >
> > >
> > >
> >
> >
> > [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]



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

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