[Anthill-pro] Current Activity tab
Pacileo, Kenneth
kenneth_pacileo at uhc.com
Tue Jan 29 11:32:05 CST 2008
Ryan, restarting the server fixed it. Thanks, Ken
-----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 11:23 AM
To: Pacileo, Kenneth
Cc: AnthillPro user and support list.
Subject: Re: [Anthill-pro] Current Activity tab
Did you restart the server? We only read the files up at start up.
Pacileo, Kenneth wrote:
> Yeah, that select statement was missing. I added it in but I still get
> the error.
>
> Seems odd that I was able to view and make changes to users yesterday
> without any problems with the ID. Only after we made a change to the
> com.urbancode.anthill3.dashboard.Dashboard.sql.xml file did I start
> having this problem. Seems unlikely that a change to the
> Dashboard.sql.xml file would cause this error but that was the only
> change we did to the server.
>
>
> -----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 10:51 AM
> To: Pacileo, Kenneth
> Cc: AnthillPro user and support list.
> Subject: Re: [Anthill-pro] Current Activity tab
>
> 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
===========================================================
_______________________________________________
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.
More information about the Anthill-pro
mailing list