1 Reply Latest reply: Nov 30, 2010 8:22 AM by Robert Ponder RSS

    Query Option timing out - Activities View

    saira b.
      On All Activities View, when we query for activities with a specific status and Group, the query seems to be timing out and error message of server is busy appears. This does not happen for all Status and Group and only when queried for specific value of status and group field. Any ideas????

        • 1. Re: Query Option timing out - Activities View
          Robert Ponder
          If you are getting server busy this normally means the OM has crashed. You should check for a crash.txt and fdr file.

          If you are using Oracle DBMS the long running query should just run a long time. If you enabled cancel query the cancel query button should show up.

          Anyway – you should be able to tune the query by getting the SQL and taking it into a tuning session.

          If you are using Oracle DBMS please be sure to use the PPS recommended init.ora parameters and statistics strategy.

          Robert Ponder
          Lead Architect and Director
          Ponder Pro Serve
          cell: 770.490.2767
          fax: 770.412.8259
          email: rponder@ponderproserve.com
          web: www.ponderproserve.com