[Anthill-pro] Current Activity

[Ryan Smith]

Curtis,

I think we actually found a bug in Oracle that creates a unnecessary Cartesian product when joining tables. We have found a way around it though.

You will need to replace a SQL statement in the com.urbancode.anthill3.dashboard.Dashboard.sql.xml file in the server's conf/sql directory. Search for 'BUILD_LIFE_ACTIVITY_SUMMARY' and replace the SQL statement with:


      SELECT DISTINCT
          WC.BUILD_LIFE_ID,
          P.ID AS PROJECT_ID,
          P.NAME AS PROJECT_NAME,
          WC.ID AS CASE_ID,
          WC.WORKFLOW_ID,
          W.NAME AS WORKFLOW_NAME,
          WC.STATUS AS STATUS,
          WC.START_DATE,
          UR.USER_ID AS HAS_PERMISSION
      FROM
          WORKFLOW_CASE WC
              JOIN WORKFLOW W ON WC.WORKFLOW_ID = W.ID
              JOIN PROJECT P ON W.PROJECT_ID = P.ID
              LEFT OUTER JOIN SEC_RESOURCE SR ON SR.HANDLE_ID = W.ID
                AND SR.RESOURCE_TYPE_ID = 4
              LEFT OUTER JOIN SEC_PERMISSION SP ON SP.RESOURCE_ID = SR.ID
               AND SP.RESOURCE_ACTION = 'execute'
              LEFT OUTER JOIN SEC_USER_ROLE UR ON SP.ROLE_ID = UR.ROLE_ID
               AND UR.USER_ID = ?
      WHERE
          WC.WORKFLOW_ID = W.ID AND
          W.PROJECT_ID = P.ID AND
          WC.STATUS IN ('Running', 'Suspended', 'Waiting on Agents', 'Queued', 'Aborting' )
      ORDER BY WC.START_DATE DESC, WC.BUILD_LIFE_ID, HAS_PERMISSION




Save the file and restart the server.


Ryan


Yanko, Curtis wrote:
> Was any of this addressed in 3.3.4? I'm still on 3.3.3
>  
> ===
> -Curt
> W: 860.702.9059
> M: 860.881.2050
>  
> 
> ------------------------------------------------------------------------
> *From:* anthill-pro-bounces at caladin.urbancode.com 
> [mailto:anthill-pro-bounces at caladin.urbancode.com] *On Behalf Of *Steve 
> Boone
> *Sent:* Tuesday, October 16, 2007 11:47 AM
> *To:* AnthillPro user and support list.
> *Cc:* AnthillPro user and support list.
> *Subject:* Re: [Anthill-pro] Current Activity
> 
> Curtis,
> 
> We have not had any issues that others have informed us of.  I regularly 
> use the Current Activities Tab on my own instance of AnthillPro and have 
> not had any issues.  What problems are you experiencing?  Is the UI just 
> hanging?  Or does it not seem to actually display when a job is running?
> 
> Regards,
> Steve Boone
> 
> On 10/16/07, *Yanko, Curtis* <curt_yanko at uhc.com 
> <mailto:curt_yanko at uhc.com>> wrote:
> 
>     Is it just me or does Current Activity never load if there is
>     actually activity?
>      
>     ===
>     -Curt
>     W: 860.702.9059
>     M: 860.881.2050
> 
> 
>     This e-mail, including attachments, may include confidential and/or
>     proprietary information, and may be used only by the person or
>     entity to
>     which it is addressed. If the reader of this e-mail is not the intended
>     recipient or his or her authorized agent, the reader is hereby notified
>     that any dissemination, distribution or copying of this e-mail is
>     prohibited. If you have received this e-mail in error, please notify
>     the
>     sender by replying to this message and delete this e-mail immediately.
> 
>     _______________________________________________
>     Anthill-pro mailing list
>     Anthill-pro at lists.urbancode.com
>     <mailto:Anthill-pro at lists.urbancode.com>
>     http://lists.urbancode.com/mailman/listinfo/anthill-pro
> 
> 
> 
> 
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity to
> which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro

-- 
===========================================================
Ryan Smith.           		2044 Euclid Ave., Suite 600
Lead Developer                  Cleveland, Ohio 44115
Urbancode, Inc.
                                email:  rws at urbancode.com
web:     www.urbancode.com      phone:  216-858-9000
web:     www.anthillpro.com     fax:    216-858-9602
===========================================================