[Anthill-pro] Current Activity
Ryan Smith
rws at urbancode.com
Thu Jan 24 12:19:01 CST 2008
The original query on the Current Activity page consumed a lot of CPU and memory when it ran. It has severely impacted performance in some cases.
Ryan
Yanko, Curtis wrote:
> Do you think this is related to the Oracle Performance issues I sent you
> guys a while back?
>
>
> ===
> -Curt
> W: 860.702.9059
> M: 860.881.2050
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Ryan Smith
> Sent: Thursday, January 24, 2008 12:46 PM
> To: AnthillPro user and support list.
> Cc: AnthillPro user and support list.
> Subject: Re: [Anthill-pro] Current Activity
>
> 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
> ===========================================================
> _______________________________________________
> Anthill-pro mailing list
> 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.
>
>
--
===========================================================
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
===========================================================
More information about the Anthill-pro
mailing list