How do I delete a corrupt BAQ?

Yahoo Archive
1
Thank you. That was the piece of information that I was missing.
Â
Steven G.


________________________________
From: snielsen28 <snielsen.hipco@...>
To: vantage@yahoogroups.com
Sent: Wednesday, April 10, 2013 9:10 AM
Subject: [Vantage] Re: How do I delete a corrupt BAQ?

Â
I was able to delete a corrupt BAQ a few years ago using a BPM, I found something in the group that helped. I believe the main table is Exports, it's not grouped in with the other BAQ tables that start with Query.

Sue

--- In mailto:vantage%40yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> The problem is that I can't even open the corrupt BAQs to delete them. I think I will have to delete them at the table level, but I can't figure out where the header information is stored.
>
>
>
> ________________________________
> From: brucewbrannan <bruce.brannan@...>
> To: mailto:vantage%40yahoogroups.com
> Sent: Tuesday, April 9, 2013 4:26 PM
> Subject: [Vantage] Re: How do I delete a corrupt BAQ?
>
> ÂÂ
> If I recall there are two ways. If you wait "forever" (well maybe an hour or two) the BAQ will eventually time out and then you can delete it. Otherwise, I've restarted the appservers/db to delete them.
>
> --- In mailto:vantage%40yahoogroups.com, "Steven" <sgotschall@> wrote:
> >
> > We are on Vantage 8.03.408a Progress.
> >
> > I have a couple of BAQs that show up in the BAQ search screen, but if I try and open them, I get nothing. If I try and create a new on with the same name it says that it already exists. I've look at all the tables that start with "Query", and the data for the BAQ is there.
> >
> > I don't see a table anywhere that is the parent of the "Query" tables. Anybody know which table holds the header information for BAQs? Anyone know how to fix a corrupt BAQ?
> >
> > Steven G.
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
2
We are on Vantage 8.03.408a Progress.

I have a couple of BAQs that show up in the BAQ search screen, but if I try and open them, I get nothing. If I try and create a new on with the same name it says that it already exists. I've look at all the tables that start with "Query", and the data for the BAQ is there.

I don't see a table anywhere that is the parent of the "Query" tables. Anybody know which table holds the header information for BAQs? Anyone know how to fix a corrupt BAQ?

Steven G.
3
If I recall there are two ways. If you wait "forever" (well maybe an hour or two) the BAQ will eventually time out and then you can delete it. Otherwise, I've restarted the appservers/db to delete them.

--- In vantage@yahoogroups.com, "Steven" <sgotschall@...> wrote:
>
> We are on Vantage 8.03.408a Progress.
>
> I have a couple of BAQs that show up in the BAQ search screen, but if I try and open them, I get nothing. If I try and create a new on with the same name it says that it already exists. I've look at all the tables that start with "Query", and the data for the BAQ is there.
>
> I don't see a table anywhere that is the parent of the "Query" tables. Anybody know which table holds the header information for BAQs? Anyone know how to fix a corrupt BAQ?
>
> Steven G.
>
4
The problem is that I can't even open the corrupt BAQs to delete them. I think I will have to delete them at the table level, but I can't figure out where the header information is stored.



________________________________
From: brucewbrannan <bruce.brannan@...>
To: vantage@yahoogroups.com
Sent: Tuesday, April 9, 2013 4:26 PM
Subject: [Vantage] Re: How do I delete a corrupt BAQ?

Â
If I recall there are two ways. If you wait "forever" (well maybe an hour or two) the BAQ will eventually time out and then you can delete it. Otherwise, I've restarted the appservers/db to delete them.

--- In mailto:vantage%40yahoogroups.com, "Steven" <sgotschall@...> wrote:
>
> We are on Vantage 8.03.408a Progress.
>
> I have a couple of BAQs that show up in the BAQ search screen, but if I try and open them, I get nothing. If I try and create a new on with the same name it says that it already exists. I've look at all the tables that start with "Query", and the data for the BAQ is there.
>
> I don't see a table anywhere that is the parent of the "Query" tables. Anybody know which table holds the header information for BAQs? Anyone know how to fix a corrupt BAQ?
>
> Steven G.
>




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



I did cross over a data base conversion utility 9780 when going to run another utility that is listed as fixes bad BAQ ID’s. Maybe you could run this in a training data base and see if it fixes the problem.



Steve



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Wednesday, April 10, 2013 7:15 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: How do I delete a corrupt BAQ?





The problem is that I can't even open the corrupt BAQs to delete them. I think I will have to delete them at the table level, but I can't figure out where the header information is stored.

________________________________
From: brucewbrannan <bruce.brannan@... <mailto:bruce.brannan%40wgint.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, April 9, 2013 4:26 PM
Subject: [Vantage] Re: How do I delete a corrupt BAQ?


If I recall there are two ways. If you wait "forever" (well maybe an hour or two) the BAQ will eventually time out and then you can delete it. Otherwise, I've restarted the appservers/db to delete them.

--- In mailto:vantage%40yahoogroups.com, "Steven" <sgotschall@...> wrote:
>
> We are on Vantage 8.03.408a Progress.
>
> I have a couple of BAQs that show up in the BAQ search screen, but if I try and open them, I get nothing. If I try and create a new on with the same name it says that it already exists. I've look at all the tables that start with "Query", and the data for the BAQ is there.
>
> I don't see a table anywhere that is the parent of the "Query" tables. Anybody know which table holds the header information for BAQs? Anyone know how to fix a corrupt BAQ?
>
> Steven G.
>

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





[Non-text portions of this message have been removed]
6
I was able to delete a corrupt BAQ a few years ago using a BPM, I found something in the group that helped. I believe the main table is Exports, it's not grouped in with the other BAQ tables that start with Query.

Sue

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> The problem is that I can't even open the corrupt BAQs to delete them. I think I will have to delete them at the table level, but I can't figure out where the header information is stored.
>
>
>
> ________________________________
> From: brucewbrannan <bruce.brannan@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, April 9, 2013 4:26 PM
> Subject: [Vantage] Re: How do I delete a corrupt BAQ?
>
> ÂÂ
> If I recall there are two ways. If you wait "forever" (well maybe an hour or two) the BAQ will eventually time out and then you can delete it. Otherwise, I've restarted the appservers/db to delete them.
>
> --- In mailto:vantage%40yahoogroups.com, "Steven" <sgotschall@> wrote:
> >
> > We are on Vantage 8.03.408a Progress.
> >
> > I have a couple of BAQs that show up in the BAQ search screen, but if I try and open them, I get nothing. If I try and create a new on with the same name it says that it already exists. I've look at all the tables that start with "Query", and the data for the BAQ is there.
> >
> > I don't see a table anywhere that is the parent of the "Query" tables. Anybody know which table holds the header information for BAQs? Anyone know how to fix a corrupt BAQ?
> >
> > Steven G.
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>