← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 702830] [NEW] excelreporting-import-error

 

And a JavaScript error message..

Error: mismatched tag. Expected: </input>.
Source File: http://localhost:8888/dhis-web-excel-reporting/getImportingParams.action
Line: 62, Column: 70
Source Code:
<p><input type="button" value="Go back" onclick="history.go( -1 )"></p>


On Fri, Jan 14, 2011 at 1:47 PM, Jason Pickering
<jason.p.pickering@xxxxxxxxx> wrote:
> Here is the log trace
>
>
> * ERROR 13:45:22,146 Error while executing action (ExceptionInterceptor.java [31
> 379033@qtp-14642381-10])
> java.lang.NumberFormatException: For input string: ""
>        at java.lang.NumberFormatException.forInputString(NumberFormatException.
> java:48)
>        at java.lang.Integer.parseInt(Integer.java:470)
>        at java.lang.Integer.parseInt(Integer.java:499)
>        at org.hisp.dhis.dataelement.DataElementOperand.getOperand(DataElementOp
> erand.java:289)
>        at org.hisp.dhis.expression.DefaultExpressionService.getOperandsInExpres
> sion(DefaultExpressionService.java:234)
>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:39)
>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:25)
>        at java.lang.reflect.Method.invoke(Method.java:597)
>        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
> on(AopUtils.java:309)
>        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
> inpoint(ReflectiveMethodInvocation.java:183)
>        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:150)
>        at org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:110)
>        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
> e(ExposeInvocationInterceptor.java:89)
>        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:172)
>        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:202)
>        at $Proxy21.getOperandsInExpression(Unknown Source)
>        at org.hisp.dhis.reportexcel.importing.action.ImportDataNormalExcelGroup
> Action.execute(ImportDataNormalExcelGroupAction.java:202)
>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:39)
>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:25)
>        at java.lang.reflect.Method.invoke(Method.java:597)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
> ctionInvocation.java:441)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
> ultActionInvocation.java:280)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:243)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
> ept(XWorkPortalUserInterceptor.java:82)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
> rcept(XWorkPortalModuleInterceptor.java:85)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
> ept(XWorkPortalMenuInterceptor.java:91)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
> rcept(XWorkPortalParamsInterceptor.java:117)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
> ptor.java:70)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor
> .java:107)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe
> ttingInterceptor.java:102)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(Dat
> aDictionaryModeInterceptor.java:109)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(Displa
> yPropertyInterceptor.java:90)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInt
> erceptor.java:124)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X
> WorkSecurityInterceptor.java:98)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j
> ava:141)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(Cha
> iningInterceptor.java:126)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
> (ParametersInterceptor.java:195)
>        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
> (MethodFilterInterceptor.java:87)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
> cept(StaticParametersInterceptor.java:179)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
> erceptor.java:90)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
> ava:52)
>        at com.opensymphony.xwork2.ActionChainResult.execute(ActionChainResult.j
> ava:222)
>        at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(Default
> ActionInvocation.java:362)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:266)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
> ept(XWorkPortalUserInterceptor.java:82)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
> rcept(XWorkPortalModuleInterceptor.java:85)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
> ept(XWorkPortalMenuInterceptor.java:91)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
> rcept(XWorkPortalParamsInterceptor.java:117)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
> ptor.java:70)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor
> .java:107)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe
> ttingInterceptor.java:102)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(Dat
> aDictionaryModeInterceptor.java:109)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(Displa
> yPropertyInterceptor.java:90)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInt
> erceptor.java:124)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X
> WorkSecurityInterceptor.java:98)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j
> ava:141)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(Cha
> iningInterceptor.java:126)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
> (ParametersInterceptor.java:195)
>        at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
> (MethodFilterInterceptor.java:87)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
> cept(StaticParametersInterceptor.java:179)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
> erceptor.java:90)
>        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:237)
>        at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
> ava:52)
>        at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav
> a:488)
>        at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatc
> her.java:395)
>        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
> Handler.java:1139)
>        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
> doFilter(FilterChainProxy.java:368)
>        at org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLo
> ginFilter.java:129)
>        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
> doFilter(FilterChainProxy.java:380)
>        at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(Automati
> cAccessFilter.java:112)
>        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
> doFilter(FilterChainProxy.java:380)
>        at org.springframework.security.web.authentication.logout.LogoutFilter.d
> oFilter(LogoutFilter.java:105)
>        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
> doFilter(FilterChainProxy.java:380)
>        at org.springframework.security.web.authentication.AbstractAuthenticatio
> nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
>        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
> doFilter(FilterChainProxy.java:380)
>        at org.springframework.security.web.context.SecurityContextPersistenceFi
> lter.doFilter(SecurityContextPersistenceFilter.java:79)
>        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
> doFilter(FilterChainProxy.java:380)
>        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChai
> nProxy.java:169)
>        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
> elegatingFilterProxy.java:237)
>        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
> ingFilterProxy.java:167)
>        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
> Handler.java:1139)
>        at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.do
> FilterInternal(OpenSessionInViewFilter.java:198)
>        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
> equestFilter.java:76)
>        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
> Handler.java:1139)
>        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
> 78)
>        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
> a:216)
>        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
> 81)
>        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
> 65)
>        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
>
>        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
> 52)
>        at org.mortbay.jetty.Server.handle(Server.java:324)
>        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:53
> 5)
>        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
> n.java:880)
>        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
>        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
>        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
>        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja
> va:409)
>        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.j
> ava:520)
>
>
> On Fri, Jan 14, 2011 at 12:44 PM, jason.p.pickering
> <702830@xxxxxxxxxxxxxxxxxx> wrote:
>> Public bug reported:
>>
>>
>> After uploading a file, selecting the Excel items to import, the following error is displayed through the UI.
>> Upload Success
>> 350.450858217213IRS_template_test_import.xls
>> XML Parsing Error: mismatched tag. Expected: . Location: http://localhost:8888/dhis-web-excel-reporting/getImportingParams.action Line Number 62, Column 70:
>>
>>
>>    *
>>
>> About DHIS 2
>>
>> Current user:
>>    admin
>> Version:
>>    2.0.6-SNAPSHOT
>> Build revision:
>>    2562
>> Build date:
>>    2011-01-14 10:24
>> User agent:
>>    Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13
>> External configuration directory:
>>    C:\Program Files\DHIS2-2.0.5\conf
>> Environment variable:
>>    DHIS2_HOME
>> Database type:
>>    PostgreSQL
>> Database name:
>>    harvard2
>> Database user:
>>    postgres
>> Java Opts:
>> Java version:
>>    1.6.0_22
>> Java vendor:
>>    Sun Microsystems Inc.
>> OS name:
>>    Windows 7
>> OS architecture:
>>    x86
>> OS version:
>>    6.1
>>
>> ** Affects: dhis2
>>     Importance: Undecided
>>         Status: New
>>
>> --
>> You received this bug notification because you are a direct subscriber
>> of the bug.
>> https://bugs.launchpad.net/bugs/702830
>>
>> Title:
>>  excelreporting-import-error
>>
>> Status in DHIS 2 - District Health Information Software:
>>  New
>>
>> Bug description:
>>
>>  After uploading a file, selecting the Excel items to import, the following error is displayed through the UI.
>>  Upload Success
>>  350.450858217213IRS_template_test_import.xls
>>  XML Parsing Error: mismatched tag. Expected: . Location: http://localhost:8888/dhis-web-excel-reporting/getImportingParams.action Line Number 62, Column 70:
>>
>>
>>      *
>>
>>  About DHIS 2
>>
>>  Current user:
>>      admin
>>  Version:
>>      2.0.6-SNAPSHOT
>>  Build revision:
>>      2562
>>  Build date:
>>      2011-01-14 10:24
>>  User agent:
>>      Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13
>>  External configuration directory:
>>      C:\Program Files\DHIS2-2.0.5\conf
>>  Environment variable:
>>      DHIS2_HOME
>>  Database type:
>>      PostgreSQL
>>  Database name:
>>      harvard2
>>  Database user:
>>      postgres
>>  Java Opts:
>>  Java version:
>>      1.6.0_22
>>  Java vendor:
>>      Sun Microsystems Inc.
>>  OS name:
>>      Windows 7
>>  OS architecture:
>>      x86
>>  OS version:
>>      6.1
>>
>> To unsubscribe from this bug, go to:
>> https://bugs.launchpad.net/dhis2/+bug/702830/+subscribe
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260968395190

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/702830

Title:
  excelreporting-import-error

Status in DHIS 2 - District Health Information Software:
  New

Bug description:

  After uploading a file, selecting the Excel items to import, the following error is displayed through the UI.
  Upload Success
  350.450858217213IRS_template_test_import.xls
  XML Parsing Error: mismatched tag. Expected: . Location: http://localhost:8888/dhis-web-excel-reporting/getImportingParams.action Line Number 62, Column 70:

  
      *

  About DHIS 2

  Current user:
      admin
  Version:
      2.0.6-SNAPSHOT
  Build revision:
      2562 
  Build date:
      2011-01-14 10:24
  User agent:
      Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13
  External configuration directory:
      C:\Program Files\DHIS2-2.0.5\conf
  Environment variable:
      DHIS2_HOME
  Database type:
      PostgreSQL
  Database name:
      harvard2
  Database user:
      postgres
  Java Opts:
  Java version:
      1.6.0_22
  Java vendor:
      Sun Microsystems Inc.
  OS name:
      Windows 7
  OS architecture:
      x86
  OS version:
      6.1





References