2 Replies Latest reply on May 8, 2012 4:14 AM by W M

    Tracing back the workflow triggering a specific database query

      Share This:

      Hi,

       

      the oracle dba gave me a list of the queries taking up the must database time.

      Most of the queries are easy to find back.

       

      However some of them or not, and I would like to find the trigger of this query, as it does a non-indexed search.

      I already used a documentation tool (ARSmarts) to look into all AL's, Filters, etc to see if any such query is launched from there, but I do not find it back.

       

      Could you help on how to trace back the workflow triggering the following db queries:

      SELECTT169.C1 FROM T169 WHERE (T169.C112 IS NULL) ORDER BY :"SYS_B_0" ASC

      info: T169 = AP:Detail, C112=Assignee Group Permissions

       

      Thanks in advance.

       

      Werner

        • 1. Tracing back the workflow triggering a specific database query
          Misi Mladoniczky

          Hi,

           

          Your best option might be to turn on API+ESCL+FLTR+SQL logging to see what happens on your system.

           

          I found a bunch of approval escalations that might be you problem...

           

                  Best Regards - Misi, RRR AB, http://rrr.se

           

           

          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Notification
          SELECT T203.C1 FROM T203 WHERE (T203.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Alternate
          SELECT T193.C1 FROM T193 WHERE (T193.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Detail
          SELECT T205.C1 FROM T205 WHERE (T205.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Form
          SELECT T192.C1 FROM T192 WHERE (T192.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:More Information
          SELECT T196.C1 FROM T196 WHERE (T196.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:PreviewSignatures
          SELECT T202.C1 FROM T202 WHERE (T202.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Process Administrator
          SELECT T198.C1 FROM T198 WHERE (T198.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Process Definition
          SELECT T197.C1 FROM T197 WHERE (T197.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Reserved Word
          SELECT T195.C1 FROM T195 WHERE (T195.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Role
          SELECT T199.C1 FROM T199 WHERE (T199.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Rule Definition
          SELECT T200.C1 FROM T200 WHERE (T200.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Scratch Pad
          SELECT T201.C1 FROM T201 WHERE (T201.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          Checking AP:Common-Set-AssigneeGroup (enabled) : ready to fire now on AP:Signature
          SELECT T206.C1 FROM T206 WHERE (T206.C112 IS NULL) ORDER BY 1 ASC
          OK
          --> Failed qualification
          AP:Common-Set-AssigneeGroup completed
          • 2. Tracing back the workflow triggering a specific database query

            Hi,

             

            Thanks for the quick feedback.

            Indeed, the AP:Common-Set-AssigneeGroup escalation was the one I was looking for in this case.

            It also pointed out I did not use my documentation tool correctly, I could have perfectly found the workflow in their if I had...

             

            Thx again.

             

            Best Regards,

            Werner