Integrating Birt Reports

Anyone feel like helping out?

···

---------- Forwarded message ----------
From: Cintia Marisa cintia.banze@gmail.com

Date: Wed, Mar 4, 2009 at 7:39 AM
Subject: Integrating Birt Reports
To: larshelge@gmail.com

Hi, Larsh,
This is Cintia from the Mozambique team. I’m in charge of creating the reports for our database.

The thing is: i’ve already designed the reports in BIRT, but i’m having trouble when it comes to integrate the reports with DHIS.

When i try to add, a new report design, DHIS, can’t seem to find it…
Can you help me on that, please? Maybe i’m doing the steps wrong, if you could tell me the steps to do it, it would be helpfull.

Sorry, for my bad english.

Thanx in advance


Cintia Marisa

Hi Cintia,

Please start by having a look at this documentation at launchpad:
https://answers.launchpad.net/dhis2/+faqs

And have a look at the archive for this mailing list as it contains several references to BIRT:

http://n2.nabble.com/DHIS-developers-list-f1563109.html

The link below illustrates Nabble’s search functionality which can be quite useful when browsing mailing list archives. Here’s a search for “BIRT”.

http://n2.nabble.com/forum/Search.jtp?forum=1563109&local=y&query=BIRT

best regards,
Ola Hodne Titlestad
HISP

University of Oslo

···

On Sat, Mar 14, 2009 at 7:28 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Anyone feel like helping out?

---------- Forwarded message ----------
From: Cintia Marisa cintia.banze@gmail.com

Date: Wed, Mar 4, 2009 at 7:39 AM
Subject: Integrating Birt Reports
To: larshelge@gmail.com

Hi, Larsh,
This is Cintia from the Mozambique team. I’m in charge of creating the reports for our database.

The thing is: i’ve already designed the reports in BIRT, but i’m having trouble when it comes to integrate the reports with DHIS.

When i try to add, a new report design, DHIS, can’t seem to find it…
Can you help me on that, please? Maybe i’m doing the steps wrong, if you could tell me the steps to do it, it would be helpfull.

Sorry, for my bad english.

Thanx in advance


Cintia Marisa


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Ola Hodne Titlestad wrote:

Hi Cintia,

Please start by having a look at this documentation at launchpad:
https://answers.launchpad.net/dhis2/+faqs

And have a look at the archive for this mailing list as it contains
several
references to BIRT:
http://n2.nabble.com/DHIS-developers-list-f1563109.html

The link below illustrates Nabble's search functionality which can be
quite
useful when browsing mailing list archives. Here's a search for "BIRT".
http://n2.nabble.com/forum/Search.jtp?forum=1563109&local=y&query=BIRT

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

Anyone feel like helping out?

From: Cintia Marisa <cintia.banze@gmail.com>
Date: Wed, Mar 4, 2009 at 7:39 AM
Subject: Integrating Birt Reports
To: larshelge@gmail.com

Hi, Larsh,
This is Cintia from the Mozambique team. I'm in charge of creating the
reports for our database.

The thing is: i've already designed the reports in BIRT, but i'm having
trouble when it comes to integrate the reports with DHIS.
When i try to add, a new report design, DHIS, can't seem to find it...
Can you help me on that, please? Maybe i'm doing the steps wrong, if you
could tell me the steps to do it, it would be helpfull.

Sorry, for my bad english.

Thanx in advance

--
Cintia Marisa

_______________________________________________
Mailing list:
https://launchpad.net/~dhis2-devs<https://launchpad.net/~dhis2-devs>
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe :
https://launchpad.net/~dhis2-devs<https://launchpad.net/~dhis2-devs>
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Hi, i've looked at the articles and it helped a lot!
I was able to design the reports and link them to dhis database, however
when i tried to view them in dhis ( with the birt viewer) i got the
following error :
"no report object could be found".

To correct it, I did what Lars said in this post:
http://n2.nabble.com/BIRT-report-caveat-td2209565.html#a2209565

But now I'm getting this on TomCat:

HTTP Status 500 -

···

On Sat, Mar 14, 2009 at 7:28 AM, Lars Helge Øverland > <larshelge@gmail.com>wrote:

---------- Forwarded message ----------

________________________________________
type Exception report
message
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception
javax.servlet.ServletException: Error instantiating servlet class
org.eclipse.birt.report.servlet.ViewerServlet

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

  org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
  org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

  org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  java.lang.Thread.run(Unknown Source)
root cause
java.lang.NoClassDefFoundError: org.apache.commons.logging.LogFactory

  org.apache.axis.components.logger.LogFactory.class$(LogFactory.java:45)
  org.apache.axis.components.logger.LogFactory$1.run(LogFactory.java:45)
  java.security.AccessController.doPrivileged(Native Method)

org.apache.axis.components.logger.LogFactory.getLogFactory(LogFactory.java:41)

  org.apache.axis.components.logger.LogFactory.<clinit>(LogFactory.java:33)

org.apache.axis.transport.http.AxisServletBase.<clinit>(AxisServletBase.java:58)
  sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

  sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  java.lang.reflect.Constructor.newInstance(Unknown Source)
  java.lang.Class.newInstance0(Unknown Source)

  java.lang.Class.newInstance(Unknown Source)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
  org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  java.lang.Thread.run(Unknown Source)

and on DHIS this:

type Status report
message Servlet ViewerServlet is not available
description The requested resource (Servlet ViewerServlet is not available)
is not available.

Any Help?


View this message in context: http://n2.nabble.com/-Dhis2-devs--Fwd%3A-Integrating-Birt-Reports-tp2477222p2501486.html
Sent from the DHIS developers list mailing list archive at Nabble.com.

java.lang.NoClassDefFoundError: org.apache.commons.logging.LogFactory

and on DHIS this:

type Status report

message Servlet ViewerServlet is not available

description The requested resource (Servlet ViewerServlet is not available)

is not available.

Any Help?

Hi Cintia,

well done so far.

The problem is that the commons-logging library is missing (see log) and must be included, put this jar in birt-viewer/WEB-INF/lib

http://repo1.maven.org/maven2/commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar

You must probably also put the appropriate JDBC driver jar file in birt-viewer\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.1.v20080827\drivers

Postgres:

http://repo1.maven.org/maven2/postgresql/postgresql/8.3-603.jdbc4/postgresql-8.3-603.jdbc4.jar

Mysql:

http://repo2.maven.org/maven2/mysql/mysql-connector-java/5.1.6/mysql-connector-java-5.1.6.jar

regards Lars

Hi,

first try upgrading to the latest WAR file:

folk.uio.no/larshelg/files/dhis.war

Then check if there is any error messages in the log and if so post it to the list.

Lars

···

On Fri, Apr 3, 2009 at 6:13 AM, Cintia Marisa cintia.banze@gmail.com wrote:

Hey guys. First of all, thanx for all the help.

I’ve been, integrating the BIRT reports with DHIS, but now when i try to add new report tables on DHIS2 the tables appear in DHIS report tables, but not in the database. There for, i’m not abble to connect to the table in birt.

Ok. I had this
hibernate.hbm2ddl.auto = update
hibernate.hbm2ddl.auto = create/drop

I just removed the last and aparently things are going to happen as it should, and dhis2 contex on tomcat manager starts.

But when I try to login I get a new error:

···

==========================================================

[-]

Exception (org.apache.velocity.exception.MethodInvocationException): Invocation of method ‘hasAccess’ in class org.hisp.dhis.security.AcegiActionAccessResolver threw exception java.lang.IllegalArgumentException: Module doesn’t exist: ‘null’ @ /dhis-web-portal/redirect.vm[3,29]

  • org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:286)
  • org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203)
  • org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:396)
  • org.apache.velocity.runtime.parser.node.ASTAndNode.evaluate(ASTAndNode.java:111)
  • org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:64)
  • org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:86)
  • org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
  • org.apache.velocity.runtime.directive.Parse.render(Parse.java:224)
  • org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170)
  • org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74)
  • org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
  • org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:107)
  • org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
  • org.apache.velocity.Template.merge(Template.java:254)
  • com.opensymphony.webwork.dispatcher.VelocityResult.doExecute(VelocityResult.java:120)
  • com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143)
  • com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.webwork.interceptor.WebWorkSortOrderInterceptor.intercept(WebWorkSortOrderInterceptor.java:124)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.webwork.interceptor.WebWorkExceptionInterceptor.intercept(WebWorkExceptionInterceptor.java:89)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
  • com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
  • com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
  • org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  • org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.hisp.dhis.servlet.filter.OpenSessionInViewFilter.doFilter(OpenSessionInViewFilter.java:71)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  • org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  • org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  • org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  • org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  • org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
  • org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
  • org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  • org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  • java.lang.Thread.run(Unknown source)
[-]
    Caused by (java.lang.IllegalArgumentException): Module doesn't exist: 'null'
  • org.hisp.dhis.security.AcegiActionAccessResolver.hasAccess(AcegiActionAccessResolver.java:89)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)
  • org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245)
  • org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203)
  • org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:396)
  • org.apache.velocity.runtime.parser.node.ASTAndNode.evaluate(ASTAndNode.java:111)
  • org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:64)
  • org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:86)
  • org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
  • org.apache.velocity.runtime.directive.Parse.render(Parse.java:224)
  • org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170)
  • org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74)
  • org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
  • org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:107)
  • org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
  • org.apache.velocity.Template.merge(Template.java:254)
  • com.opensymphony.webwork.dispatcher.VelocityResult.doExecute(VelocityResult.java:120)
  • com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143)
  • com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.webwork.interceptor.WebWorkSortOrderInterceptor.intercept(WebWorkSortOrderInterceptor.java:124)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • org.hisp.dhis.webwork.interceptor.WebWorkExceptionInterceptor.intercept(WebWorkExceptionInterceptor.java:89)
  • com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
  • com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
  • com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
  • com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
  • org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  • org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.hisp.dhis.servlet.filter.OpenSessionInViewFilter.doFilter(OpenSessionInViewFilter.java:71)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  • org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  • org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  • org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  • org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  • org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
  • org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
  • org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  • org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  • java.lang.Thread.run(Unknown source)

==========================================================

Thanks in advance for your kindly help

2009/4/5 Lars Helge Øverland larshelge@gmail.com

2009/4/5 Cintia Marisa cintia.banze@gmail.com

Hi,

I donwloaded the new war. But i can’t get it to work. I got this in the logs:

  • INFO 19:08:27,640 Executing startup routine [1 of 11, runlevel 0]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [http-8080-1])

  • WARN 19:08:29,078 SQL Error: 1054, SQLState: 42S22 (JDBCExceptionReporter.java [http-8080-1])

  • ERROR 19:08:29,078 Unknown column ‘this_.url’ in ‘field list’ (JDBCExceptionReporter.java [http-8080-1])

  • INFO 19:08:37,687 System property dhis2.home not set (DefaultLocationManager.java [http-8080-1])

  • INFO 19:08:37,703 Environment variable DHIS2_HOME points to C:\DHIS (DefaultLocationManager.java [http-8080-1])

  • INFO 19:08:38,671 Hibernate properties file found: jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/webapps/dhis/WEB-INF/lib/dhis-support-hibernate-2.0.1-SNAPSHOT.jar!/hibernate-default.properties (DefaultHibernateConfigurationProvider.java [http-8080-1])

  • INFO 19:08:38,671 Hibernate properties file found: jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/webapps/dhis/WEB-INF/lib/dhis-web-maintenance-dataadmin.jar!/hibernate.properties (DefaultHibernateConfigurationProvider.java [http-8080-1])

  • INFO 19:08:38,671 Hibernate properties file found: C:\DHIS\hibernate.properties (DefaultHibernateConfigurationProvider.java [http-8080-1])

  • INFO 19:08:50,796 Executing startup routine [1 of 11, runlevel 0]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [http-8080-1])

  • WARN 19:08:52,187 SQL Error: 1054, SQLState: 42S22 (JDBCExceptionReporter.java [http-8080-1])

  • ERROR 19:08:52,187 Unknown column ‘this_.url’ in ‘field list’ (JDBCExceptionReporter.java [http-8080-1])

Make sure you include this line in hibernate.properties:

hibernate.hbm2ddl.auto = update


Cintia Marisa