removing saved queries

[cmcintos]

Hi we upgrade our test environment from 4.0 to 5.5 finally and found several saved queries are now broken. We want to remove them completely but can't through the UI due to getting null pointer exception.

I am wanting to SQL delete out the problem saved queries but am missing the core tables. Can anyone direct me at finding them?
I know about these.
SAVED_QUERY,
SAVED_QUERY_VALUES,
SAVED_QUERY_SORT

[james_foran]

Re: removing saved queries

When we upgraded from 4.0 to 5.0, we had a lot of issues with Saved Queries. They were no longer working as expected in Business Monitors, and not appearing in Screen Sets as we were expecting.

I found that it was an issue with the QUERY_NAME. They were changed as part of the upgrade. We had to revert to old Query names (glog.webserver.finder.models.ShipmentBuyFinderMode l changed to glog.server.query.shipment.BuyShipmentQuery
)...

Dont know if this is causing your issue, but I thought it might help with your investigation.

Cheers,

James Foran
Toll Solutions

[neoandr]

Re: removing saved queries

Hi we upgrade our test environment from 4.0 to 5.5 finally and found several saved queries are now broken. We want to remove them completely but can't through the UI due to getting null pointer exception.

I am wanting to SQL delete out the problem saved queries but am missing the core tables. Can anyone direct me at finding them?
I know about these.
SAVED_QUERY,
SAVED_QUERY_VALUES,
SAVED_QUERY_SORT

I generally use a query to find out the constraints related to the main table. For eg. Saved Query is the main table then execute following query

select * from user_constraints where table_name like '%SAVED%'

then i will look into constraint_type 'R' means - refers another table's column.. So you can track these constraints and find out those tables (child tables) that are referring to it which makes your deletion simpler.. Even it gives you more knowledge about hw the tables are being linked apart from functional knowledge.

[cmcintos]

Re: removing saved queries

Thanks.

These are saved queries I just want to delete but can't through the UI. I've been going the sql delete route and the tip on the contraints is helpful.

[james_foran]

Re: removing saved queries

For sure. My response was more into why the saved queries are not working, not how to delete them.

Best of luck