[Anthill-pro] Current Activity tab
Ryan Smith
rws at urbancode.com
Fri Jan 25 08:47:32 CST 2008
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