date:20161023

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-23 Thread Brajesh Murari

Congratulation Neeraj and team ...it much appreciated

On Mon, Oct 24, 2016 at 11:08 AM, Neeraj Gupta 
wrote:

> Dear Team, Thanks for all your suggestions.
>
> Now the time of analytic is reduced to 10 hours 41 minutes.
>
> We tried to VACUUM as Sam suggested but it didn't help then we upgraded
> postgres from 9.4 to 9.5.4 and as Calle and Bob suggested we made some
> changes in configuration file of postgres and it reduced the time. But the
> database size is still same.
>
> Thanks for all your help!
>
> Thanks,
> Neeraj
>
> On Wed, Oct 19, 2016 at 6:46 PM, Calle Hedberg 
> wrote:
>
>> Neeraj,
>>
>> It's always an element of uncertainty linked to database sizes - ref
>> Sam's post over. So indicating the number of records you have in the
>> datavalue table & key meta-data tables would be useful + indicating whether
>> you are running other instances on the same server. Some comments - I've
>> been doing a lot of similar optimising work recently:
>>
>> 1. Upgrading to 9.5.4 is strongly recommended (and don't use 9.6 before
>> the worst bugs are fixed and it has stabilised).
>>
>> 2. Carefully check your postgres.conf against the recommended settings.
>> The guide is a bit superficial in the sense that it has recommended "fixed"
>> values only and no explanations around ranges below or above those, but you
>> can experiment a bit yourself (e.g. the recommended "max_connections = 200"
>> might not be sufficient for a really large system like what you have.
>>
>> 3. If your server is running that single instance only, then 48GB or RAM
>> should be sufficient. Our servers are all having 128GB RAM so we
>> experimented quite a bit earlier this year with giving a DHIS2 instance
>> large amounts or RAM (up to 60-70gb), with negligible impact on
>> performance. According to Lars, the DHIS2 cannot really utilize more than
>> around 16gb RAM (at least that is how I understood his communication at the
>> time). So 48GB should be sufficient for a single instance.
>>
>> 4. I've been doing performance optimizing recently on an instance with
>> - 4-core server with 2x 512gb ssd, 12gb allocated to DHIS2
>> - 31,000 Orgunits
>> - 420 data elements
>> - 250 indicators
>> - around 100 mill datavalue records
>> - total size around 140gb with analytics tables.
>>
>> So the size is only 25% of your 500GB, but RUNNING ANALYTICS ON THAT
>> DATABASE INSTANCE IS TAKING JUST OVER 1 HOUR. Fundamentally, if the
>> analytics engine is designed well, I would expect a nearly linear
>> relationship between database size and the time analytics takes to run. So
>> running analytics on your database on our server should in theory take 4-5
>> hours.
>>
>> We are obviously comparing oranges and nectarines here, in the sense that
>> there might be other aspects of our server and database that is different
>> from yours (type of CPU, no of OUs, no of DEs/Indicators, whether your
>> instance have lots of tracker data, etc etc). I have not seen any
>> scientific/quantified comparative performance values related to specific
>> parameters like number of CPUs and/or number of cores, but 12 cores SHOULD
>> improve analytics performance quite a bit - assuming around 30% then it
>> means running analytics on your database/server should take around 3
>> hours..
>>
>> I tried getting comparative, quantitative data on various configurations
>> of hardware and software (e.g. some users prefer CentOS, others Ubuntu)
>> during the academy in August, but did not get much - it seems most
>> users/providers have found a setup that works for them for now and nobody
>> is doing any systematic performance testing (some of the international
>> NGOs/companies using DHIS2 might have, but as with internally developed
>> apps they are not that keen on sharing). So it would be highly appreciated
>> if you would post the results on analytics time with every upgrade / tweak
>> you do - starting with the upgrade to Pg 9.5.4
>>
>> Best regards
>> Calle
>>
>> On 19 October 2016 at 13:28, Sam Johnson 
>> wrote:
>>
>>> Hi Neeraj,
>>>
>>>
>>>
>>> *Using VACUUM and ANALYZE*
>>>
>>>
>>>
>>> Like Brajesh, my background is MySQL, and one database admin task that
>>> is often overlooked in MySQL is OPTIMIZE TABLEs.  This reclaims unused
>>> space (we’ve had 100Gb databases files drop to half their size) and
>>> refreshes index statistics (if the shape of your data has changed over
>>> time, this can make indices run faster).
>>>
>>>
>>>
>>> I’m new to PostgreSQL, but the core principles are the same, and a quick
>>> bit of Googling shows that the equivalents in PostgreSQL are the VACUUM and
>>> ANALYZE commands.  If your database isn’t set to automatically do VACUUMs
>>> (the default DHIS2 postgres config doesn’t seem to be), you might want to
>>> try VACUUM *FULL*, which will literally rewrite all of your database
>>> tables and indices into smaller, more efficient files (note, however, that
>>> on a

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-23 Thread Neeraj Gupta

Dear Team, Thanks for all your suggestions.

Now the time of analytic is reduced to 10 hours 41 minutes.

We tried to VACUUM as Sam suggested but it didn't help then we upgraded
postgres from 9.4 to 9.5.4 and as Calle and Bob suggested we made some
changes in configuration file of postgres and it reduced the time. But the
database size is still same.

Thanks for all your help!

Thanks,
Neeraj

On Wed, Oct 19, 2016 at 6:46 PM, Calle Hedberg 
wrote:

> Neeraj,
>
> It's always an element of uncertainty linked to database sizes - ref Sam's
> post over. So indicating the number of records you have in the datavalue
> table & key meta-data tables would be useful + indicating whether you are
> running other instances on the same server. Some comments - I've been doing
> a lot of similar optimising work recently:
>
> 1. Upgrading to 9.5.4 is strongly recommended (and don't use 9.6 before
> the worst bugs are fixed and it has stabilised).
>
> 2. Carefully check your postgres.conf against the recommended settings.
> The guide is a bit superficial in the sense that it has recommended "fixed"
> values only and no explanations around ranges below or above those, but you
> can experiment a bit yourself (e.g. the recommended "max_connections = 200"
> might not be sufficient for a really large system like what you have.
>
> 3. If your server is running that single instance only, then 48GB or RAM
> should be sufficient. Our servers are all having 128GB RAM so we
> experimented quite a bit earlier this year with giving a DHIS2 instance
> large amounts or RAM (up to 60-70gb), with negligible impact on
> performance. According to Lars, the DHIS2 cannot really utilize more than
> around 16gb RAM (at least that is how I understood his communication at the
> time). So 48GB should be sufficient for a single instance.
>
> 4. I've been doing performance optimizing recently on an instance with
> - 4-core server with 2x 512gb ssd, 12gb allocated to DHIS2
> - 31,000 Orgunits
> - 420 data elements
> - 250 indicators
> - around 100 mill datavalue records
> - total size around 140gb with analytics tables.
>
> So the size is only 25% of your 500GB, but RUNNING ANALYTICS ON THAT
> DATABASE INSTANCE IS TAKING JUST OVER 1 HOUR. Fundamentally, if the
> analytics engine is designed well, I would expect a nearly linear
> relationship between database size and the time analytics takes to run. So
> running analytics on your database on our server should in theory take 4-5
> hours.
>
> We are obviously comparing oranges and nectarines here, in the sense that
> there might be other aspects of our server and database that is different
> from yours (type of CPU, no of OUs, no of DEs/Indicators, whether your
> instance have lots of tracker data, etc etc). I have not seen any
> scientific/quantified comparative performance values related to specific
> parameters like number of CPUs and/or number of cores, but 12 cores SHOULD
> improve analytics performance quite a bit - assuming around 30% then it
> means running analytics on your database/server should take around 3
> hours..
>
> I tried getting comparative, quantitative data on various configurations
> of hardware and software (e.g. some users prefer CentOS, others Ubuntu)
> during the academy in August, but did not get much - it seems most
> users/providers have found a setup that works for them for now and nobody
> is doing any systematic performance testing (some of the international
> NGOs/companies using DHIS2 might have, but as with internally developed
> apps they are not that keen on sharing). So it would be highly appreciated
> if you would post the results on analytics time with every upgrade / tweak
> you do - starting with the upgrade to Pg 9.5.4
>
> Best regards
> Calle
>
> On 19 October 2016 at 13:28, Sam Johnson 
> wrote:
>
>> Hi Neeraj,
>>
>>
>>
>> *Using VACUUM and ANALYZE*
>>
>>
>>
>> Like Brajesh, my background is MySQL, and one database admin task that is
>> often overlooked in MySQL is OPTIMIZE TABLEs.  This reclaims unused space
>> (we’ve had 100Gb databases files drop to half their size) and refreshes
>> index statistics (if the shape of your data has changed over time, this can
>> make indices run faster).
>>
>>
>>
>> I’m new to PostgreSQL, but the core principles are the same, and a quick
>> bit of Googling shows that the equivalents in PostgreSQL are the VACUUM and
>> ANALYZE commands.  If your database isn’t set to automatically do VACUUMs
>> (the default DHIS2 postgres config doesn’t seem to be), you might want to
>> try VACUUM *FULL*, which will literally rewrite all of your database
>> tables and indices into smaller, more efficient files (note, however, that
>> on a 500Gb database this could take a *looong* time – perhaps test on a
>> backup first?).  The following forum post is a really nice, plain-English
>> explanation of what VACUUM does:
>>
>> http://dba.stackexchange.com/questions/126258/what-is-table-
>>

Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza

2016-10-23 Thread Knut Staring

Thsnks,  was mismatch between .war and demo db version.

On Oct 24, 2016 6:35 AM, "Lars Helge Øverland"  wrote:

> Hi,
>
> it could be that someone jumped from dhis version 2.21 to 2.25 in one go
> on the same db. Try loading 2.23, then 2.25.
>
> Lars
>
> On Oct 24, 2016 5:05 AM, "Morten Olav Hansen"  wrote:
>
>> Caused by: org.postgresql.util.PSQLException: ERROR: column
>> usercreden1_.uid does not exist
>>
>> Maybe you should try and add that column manually?
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Tue, Oct 18, 2016 at 4:17 AM, Knut Staring  wrote:
>>
>>> Any idea what the issue could be here with DHIS Live?
>>>
>>> -- Forwarded message --
>>>
>>> And this is conf/logs/dhis.log:
>>>
>>> * INFO  2016-10-17 22:01:09,926 Added root logger using file:
>>> /D:/skule/inf5750/dhis-live/conf\logs\dhis.log
>>> (Log4JLogConfigInitializer.java [Thread-2])
>>> * WARN  2016-10-17 22:01:10,947 RP discovery / realm validation
>>> disabled;  (RealmVerifier.java [Thread-2])
>>> * INFO  2016-10-17 22:01:13,701 SMS configuration not found
>>> (DefaultSmsConfigurationManager.java [Thread-2])
>>> * INFO  2016-10-17 22:01:13,828 Scheduled task with key:
>>> fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java
>>> [Thread-2])
>>> * INFO  2016-10-17 22:01:13,829 Scheduled task with key:
>>> dataStatisticsTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
>>> * INFO  2016-10-17 22:01:13,841 Executing startup routine [1 of 14,
>>> runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java
>>> [Thread-2])
>>> * INFO  2016-10-17 22:01:20,688 Executing startup routine [2 of 14,
>>> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
>>> [Thread-2])
>>> * INFO  2016-10-17 22:01:20,739 Executing startup routine [3 of 14,
>>> runlevel 3]: DataElementDefaultDimensionPopulator
>>> (DefaultStartupRoutineExecutor.java [Thread-2])
>>> * INFO  2016-10-17 22:01:20,876 'system-process' update
>>> org.hisp.dhis.dataelement.DataElementCategory, name: default, uid:
>>> vGs6omsRekv (AuditLogUtil.java [Thread-2])
>>> * WARN  2016-10-17 22:01:21,256 SQL Error: 0, SQLState: 42703
>>> (SqlExceptionHelper.java [Thread-2])
>>> * ERROR 2016-10-17 22:01:21,257 ERROR: column usercreden1_.uid does not
>>> exist
>>>   Position: 756 (SqlExceptionHelper.java [Thread-2])
>>> * ERROR 2016-10-17 22:01:21,265 org.hibernate.exception.SQLGrammarException:
>>> could not extract ResultSet
>>> at org.hibernate.exception.internal.SQLStateConversionDelegate.
>>> convert(SQLStateConversionDelegate.java:106)
>>> at org.hibernate.exception.internal.StandardSQLExceptionConvert
>>> er.convert(StandardSQLExceptionConverter.java:42)
>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>> ExceptionHelper.java:111)
>>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>>> ExceptionHelper.java:97)
>>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extra
>>> ct(ResultSetReturnImpl.java:79)
>>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
>>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
>>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
>>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>>> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
>>> at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntity
>>> Loader.load(AbstractLoadPlanBasedEntityLoader.java:167)
>>> at org.hibernate.persister.entity.AbstractEntityPersister.load(
>>> AbstractEntityPersister.java:3991)
>>> at org.hibernate.event.internal.DefaultLoadEventListener.loadFr
>>> omDatasource(DefaultLoadEventListener.java:508)
>>> at org.hibernate.event.internal.DefaultLoadEventListener.doLoad
>>> (DefaultLoadEventListener.java:478)
>>> at org.hibernate.event.internal.DefaultLoadEventListener.load(D
>>> efaultLoadEventListener.java:219)
>>> at org.hibernate.event.internal.DefaultLoadEventListener.proxyO
>>> rLoad(DefaultLoadEventListener.java:262)
>>> at org.hibernate.event.internal.DefaultLoadEventListener.doOnLo
>>> ad(DefaultLoadEventListener.java:121)
>>> at org.hibernate.event.internal.DefaultLoadEventListener.onLoad
>>> (DefaultLoadEventListener.java:89)
>>> at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java
>>> :1142)
>>> at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.
>>> java:1025)
>>> at org.hibernate.type.EntityType.resolveIdentifier(EntityType.j
>>> ava:632)
>>> at org.hibernate.type.EntityType.resolve(EntityType.java:424)
>>> at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntit
>>>

Re: [Dhis2-users] [Dhis2-devs] GIS 2.25

2016-10-23 Thread Morten Olav Hansen

Hi

Are you using chrome? could you open up the developer tools, and see if
there is anything in the console. Sounds like it can't load because of some
issues with your configuration.

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Mon, Oct 24, 2016 at 11:51 AM, Absolom MURAMIRA 
wrote:

> Dear Calle,
>
> I installed postgis 9.5.3. Would that be the reason?
>
> Sent from Yahoo Mail on Android
> 
>
> On Mon, 24 Oct, 2016 at 0:35, Calle Hedberg
>  wrote:
> Absalom,
>
> You have installed postgis with pg 9.5.4?
>
> Regards
> Calle
>
> On 22 October 2016 at 10:36, Absolom MURAMIRA  wrote:
>
>> Dear All,
>>
>> I am testing release 2.25 and appreciate the developers' contribution to
>> the good improvements to the DHIS2 application.
>> Most of the apps are running well apart from the GIS app. It loads
>> forever and cannot load its interface to enable me generate maps. Can
>> someone please advise me if there is some configuration I need to enable
>> first? I checked the demo site which is okay. the pivot tables and data
>> visualizers are loading normally.
>>
>> The testing environment in Linux server 16.04 LTS and postgresql 9.5
>>
>> Thank you.
>>
>> Absolom
>> Kigali
>>
>> __ _
>> Mailing list: https://launchpad.net/~dhis2- devs
>> 
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2- devs
>> 
>> More help   : https://help.launchpad.net/ ListHelp
>> 
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] GIS 2.25

2016-10-23 Thread Absolom MURAMIRA

Dear Calle,
I installed postgis 9.5.3. Would that be the reason?
Sent from Yahoo Mail on Android 
 
  On Mon, 24 Oct, 2016 at 0:35, Calle Hedberg wrote:   
Absalom,
You have installed postgis with pg 9.5.4?
RegardsCalle
On 22 October 2016 at 10:36, Absolom MURAMIRA  wrote:

Dear All,
I am testing release 2.25 and appreciate the developers' contribution to the 
good improvements to the DHIS2 application.Most of the apps are running well 
apart from the GIS app. It loads forever and cannot load its interface to 
enable me generate maps. Can someone please advise me if there is some 
configuration I need to enable first? I checked the demo site which is okay. 
the pivot tables and data visualizers are loading normally.
The testing environment in Linux server 16.04 LTS and postgresql 9.5
Thank you.
AbsolomKigali

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





-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA 

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***

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

Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza

2016-10-23 Thread Lars Helge Øverland

Hi,

it could be that someone jumped from dhis version 2.21 to 2.25 in one go on
the same db. Try loading 2.23, then 2.25.

Lars

On Oct 24, 2016 5:05 AM, "Morten Olav Hansen"  wrote:

> Caused by: org.postgresql.util.PSQLException: ERROR: column
> usercreden1_.uid does not exist
>
> Maybe you should try and add that column manually?
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Tue, Oct 18, 2016 at 4:17 AM, Knut Staring  wrote:
>
>> Any idea what the issue could be here with DHIS Live?
>>
>> -- Forwarded message --
>>
>> And this is conf/logs/dhis.log:
>>
>> * INFO  2016-10-17 22:01:09,926 Added root logger using file:
>> /D:/skule/inf5750/dhis-live/conf\logs\dhis.log
>> (Log4JLogConfigInitializer.java [Thread-2])
>> * WARN  2016-10-17 22:01:10,947 RP discovery / realm validation
>> disabled;  (RealmVerifier.java [Thread-2])
>> * INFO  2016-10-17 22:01:13,701 SMS configuration not found
>> (DefaultSmsConfigurationManager.java [Thread-2])
>> * INFO  2016-10-17 22:01:13,828 Scheduled task with key:
>> fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java
>> [Thread-2])
>> * INFO  2016-10-17 22:01:13,829 Scheduled task with key:
>> dataStatisticsTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
>> * INFO  2016-10-17 22:01:13,841 Executing startup routine [1 of 14,
>> runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java
>> [Thread-2])
>> * INFO  2016-10-17 22:01:20,688 Executing startup routine [2 of 14,
>> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
>> [Thread-2])
>> * INFO  2016-10-17 22:01:20,739 Executing startup routine [3 of 14,
>> runlevel 3]: DataElementDefaultDimensionPopulator
>> (DefaultStartupRoutineExecutor.java [Thread-2])
>> * INFO  2016-10-17 22:01:20,876 'system-process' update
>> org.hisp.dhis.dataelement.DataElementCategory, name: default, uid:
>> vGs6omsRekv (AuditLogUtil.java [Thread-2])
>> * WARN  2016-10-17 22:01:21,256 SQL Error: 0, SQLState: 42703
>> (SqlExceptionHelper.java [Thread-2])
>> * ERROR 2016-10-17 22:01:21,257 ERROR: column usercreden1_.uid does not
>> exist
>>   Position: 756 (SqlExceptionHelper.java [Thread-2])
>> * ERROR 2016-10-17 22:01:21,265 org.hibernate.exception.SQLGrammarException:
>> could not extract ResultSet
>> at org.hibernate.exception.internal.SQLStateConversionDelegate.
>> convert(SQLStateConversionDelegate.java:106)
>> at org.hibernate.exception.internal.StandardSQLExceptionConvert
>> er.convert(StandardSQLExceptionConverter.java:42)
>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>> ExceptionHelper.java:111)
>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
>> ExceptionHelper.java:97)
>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extra
>> ct(ResultSetReturnImpl.java:79)
>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>> dLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>> dLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
>> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
>> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
>> at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntity
>> Loader.load(AbstractLoadPlanBasedEntityLoader.java:167)
>> at org.hibernate.persister.entity.AbstractEntityPersister.load(
>> AbstractEntityPersister.java:3991)
>> at org.hibernate.event.internal.DefaultLoadEventListener.loadFr
>> omDatasource(DefaultLoadEventListener.java:508)
>> at org.hibernate.event.internal.DefaultLoadEventListener.doLoad
>> (DefaultLoadEventListener.java:478)
>> at org.hibernate.event.internal.DefaultLoadEventListener.load(D
>> efaultLoadEventListener.java:219)
>> at org.hibernate.event.internal.DefaultLoadEventListener.proxyO
>> rLoad(DefaultLoadEventListener.java:262)
>> at org.hibernate.event.internal.DefaultLoadEventListener.doOnLo
>> ad(DefaultLoadEventListener.java:121)
>> at org.hibernate.event.internal.DefaultLoadEventListener.onLoad
>> (DefaultLoadEventListener.java:89)
>> at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1142)
>> at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.
>> java:1025)
>> at org.hibernate.type.EntityType.resolveIdentifier(EntityType.j
>> ava:632)
>> at org.hibernate.type.EntityType.resolve(EntityType.java:424)
>> at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntit
>> y(TwoPhaseLoad.java:151)
>> at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(
>> TwoPhaseLoad.java:125)
>> at org.hibernate.loader.Loader.initializeEntitiesAndCollections
>> (Loader.java:1132)
>> at

Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza

2016-10-23 Thread Morten Olav Hansen

Caused by: org.postgresql.util.PSQLException: ERROR: column
usercreden1_.uid does not exist

Maybe you should try and add that column manually?

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Tue, Oct 18, 2016 at 4:17 AM, Knut Staring  wrote:

> Any idea what the issue could be here with DHIS Live?
>
> -- Forwarded message --
>
> And this is conf/logs/dhis.log:
>
> * INFO  2016-10-17 22:01:09,926 Added root logger using file:
> /D:/skule/inf5750/dhis-live/conf\logs\dhis.log
> (Log4JLogConfigInitializer.java [Thread-2])
> * WARN  2016-10-17 22:01:10,947 RP discovery / realm validation disabled;
> (RealmVerifier.java [Thread-2])
> * INFO  2016-10-17 22:01:13,701 SMS configuration not found
> (DefaultSmsConfigurationManager.java [Thread-2])
> * INFO  2016-10-17 22:01:13,828 Scheduled task with key:
> fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java
> [Thread-2])
> * INFO  2016-10-17 22:01:13,829 Scheduled task with key:
> dataStatisticsTask and cron: 0 0 2 * * ? (SpringScheduler.java [Thread-2])
> * INFO  2016-10-17 22:01:13,841 Executing startup routine [1 of 14,
> runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java
> [Thread-2])
> * INFO  2016-10-17 22:01:20,688 Executing startup routine [2 of 14,
> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
> [Thread-2])
> * INFO  2016-10-17 22:01:20,739 Executing startup routine [3 of 14,
> runlevel 3]: DataElementDefaultDimensionPopulator
> (DefaultStartupRoutineExecutor.java [Thread-2])
> * INFO  2016-10-17 22:01:20,876 'system-process' update
> org.hisp.dhis.dataelement.DataElementCategory, name: default, uid:
> vGs6omsRekv (AuditLogUtil.java [Thread-2])
> * WARN  2016-10-17 22:01:21,256 SQL Error: 0, SQLState: 42703
> (SqlExceptionHelper.java [Thread-2])
> * ERROR 2016-10-17 22:01:21,257 ERROR: column usercreden1_.uid does not
> exist
>   Position: 756 (SqlExceptionHelper.java [Thread-2])
> * ERROR 2016-10-17 22:01:21,265 org.hibernate.exception.SQLGrammarException:
> could not extract ResultSet
> at org.hibernate.exception.internal.SQLStateConversionDelegate.
> convert(SQLStateConversionDelegate.java:106)
> at org.hibernate.exception.internal.StandardSQLExceptionConvert
> er.convert(StandardSQLExceptionConverter.java:42)
> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
> ExceptionHelper.java:111)
> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql
> ExceptionHelper.java:97)
> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extra
> ct(ResultSetReturnImpl.java:79)
> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
> dLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
> dLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
> at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBase
> dLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
> at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntity
> Loader.load(AbstractLoadPlanBasedEntityLoader.java:167)
> at org.hibernate.persister.entity.AbstractEntityPersister.load(
> AbstractEntityPersister.java:3991)
> at org.hibernate.event.internal.DefaultLoadEventListener.loadFr
> omDatasource(DefaultLoadEventListener.java:508)
> at org.hibernate.event.internal.DefaultLoadEventListener.doLoad
> (DefaultLoadEventListener.java:478)
> at org.hibernate.event.internal.DefaultLoadEventListener.load(D
> efaultLoadEventListener.java:219)
> at org.hibernate.event.internal.DefaultLoadEventListener.proxyO
> rLoad(DefaultLoadEventListener.java:262)
> at org.hibernate.event.internal.DefaultLoadEventListener.doOnLo
> ad(DefaultLoadEventListener.java:121)
> at org.hibernate.event.internal.DefaultLoadEventListener.onLoad
> (DefaultLoadEventListener.java:89)
> at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1142)
> at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.
> java:1025)
> at org.hibernate.type.EntityType.resolveIdentifier(EntityType.j
> ava:632)
> at org.hibernate.type.EntityType.resolve(EntityType.java:424)
> at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntit
> y(TwoPhaseLoad.java:151)
> at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(
> TwoPhaseLoad.java:125)
> at org.hibernate.loader.Loader.initializeEntitiesAndCollections
> (Loader.java:1132)
> at org.hibernate.loader.Loader.processResultSet(Loader.java:992)
> at org.hibernate.loader.Loader.doQuery(Loader.java:930)
> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyColle
> ctions(Loader.java:336)
> at org.hibernate.loader.Loader.doList(Loader.java:2610)
> at

Re: [Dhis2-users] [Dhis2-devs] GIS failing to load in 2.25

2016-10-23 Thread Morten Olav Hansen

Hi Sam

This is caused by the metadata having some issues I'm guessing... I would
try and have a look at the network panel (in the web inspector) to see
exactly which request it stops on.. since you are using Chrome, you should
be able to right click on the console and select "log XHR requests", that
will hopefully give you a clue to exactly which request is failing.

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Mon, Oct 17, 2016 at 9:37 PM, Sam Kasozi  wrote:

> Hi Lars, this is the original error message from an upgraded instance from
> 2.25.
>
> The developer console, gives the error below:
>
> ext-all.js:15 Uncaught You're trying to decode an invalid JSON String:
> Also in the attached./ Screen shot attached as well.
>
>
> P.s With the new instance, I could not access the orgunits; nor were they
> displaying as part of the maintenance, GIS module wasn't loading either -
> It would be good to try out from your end.
>
> regards,
>
>
> Sam Kasozi
> +256 788-993-565
> Skype: sam.kasoziug
>
> On Mon, Oct 17, 2016 at 4:44 PM, Lars Helge Øverland 
> wrote:
>
>>
>>
>> On Mon, Oct 17, 2016 at 3:42 PM, Sam Kasozi  wrote:
>>
>>> GIS is failing to load in a new instance of 2.25; not sure if this is a
>>> bug or whether some pre-configuration needs to happen.
>>>
>>> regards,
>>>
>>>
>>
>> Hi Sam,
>>
>> we need some more info, can you check in the browser developer console
>> and post output? If nothing there, tomcat log is helpful.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>>
>>
>>> Sam Kasozi
>>> +256 788-993-565
>>> Skype: sam.kasoziug
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org 
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] GIS 2.25

2016-10-23 Thread Calle Hedberg

Absalom,

You have installed postgis with pg 9.5.4?

Regards
Calle

On 22 October 2016 at 10:36, Absolom MURAMIRA  wrote:

> Dear All,
>
> I am testing release 2.25 and appreciate the developers' contribution to
> the good improvements to the DHIS2 application.
> Most of the apps are running well apart from the GIS app. It loads forever
> and cannot load its interface to enable me generate maps. Can someone
> please advise me if there is some configuration I need to enable first? I
> checked the demo site which is okay. the pivot tables and data visualizers
> are loading normally.
>
> The testing environment in Linux server 16.04 LTS and postgresql 9.5
>
> Thank you.
>
> Absolom
> Kigali
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza

Re: [Dhis2-users] [Dhis2-devs] GIS 2.25

Re: [Dhis2-users] [Dhis2-devs] GIS 2.25

Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza

Re: [Dhis2-users] Fwd: Activity Digest since 10:24PM for INF 5750 on Piazza

Re: [Dhis2-users] [Dhis2-devs] GIS failing to load in 2.25

Re: [Dhis2-users] [Dhis2-devs] GIS 2.25

9 matches

Site Navigation

Mail list logo

Footer information