Announcement

Collapse
No announcement yet.

removing saved queries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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
    James Foran
    Toll Global Information Services
    http://www.tollgroup.com

    Comment


    • #3
      Re: removing saved queries

      Originally posted by cmcintos View Post
      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.
      Cheers,
      -Neo

      Comment


      • #4
        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.

        Comment


        • #5
          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
          James Foran
          Toll Global Information Services
          http://www.tollgroup.com

          Comment

          Working...
          X
          😀
          🥰
          🤢
          😎
          😡
          👍
          👎