date:20160527

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.20 War file fail to be executed:SEVERE: Error configuring application listener of class org.hisp.dhis.system.startup.StartupListener

2016-05-27 Thread Craig A

Hi,

There's a mismatch with your java version. The default Java version for
Ubuntu 14.04 is Java 7. You'll have to autoremove Java 7 and install Java
8. The instructions for installing Java 8 can be found near the bottom of this
page
.

Sincerely,
Craig

On Thu, May 26, 2016 at 10:57 AM, Kamugunga Adolphe 
wrote:

> Hi there,
>
> I am trying to install a training server on ubuntu 14.04  with a recent
>  2.20 war file on a laptop. When i browser the nginx works fine but when i
> include the full path to my test instance it fails to run.
>
> Checking from the catalina logs file i realize that the system had severe
> error.Can someone guide me how to deal with it? Here is the log details
>
> May 26, 2016 6:25:04 PM org.apache.coyote.AbstractProtocol init
>
> INFO: Initializing ProtocolHandler ["http-bio-127.0.0.1-8081"]
>
> May 26, 2016 6:25:04 PM org.apache.catalina.startup.Catalina load
>
> INFO: Initialization processed in 616 ms
>
> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardService
> startInternal
>
> INFO: Starting service Catalina
>
> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardEngine
> startInternal
>
> INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
>
> May 26, 2016 6:25:04 PM org.apache.catalina.startup.HostConfig deployWAR
>
> INFO: Deploying web application archive
> /var/lib/dhis2/test/webapps/test.war
>
> May 26, 2016 6:25:18 PM org.apache.catalina.core.ApplicationContext log
>
> INFO: No Spring WebApplicationInitializer types detected on classpath
>
> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
> listenerStart
>
> SEVERE: Error configuring application listener of class
> org.hisp.dhis.system.startup.StartupListener
>
> java.lang.UnsupportedClassVersionError:
> org/hisp/dhis/system/startup/StartupListener : Unsupported major.minor
> version 52.0 (unable to load class
> org.hisp.dhis.system.startup.StartupListener)
>
> at
> org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2948)
>
> at
> org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1208)
>
> at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1688)
>
> at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1569)
>
> at
> org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:529)
>
> at
> org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:511)
>
> at
> org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:139)
>
> at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4888)
>
> at
> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
>
> at
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
>
> at
> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
>
> at
> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
>
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>
> at java.lang.Thread.run(Thread.java:745)
>
>
>
> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
> listenerStart
>
> SEVERE: Skipped installing application listeners due to previous error(s)
>
> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
> startInternal
>
> SEVERE: Error listenerStart
>
> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
> startInternal
>
> SEVERE: Context [/test] startup failed due to previous errors
>
> May 26, 2016 6:25:18 PM org.apache.coyote.AbstractProtocol start
>
> INFO: Starting ProtocolHandler ["http-bio-127.0.0.1-8081"]
>
> May 26, 2016 6:25:18 PM org.apache.catalina.startup.Catalina start
>
> INFO: Server startup in 14165 ms
>
>
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> *Knowledge Management, Data Use and Research*
> Rwanda Health System Strengthening Activity
> Management Sciences for Health
> Rwanda-Kigali
> Mobile: +250 788 740 578
> Email:kaa...@gmail.com
> Skype: ka.adolphe
> 
> Stronger health systems. Greater

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.20 War file fail to be executed:SEVERE: Error configuring application listener of class org.hisp.dhis.system.startup.StartupListener

2016-05-27 Thread Paulo Grácio

Hi Adolphe,

another option is to use Docker to start the training environments. You can
find some more information here
https://github.com/pgracio/dhis2-docker

docker images
https://hub.docker.com/r/pgracio/dhis2-web/tags/
https://hub.docker.com/r/pgracio/dhis2-db/tags/

Regards,
Paulo

On Fri, May 27, 2016 at 11:59 AM Kamugunga Adolphe  wrote:

> Thank you very much dear team
> It ok now.
>
> Regards,
>
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> *Knowledge Management, Data Use and Research*
> Rwanda Health System Strengthening Activity
> Management Sciences for Health
> Rwanda-Kigali
> Mobile: +250 788 740 578
> Email:kaa...@gmail.com
> Skype: ka.adolphe
> 
> Stronger health systems. Greater health impact.
>
>
> On 26 May 2016 at 20:03, Craig A  wrote:
>
>> Hi,
>>
>> There's a mismatch with your java version. The default Java version for
>> Ubuntu 14.04 is Java 7. You'll have to autoremove Java 7 and install Java
>> 8. The instructions for installing Java 8 can be found near the bottom of 
>> this
>> page
>> 
>> .
>>
>> Sincerely,
>> Craig
>>
>> On Thu, May 26, 2016 at 10:57 AM, Kamugunga Adolphe 
>> wrote:
>>
>>> Hi there,
>>>
>>> I am trying to install a training server on ubuntu 14.04  with a recent
>>>  2.20 war file on a laptop. When i browser the nginx works fine but when i
>>> include the full path to my test instance it fails to run.
>>>
>>> Checking from the catalina logs file i realize that the system had
>>> severe error.Can someone guide me how to deal with it? Here is the log
>>> details
>>>
>>> May 26, 2016 6:25:04 PM org.apache.coyote.AbstractProtocol init
>>>
>>> INFO: Initializing ProtocolHandler ["http-bio-127.0.0.1-8081"]
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.startup.Catalina load
>>>
>>> INFO: Initialization processed in 616 ms
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardService
>>> startInternal
>>>
>>> INFO: Starting service Catalina
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardEngine
>>> startInternal
>>>
>>> INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
>>>
>>> May 26, 2016 6:25:04 PM org.apache.catalina.startup.HostConfig deployWAR
>>>
>>> INFO: Deploying web application archive
>>> /var/lib/dhis2/test/webapps/test.war
>>>
>>> May 26, 2016 6:25:18 PM org.apache.catalina.core.ApplicationContext log
>>>
>>> INFO: No Spring WebApplicationInitializer types detected on classpath
>>>
>>> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
>>> listenerStart
>>>
>>> SEVERE: Error configuring application listener of class
>>> org.hisp.dhis.system.startup.StartupListener
>>>
>>> java.lang.UnsupportedClassVersionError:
>>> org/hisp/dhis/system/startup/StartupListener : Unsupported major.minor
>>> version 52.0 (unable to load class
>>> org.hisp.dhis.system.startup.StartupListener)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2948)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1208)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1688)
>>>
>>> at
>>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1569)
>>>
>>> at
>>> org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:529)
>>>
>>> at
>>> org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:511)
>>>
>>> at
>>> org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:139)
>>>
>>> at
>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4888)
>>>
>>> at
>>> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
>>>
>>> at
>>> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>>>
>>> at
>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>>>
>>> at
>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>>>
>>> at
>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
>>>
>>> at
>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
>>>
>>> at
>>> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
>>>
>>> at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>>>
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>>
>>> at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>>
>>> at
>>>

[Dhis2-devs] Discrepancy in reporting rates while using pivot table and the reports module

2016-05-27 Thread Ayub Manya

Questions arising from the field indicate that there is a discrepancy in
the reporting rates using the pivot tables and the reporting rate in the
reports module. Pivot tables even gives rates above 100%

Kisumu county MOH 731-2PMTCT 2014. Version: 2.20 Build revision: 20029



organisation unit name

Reporting rate From Pivot table

Reporting rate from Data set reports

Seme

106

100

Kisumu East

91.7

88.2

Kisumu West

84.6

84.6

Muhoroni

98.9

98.9

Nyakach

87.3

87.3

Nyando

97.2

97.2

-- 
*Ayub Manya*
___
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

[Dhis2-devs] Switching between data entry formats

2016-05-27 Thread Johan Ivar Sæbø


Hi,

if I remember correctly, it used to be possible to switch between 
default, section, and custom data entry form while in the data entry 
app. I can't see that this is possible now. Is there a way to do this, 
without affecting all users? Or better, to switch between two custom forms?


Our case is a rather complicated custom (official) form, where we want 
to explore other ways of displaying this for users. The point is that we 
need to keep the official form, and only test alternative layouts for 
specific users. An alternative could be to make another data set with 
the same data elements, but this is messy. Any thoughts, or similar 
experiences?


Johan

___
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

Re: [Dhis2-devs] Issue with tracker capture

2016-05-27 Thread Erling Fjelstad

Do you see this behavior every time? What happens if you reinstall the app
from Google Play and log in to play.dhis2.org/demo with user credentials
username: android , password: Android123
You can find APK for DHIS 2.20 here:
https://github.com/dhis2/dhis2-android-trackercapture/releases/download/0.2.10-2.20/app-release.apk
Regards,
Erling

On Fri, May 27, 2016 at 2:44 PM, Seid Hussein  wrote:

> Hi Erling,
>
> I'm using the current app on Google Play. My mobile is Huawei P8 with
> Android 5.0 lollipop. And I was testing it on the demo site.
>
> P.S. Is there any apk compatible with DHIS2 version 2.20? Where can I get
> it?
>
> Regards,
>
> Seid,
> On May 27, 2016 3:33 PM, "Erling Fjelstad"  wrote:
>
>> Hello Seid,
>> This is a very strange behavior that I haven't seen before. Which Android
>> device are you testing on? Which version of DHIS2 are you testing on? Where
>> did you download the Android app?
>> Regards,
>> Erling
>>
>> On Fri, May 27, 2016 at 2:25 PM, Seid Hussein 
>> wrote:
>>
>>> Hi all,
>>>
>>> I was testing tracker capture and after syncing with the server, it
>>> doesn't show the list of organization units. The only thing it shows when I
>>> trap on Choose an Organization Unit is a search box to find organization
>>> units. Is that a normal behavior? I've tested it both with my instance and
>>> the demo site.
>>>
>>> Seid,
>>>
>>> ___
>>> 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
>>>
>>>
>>
___
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

Re: [Dhis2-devs] Issue with tracker capture

2016-05-27 Thread Seid Hussein

Hi Erling,

I'm using the current app on Google Play. My mobile is Huawei P8 with
Android 5.0 lollipop. And I was testing it on the demo site.

P.S. Is there any apk compatible with DHIS2 version 2.20? Where can I get
it?

Regards,

Seid,
On May 27, 2016 3:33 PM, "Erling Fjelstad"  wrote:

> Hello Seid,
> This is a very strange behavior that I haven't seen before. Which Android
> device are you testing on? Which version of DHIS2 are you testing on? Where
> did you download the Android app?
> Regards,
> Erling
>
> On Fri, May 27, 2016 at 2:25 PM, Seid Hussein  wrote:
>
>> Hi all,
>>
>> I was testing tracker capture and after syncing with the server, it
>> doesn't show the list of organization units. The only thing it shows when I
>> trap on Choose an Organization Unit is a search box to find organization
>> units. Is that a normal behavior? I've tested it both with my instance and
>> the demo site.
>>
>> Seid,
>>
>> ___
>> 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
>>
>>
>
___
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

Re: [Dhis2-devs] Issue with tracker capture

2016-05-27 Thread Erling Fjelstad

Hello Seid,
This is a very strange behavior that I haven't seen before. Which Android
device are you testing on? Which version of DHIS2 are you testing on? Where
did you download the Android app?
Regards,
Erling

On Fri, May 27, 2016 at 2:25 PM, Seid Hussein  wrote:

> Hi all,
>
> I was testing tracker capture and after syncing with the server, it
> doesn't show the list of organization units. The only thing it shows when I
> trap on Choose an Organization Unit is a search box to find organization
> units. Is that a normal behavior? I've tested it both with my instance and
> the demo site.
>
> Seid,
>
> ___
> 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
>
>
___
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

[Dhis2-devs] Issue with tracker capture

2016-05-27 Thread Seid Hussein

Hi all,

I was testing tracker capture and after syncing with the server, it doesn't
show the list of organization units. The only thing it shows when I trap on
Choose an Organization Unit is a search box to find organization units. Is
that a normal behavior? I've tested it both with my instance and the demo
site.

Seid,
___
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

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.20 War file fail to be executed:SEVERE: Error configuring application listener of class org.hisp.dhis.system.startup.StartupListener

2016-05-27 Thread Kamugunga Adolphe

Thank you very much dear team
It ok now.

Regards,


*Adolphe Kamugunga*
*MIS Technical Advisor*
*Knowledge Management, Data Use and Research*
Rwanda Health System Strengthening Activity
Management Sciences for Health
Rwanda-Kigali
Mobile: +250 788 740 578
Email:kaa...@gmail.com
Skype: ka.adolphe

Stronger health systems. Greater health impact.


On 26 May 2016 at 20:03, Craig A  wrote:

> Hi,
>
> There's a mismatch with your java version. The default Java version for
> Ubuntu 14.04 is Java 7. You'll have to autoremove Java 7 and install Java
> 8. The instructions for installing Java 8 can be found near the bottom of this
> page
> 
> .
>
> Sincerely,
> Craig
>
> On Thu, May 26, 2016 at 10:57 AM, Kamugunga Adolphe 
> wrote:
>
>> Hi there,
>>
>> I am trying to install a training server on ubuntu 14.04  with a recent
>>  2.20 war file on a laptop. When i browser the nginx works fine but when i
>> include the full path to my test instance it fails to run.
>>
>> Checking from the catalina logs file i realize that the system had severe
>> error.Can someone guide me how to deal with it? Here is the log details
>>
>> May 26, 2016 6:25:04 PM org.apache.coyote.AbstractProtocol init
>>
>> INFO: Initializing ProtocolHandler ["http-bio-127.0.0.1-8081"]
>>
>> May 26, 2016 6:25:04 PM org.apache.catalina.startup.Catalina load
>>
>> INFO: Initialization processed in 616 ms
>>
>> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardService
>> startInternal
>>
>> INFO: Starting service Catalina
>>
>> May 26, 2016 6:25:04 PM org.apache.catalina.core.StandardEngine
>> startInternal
>>
>> INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
>>
>> May 26, 2016 6:25:04 PM org.apache.catalina.startup.HostConfig deployWAR
>>
>> INFO: Deploying web application archive
>> /var/lib/dhis2/test/webapps/test.war
>>
>> May 26, 2016 6:25:18 PM org.apache.catalina.core.ApplicationContext log
>>
>> INFO: No Spring WebApplicationInitializer types detected on classpath
>>
>> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
>> listenerStart
>>
>> SEVERE: Error configuring application listener of class
>> org.hisp.dhis.system.startup.StartupListener
>>
>> java.lang.UnsupportedClassVersionError:
>> org/hisp/dhis/system/startup/StartupListener : Unsupported major.minor
>> version 52.0 (unable to load class
>> org.hisp.dhis.system.startup.StartupListener)
>>
>> at
>> org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2948)
>>
>> at
>> org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1208)
>>
>> at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1688)
>>
>> at
>> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1569)
>>
>> at
>> org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:529)
>>
>> at
>> org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:511)
>>
>> at
>> org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:139)
>>
>> at
>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4888)
>>
>> at
>> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
>>
>> at
>> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>>
>> at
>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
>>
>> at
>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>>
>> at
>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
>>
>> at
>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
>>
>> at
>> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
>>
>> at
>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>>
>> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>
>> at java.lang.Thread.run(Thread.java:745)
>>
>>
>>
>> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
>> listenerStart
>>
>> SEVERE: Skipped installing application listeners due to previous error(s)
>>
>> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
>> startInternal
>>
>> SEVERE: Error listenerStart
>>
>> May 26, 2016 6:25:18 PM org.apache.catalina.core.StandardContext
>> startInternal
>>
>> SEVERE: Context [/test] startup failed due to

[Dhis2-devs] Web Api Error in DHIS 221

2016-05-27 Thread Guy Ekani

Hello Team,
Please, I have an error when trying to run the following 
completeDataSetRegistrations web api in Dhis 221 (20998):
http:..api/completeDataSetRegistrations?dataSet=E2cBlfTJKqU=WEEKLY=2016-01-01=2016-02-22=LEVEL-1
if someone could help or explain ?
The error is the following :
Etat HTTP 500 - Request processing failed; nested exception is 
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
type Rapport d''exceptionmessage Request processing failed; nested exception is 
org.hibernate.exception.SQLGrammarException: could not extract 
ResultSetdescription Le serveur a rencontré une erreur interne qui l''a empêché 
de satisfaire la 
requête.exceptionorg.springframework.web.util.NestedServletException: Request 
processing failed; nested exception is 
org.hibernate.exception.SQLGrammarException: could not extract ResultSet

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:979)

org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)
javax.servlet.http.HttpServlet.service(HttpServlet.java:624)

org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:202)
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:180)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
org.hisp.dhis.security.filter.CorsFilter.doFilter(CorsFilter.java:88)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:64)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:140)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

[Dhis2-devs] compulsory DE accepting empty values through the API on 2.22 server

2016-05-27 Thread Ignacio Foche

Hi devs,

We're developing our app integrating the Android SDK and we've
experimenting an strange behaviour when pushing empty values for DEs whose
compulsory flag is enabled. The SDK is making a POST API call of the event
and the empty values are accepted by the server. Is this the way API is
intended to operate? is this a bug?

To ilustrate it better, here the mandatory flag configured as enabled for
"KH_MAL_SRV - RDT"

[image: programs_mandatory.png]
and here the blank result for that DE...

[image: blank_on_dev.png]

BTW, server info is...
Version:2.22Build revision:22027Build date:2016-05-10 02:31
Thanks in advance.

Best regards
___
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

Re: [Dhis2-devs] SQL View Doesn't work for comma seperated variables

2016-05-27 Thread Jason Pickering

Hi there.

This syntax is not supported as you can see from the documentation


*The variable parameter must contain alphanumeric characters only. The
variables must contain alphanumeric, dash, underscore and whitespace
characters only.*

This might be something which can added, but there could be an increased
risk of SQL injection attacks, which these restrictions are meant to try
and prevent to some extent.  Maybe the developers can say more about this.

Regards,
Jason


On Fri, May 27, 2016 at 8:14 AM, Priyanka Bawa 
wrote:

> This error comes in version 2.20.
>
> Regards
> Priyanka
>
> On Fri, May 27, 2016 at 11:36 AM, Priyanka Bawa  > wrote:
>
>> Hi
>> I am trying to create an SQLView where i am using a variable (
>> *populationFormSOU1).* The result of this variable is comma separated as
>> :-  shvnNIx,1biz5LW,BZuwzHr5,RP4CW,lYFre,n5z2VKrv,5Ut1oxMO,FJETOdBp,h7sbFDA
>>
>> SELECT COUNT(*) FROM completedatasetregistration WHERE sourceid IN
>> (populationFormSOU1='${*populationFormSOU1*}') AND datasetid = 52 AND
>> periodid = '${periodid}';
>>
>>
>> The result of above SQLView says that the variables are invalid [image:
>> Inline image 1]
>> Seems that the query doesn't take variables having any special character.
>> Any help will be appreciated.
>>
>> Regards
>> Priyanka
>>
>
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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

Re: [Dhis2-devs] SQL View Doesn't work for comma seperated variables

2016-05-27 Thread Priyanka Bawa

This error comes in version 2.20.

Regards
Priyanka

On Fri, May 27, 2016 at 11:36 AM, Priyanka Bawa 
wrote:

> Hi
> I am trying to create an SQLView where i am using a variable (
> *populationFormSOU1).* The result of this variable is comma separated as
> :-  shvnNIx,1biz5LW,BZuwzHr5,RP4CW,lYFre,n5z2VKrv,5Ut1oxMO,FJETOdBp,h7sbFDA
>
> SELECT COUNT(*) FROM completedatasetregistration WHERE sourceid IN
> (populationFormSOU1='${*populationFormSOU1*}') AND datasetid = 52 AND
> periodid = '${periodid}';
>
>
> The result of above SQLView says that the variables are invalid [image:
> Inline image 1]
> Seems that the query doesn't take variables having any special character.
> Any help will be appreciated.
>
> Regards
> Priyanka
>
___
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

[Dhis2-devs] SQL View Doesn't work for comma seperated variables

2016-05-27 Thread Priyanka Bawa

Hi
I am trying to create an SQLView where i am using a variable (
*populationFormSOU1).* The result of this variable is comma separated as :-
 shvnNIx,1biz5LW,BZuwzHr5,RP4CW,lYFre,n5z2VKrv,5Ut1oxMO,FJETOdBp,h7sbFDA

SELECT COUNT(*) FROM completedatasetregistration WHERE sourceid IN
(populationFormSOU1='${*populationFormSOU1*}') AND datasetid = 52 AND
periodid = '${periodid}';


The result of above SQLView says that the variables are invalid [image:
Inline image 1]
Seems that the query doesn't take variables having any special character.
Any help will be appreciated.

Regards
Priyanka
___
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

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.20 War file fail to be executed:SEVERE: Error configuring application listener of class org.hisp.dhis.system.startup.StartupListener

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.20 War file fail to be executed:SEVERE: Error configuring application listener of class org.hisp.dhis.system.startup.StartupListener

[Dhis2-devs] Discrepancy in reporting rates while using pivot table and the reports module

[Dhis2-devs] Switching between data entry formats

Re: [Dhis2-devs] Issue with tracker capture

Re: [Dhis2-devs] Issue with tracker capture

Re: [Dhis2-devs] Issue with tracker capture

[Dhis2-devs] Issue with tracker capture

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.20 War file fail to be executed:SEVERE: Error configuring application listener of class org.hisp.dhis.system.startup.StartupListener

[Dhis2-devs] Web Api Error in DHIS 221

[Dhis2-devs] compulsory DE accepting empty values through the API on 2.22 server

Re: [Dhis2-devs] SQL View Doesn't work for comma seperated variables

Re: [Dhis2-devs] SQL View Doesn't work for comma seperated variables

[Dhis2-devs] SQL View Doesn't work for comma seperated variables

14 matches

Site Navigation

Mail list logo

Footer information