[Anthill-pro] Current Activity tab
Ryan Smith
rws at urbancode.com
Fri Jan 25 09:51:01 CST 2008
Sry, that method can also use this on in the same file:
<sql-statement name="RESTORE_ALL_ACTIVE_FOR_USER">
SELECT
${ROLE_COLUMNS}
FROM
SEC_ROLE RL
JOIN SEC_USER_ROLE UR ON UR.ROLE_ID = RL.ID
WHERE
UR.USER_ID = ?
AND INACTIVE = 0
AND IS_USER_ROLE = 0
ORDER BY
UPPER_NAME
</sql-statement>
Pacileo, Kenneth wrote:
> Ryan,
>
> That query is in the file:
>
> ...
> </sql-statement>
> <sql-statement name="RESTORE_ALL_ACTIVE">
> SELECT
> ${ROLE_COLUMNS}
> FROM
> SEC_ROLE RL
> WHERE
> INACTIVE = 0
> AND IS_USER_ROLE = 0
> ORDER BY
> UPPER_NAME
> </sql-statement>
> <sql-statement name="RESTORE_ALL_INACTIVE">
> SELECT
> ...
>
> Anything else I can check?
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Ryan Smith
> Sent: Friday, January 25, 2008 9:48 AM
> To: Yanko, Curtis
> Cc: AnthillPro user and support list.
> Subject: Re: [Anthill-pro] Current Activity tab
>
> The error is saying that it can not find a SQL statement in a XML file
> in the conf/sql directory. In the
> com.urbancode.anthill3.domain.security.Role.sql.xml file, there should
> be a SQL statement for "RESTORE_ALL_ACTIVE" and it should be:
>
>
> <sql-statement name="RESTORE_ALL_ACTIVE">
> SELECT
> ${ROLE_COLUMNS}
> FROM
> SEC_ROLE RL
> WHERE
> INACTIVE = 0
> AND IS_USER_ROLE = 0
> ORDER BY
> UPPER_NAME
> </sql-statement>
>
>
> Ryan
>
> Yanko, Curtis wrote:
>> The query certainly seemed limited to the Current Activity Tab so I
>> doubt there is a connection in this case.
>>
>>
>> ===
>> -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 Pacileo,
>> Kenneth
>> Sent: Thursday, January 24, 2008 4:10 PM
>> To: rws at urbancode.com; AnthillPro user and support list.
>> Subject: RE: [Anthill-pro] Current Activity tab
>>
>> Ryan,
>>
>> This morning I was able to manage users in the System -> Security -
>> Users tab function using a secondary admin account we set up. Since
>> making the SQL changes for the Activity tab, I now receive a "
>> PersistenceException: Error restoring object from database" error when
>> using that id. I can still manage users with the default admin
> account.
>> Near the bottom of the stack trace is a java.sql.SQLException "Caused
>> by: java.sql.SQLException: SQL statement to execute cannot be empty or
>> null"
>>
>> What query in the database is this and can I verify what it should be?
>>
>> Ken
>>
>> Here's the full stack trace ...
>> com.urbancode.anthill3.domain.persistent.PersistenceException: Error
>> restoring object from database
>> at
>>
> com.urbancode.anthill3.domain.persistent.Dao.executeDelegate(Dao.java:10
>> 0)
>> at
>>
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.executeDelegate0(Un
>> itOfWorkDefault.java:346)
>> at
>>
> com.urbancode.anthill3.persistence.UnitOfWork.executeDelegate(UnitOfWork
>> .java:853)
>> at
>>
> com.urbancode.anthill3.domain.security.RoleFactory.restoreAllActive(Role
>> Factory.java:126)
>> at
>>
> com.urbancode.anthill3.web.admin.security.SecurityAdminTasks.viewUser(Se
>> curityAdminTasks.java:538)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
>> a:39)
>> at
>>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
>> Impl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:324)
>> at
>>
> com.urbancode.anthill3.web.controller.ControllerServlet.doPost(Controlle
>> rServlet.java:313)
>> at
>>
> com.urbancode.anthill3.web.controller.ControllerServlet.doGet(Controller
>> Servlet.java:160)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>> tionFilterChain.java:269)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.jav
>> a:78)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>> tionFilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter.j
>> ava:89)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>> tionFilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.AuthorityFilter.doFilter(AuthorityFilter
>> .java:67)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>> tionFilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.security.DisableSessionUrlFilter.doFilter(Dis
>> ableSessionUrlFilter.java:114)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>> tionFilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>> erChain.java:188)
>> at
>>
> com.urbancode.anthill3.web.security.SecureSessionFilter.doFilter(SecureS
>> essionFilter.java:114)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
>> tionFilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
>> erChain.java:188)
>> at
>>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
>> e.java:213)
>> at
>>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
>> e.java:174)
>> at
>>
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
>> :127)
>> at
>>
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
>> :117)
>> at
>>
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
>> java:108)
>> at
>>
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
>> 51)
>> at
>>
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87
>> 4)
>> at
>>
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
>> essConnection(Http11BaseProtocol.java:665)
>> at
>>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
>> .java:528)
>> at
>>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
>> erWorkerThread.java:81)
>> at
>>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
>> .java:689)
>> at java.lang.Thread.run(Thread.java:534)
>> Caused by:
>> com.urbancode.anthill3.domain.persistent.PersistenceException: Error
>> restoring object from database
>> at
>>
> com.urbancode.anthill3.domain.security.RoleDaoSql.restoreAllActive(RoleD
>> aoSql.java:219)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
>> a:39)
>> at
>>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
>> Impl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:324)
>> at
>>
> com.urbancode.anthill3.domain.persistent.Dao.executeDelegate(Dao.java:90
>> )
>> ... 41 more
>> Caused by: java.sql.SQLException: SQL statement to execute cannot be
>> empty or null
>> at
>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
>> 2)
>> at
>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:14
>> 6)
>> at
>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:20
>> 8)
>> at
>>
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnectio
>> n.java:846)
>> at
>>
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnectio
>> n.java:768)
>> at
>>
> com.p6spy.engine.spy.P6Connection.prepareStatement(P6Connection.java:169
>> )
>> at
>>
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(Delegating
>> Connection.java:185)
>> at
>>
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.pre
>> pareStatement(PoolingDataSource.java:278)
>> at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
>> at
>>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
>> Impl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:324)
>> at
>>
> org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$Tran
> sactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.jav
>> a:167)
>> at $Proxy0.prepareStatement(Unknown Source)
>> at
>>
> com.urbancode.anthill3.domain.security.RoleDaoSql.restoreAllActive(RoleD
>> aoSql.java:209)
>> ... 46 more
>>
>> -----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 1:54 PM
>> To: Yanko, Curtis
>> Cc: AnthillPro user and support list.
>> Subject: Re: [Anthill-pro] Current Activity tab
>>
>> It should just be th ACTIVE_BUILD_LIFE_ACTIVITY_SUMMARY.
>>
>>
>> Yanko, Curtis wrote:
>>> There are multiple entries that come upwhen I search on
>>> BUILD_LIFE_ACTIVITY_SUMMARY, which one do I want?
>>>
>>> ACTIVE_BUILD_LIFE_ACTIVITY_SUMMARY or
>>>
>>> RUNNING_BUILD_LIFE_ACTIVITY_SUMMARY
>>>
>>>
>>> ===
>>> -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:45 PM
>>> To: AnthillPro user and support list.
>>> Subject: Re: [Anthill-pro] Current Activity tab
>>>
>>> Uldis,
>>>
>>> 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
>>>
>>> Steve Boone wrote:
>>>> Uldis,
>>>>
>>>> There seems to be an issue with one of the SQL queries we are
> running
>>>> in Oracle, we are trying to come up with a workaround for the issue.
>>>>
>>>> Regards,
>>>> Steve Boone
>>>>
>>>> On 1/14/08, *Uldis Karlovs-Karlovskis* <uldisk at ctco.lv
>>>> <mailto:uldisk at ctco.lv>> wrote:
>>>>
>>>> Hello!
>>>>
>>>>
>>>>
>>>> Does Current Activity tab still should don`t work or Oracle? I`m
>>> on
>>>> 3.4.7 but it is still hunging up :(
>>>>
>>>>
>>>>
>>>> //Uldis Karlovs - Karlovskis//
>>>>
>>>> //Build System and Deployment Administrator//
>>>>
>>>> //System Configuration Management//
>>>>
>>>> //C.T.Co <http://C.T.Co>//
>>>>
>>>> //Mobile////: +371 29 345 210//
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>>
>>>>
>>>>
>> ----------------------------------------------------------------------
>>>> --
>>>>
>>>> _______________________________________________
>>>> 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
>> ===========================================================
>> _______________________________________________
>> 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.
>>
>> _______________________________________________
>> 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