date:20150730

[Dhis2-users] Aggregate Query Builder

2015-07-30 Thread channara rin

Hi all DHIS2,
Can we aggregate trackers' attributes/data elements in a whole year?

thank you
channara
___
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] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland

Hmm, yeah something doesn't seem right here. Not really familiar with the
detailed workings of the analytics table creation process, though (Lars
would be the one to ask). What's the schema for the left over
analytics_temp_2015? Also, can you make sure to (manually) delete the temp
table and re-run?

2015-07-30 16:53 GMT+02:00 Elmarie Claasen :

> Hi Halvdan,
>
>
>
> No the analytics is still failing. Here is the log.
>
>
>
> I don’t quite understand what is wrong. What I can see in the database is
> because analytics is failing the table Analytics_2015_temp remains after
> the analytics fails.
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to 
> disclai...@hisp.org
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
> *From:* Halvdan Grelland [mailto:halvda...@gmail.com]
> *Sent:* 30 July 2015 03:32 PM
> *To:* Elmarie Claasen
> *Cc:* Abyot Gizaw; DHIS 2 Developers list; dhis2-users@lists.launchpad.net
>
> *Subject:* Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker
> program after updating to 2.20 stable
>
>
>
> Hi,
>
>
>
> Yes, the first issue seems to be fixed (and there is no indication of
> faults in the log as you say). Why it didn't run properly before I don't
> know.
>
>
>
> As for the analytics: yes, analytics tables (named analytics_2014,
> analytics_2015 etc) er generated tables. If they do not exist, you might
> experience expections like the one posted. Analytics can be scheduled
> (recommended) to run regularly or triggered manually at
> https://your-dhis-server/dhis-web-reporting/displayDataMartForm.action
> (the process will take a lot of time to finish, depending on the server and
> the DB contents).
>
>
>
> Try to run an analytics update and try again. It will probably solve the
> issue.
>
>
>
> 2015-07-30 15:17 GMT+02:00 Elmarie Claasen :
>
> Hi Halvdan,
>
>
>
> I don’t see anything failing in the startup routine – here is the log of
> the first startup after the replaced the war file. Maybe the log should
> give an error if the tables was not successfully updated?
>
>
>
> Can you assist in how we fix the problem with the analytics table which
> still has an incorrect fieldname – “de” instead of “dx”.  The issue with
> the Program was resolved after running the script Abyot suggested but the
> analytics table is a temp table created during the analytics process or
> something since our db does not contain that table?
>
>
>
> 015-07-29 08:31:56,705 Executing startup routine [1 of 15, runlevel 1]: 
> InitTableAlteror
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,906 Executing startup routine [2 of 15,
> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,911 Executing startup routine [3 of 15,
> runlevel 2]: DataElementDefaultDimensionPopulator
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,961 Linked default category with default
> concept (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:57,171 Executing startup routine [4 of 15,
> runlevel 3]: TableAlteror (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,337 Tables updated (TableAlteror.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,337 Executing startup routine [5 of 15,
> runlevel 3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,704 Executing startup routine [6 of 15,
> runlevel 3]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,798 Executing startup routine [7 of 15,
> runlevel 4]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,640 Executing startup routine [8 of 15,
> runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,816 Executing startup routine [9 of 15,
> runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,880 Executing startup routine [10 of 15,
> runlevel 7]: MapViewUpgrader (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:3

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen

Hi Halvdan,

 

No the analytics is still failing. Here is the log.

 

I don’t quite understand what is wrong. What I can see in the database is 
because analytics is failing the table Analytics_2015_temp remains after the 
analytics fails.

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail:   elma...@hisp.org

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  
 
http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
disclaimer before opening any attachment or taking any other action in terms of 
this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to  
 disclai...@hisp.org and a copy will be provided to 
you. By replying to this e-mail or opening any attachment you agree to be bound 
by the provisions of the disclaimer. 

 

From: Halvdan Grelland [mailto:halvda...@gmail.com] 
Sent: 30 July 2015 03:32 PM
To: Elmarie Claasen
Cc: Abyot Gizaw; DHIS 2 Developers list; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after 
updating to 2.20 stable

 

Hi,

 

Yes, the first issue seems to be fixed (and there is no indication of faults in 
the log as you say). Why it didn't run properly before I don't know.

 

As for the analytics: yes, analytics tables (named analytics_2014, 
analytics_2015 etc) er generated tables. If they do not exist, you might 
experience expections like the one posted. Analytics can be scheduled 
(recommended) to run regularly or triggered manually at 
https://your-dhis-server/dhis-web-reporting/displayDataMartForm.action (the 
process will take a lot of time to finish, depending on the server and the DB 
contents).

 

Try to run an analytics update and try again. It will probably solve the issue.

 

2015-07-30 15:17 GMT+02:00 Elmarie Claasen :

Hi Halvdan,

 

I don’t see anything failing in the startup routine – here is the log of the 
first startup after the replaced the war file. Maybe the log should give an 
error if the tables was not successfully updated?

 

Can you assist in how we fix the problem with the analytics table which still 
has an incorrect fieldname – “de” instead of “dx”.  The issue with the Program 
was resolved after running the script Abyot suggested but the analytics table 
is a temp table created during the analytics process or something since our db 
does not contain that table?

 

015-07-29 08:31:56,705 Executing startup routine [1 of 15, runlevel 1]: 
InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:31:56,906 Executing startup routine [2 of 15, runlevel 
2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:31:56,911 Executing startup routine [3 of 15, runlevel 
2]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:31:56,961 Linked default category with default concept 
(DataElementDefaultDimensionPopulator.java [localhost-startStop-1])

* INFO  2015-07-29 08:31:57,171 Executing startup routine [4 of 15, runlevel 
3]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:01,337 Tables updated (TableAlteror.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:01,337 Executing startup routine [5 of 15, runlevel 
3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:01,704 Executing startup routine [6 of 15, runlevel 
3]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:01,798 Executing startup routine [7 of 15, runlevel 
4]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:05,640 Executing startup routine [8 of 15, runlevel 
4]: IdentityPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:05,816 Executing startup routine [9 of 15, runlevel 
5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:05,880 Executing startup routine [10 of 15, runlevel 
7]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:05,973 Executing startup routine [11 of 15, runlevel 
7]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,032 Update done, dropped table 
reporttable_indicators (FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,041 Update done, dropped table 
reporttable_dataelements (FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland

Hi,

Yes, the first issue seems to be fixed (and there is no indication of
faults in the log as you say). Why it didn't run properly before I don't
know.

As for the analytics: yes, analytics tables (named analytics_2014,
analytics_2015 etc) er generated tables. If they do not exist, you might
experience expections like the one posted. Analytics can be scheduled
(recommended) to run regularly or triggered manually at
https://your-dhis-server/dhis-web-reporting/displayDataMartForm.action (the
process will take a lot of time to finish, depending on the server and the
DB contents).

Try to run an analytics update and try again. It will probably solve the
issue.

2015-07-30 15:17 GMT+02:00 Elmarie Claasen :

> Hi Halvdan,
>
>
>
> I don’t see anything failing in the startup routine – here is the log of
> the first startup after the replaced the war file. Maybe the log should
> give an error if the tables was not successfully updated?
>
>
>
> Can you assist in how we fix the problem with the analytics table which
> still has an incorrect fieldname – “de” instead of “dx”.  The issue with
> the Program was resolved after running the script Abyot suggested but the
> analytics table is a temp table created during the analytics process or
> something since our db does not contain that table?
>
>
>
> 015-07-29 08:31:56,705 Executing startup routine [1 of 15, runlevel 1]: 
> InitTableAlteror
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,906 Executing startup routine [2 of 15,
> runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,911 Executing startup routine [3 of 15,
> runlevel 2]: DataElementDefaultDimensionPopulator
> (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:56,961 Linked default category with default
> concept (DataElementDefaultDimensionPopulator.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:31:57,171 Executing startup routine [4 of 15,
> runlevel 3]: TableAlteror (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,337 Tables updated (TableAlteror.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,337 Executing startup routine [5 of 15,
> runlevel 3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,704 Executing startup routine [6 of 15,
> runlevel 3]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:01,798 Executing startup routine [7 of 15,
> runlevel 4]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,640 Executing startup routine [8 of 15,
> runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,816 Executing startup routine [9 of 15,
> runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,880 Executing startup routine [10 of 15,
> runlevel 7]: MapViewUpgrader (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:05,973 Executing startup routine [11 of 15,
> runlevel 7]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,032 Update done, dropped table
> reporttable_indicators (FavoriteDataItemUpgrader.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,041 Update done, dropped table
> reporttable_dataelements (FavoriteDataItemUpgrader.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,045 Update done, dropped table
> reporttable_dataelementoperands (FavoriteDataItemUpgrader.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,049 Update done, dropped table
> reporttable_datasets (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,057 Update done, dropped table
> chart_indicators (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,061 Update done, dropped table
> chart_dataelements (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,065 Update done, dropped table
> chart_dataelementoperands (FavoriteDataItemUpgrader.java
> [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,069 Update done, dropped table chart_datasets
> (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,073 Update done, dropped table
> mapview_indicators (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,076 Update done, dropped table
> mapview_dataelements (FavoriteDataItemUpgrader.java [localhost-startStop-1])
>
> * INFO  2015-07-29 08:32:06,080 Update done, dropped table
> mapview_dataelementoperands (FavoriteDataItemUpgrader.java
> [l

Re: [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Abyot Gizaw

May be. I don't think you can alter a table while you have views or user
defined functions referring to the table.

On Thu, Jul 30, 2015 at 1:33 PM Elmarie Claasen  wrote:

> Thanks a lot Abyot,
>
>
>
> We ran this script after deleting 2 sql views which referenced this table
> as it would not run until we deleted the 2 sql views. A follow up question
> –could it be that this change did not execute because of the 2 sql views?
> We know that dhis2 drops sql views before running analytics but does it
> check/drop sql views before making changes to tables?
>
>
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to 
> disclai...@hisp.org
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
> *From:* Abyot Gizaw [mailto:aby...@gmail.com]
> *Sent:* 30 July 2015 12:59 PM
> *To:* Elmarie Claasen; dhis2-d...@lists.launchpad.net;
> dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] FW: Problem with Tracker program after
> updating to 2.20 stable
>
>
>
>
>
> On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen  wrote:
>
> Hi Devs,
>
>
>
> I have an urgent database issue which I have to resolve as this project is
> implementing by Monday and my database is not running on 2.20 stable which
> I need for the tracker capture app to load. Can someone please assist.
>
>
>
> We have a database called ISHP which Erling has been helping us to set up
> the Tracker capture app for implementation.
>
> Since the app could only connect to 2.20 we upgraded our training database
> some time ago to 2.20 snapshot build revision 19527 and also kept the
> program changes we made updated in 2.19 live version since we couldn’t risk
> updating a live database when we did not know what the implications would
> be.
>
>
>
> We now wanting to update the 2.19 Live database to 2.20 which we did on
> our development instance but get the following errors which does not allow
> us to
>
>
>
> 1.  access the program in the UI or via the tracker capture app (see
> open program error log) The problem seems to be that the programtype in
> our database is Integer while in other 2.20 instances it is char varying.
> The update script from 2.19>2.20 does not contain anything changing this so
> how do I deal with this please…
>
>
>
> This was supposed to be handled internally in the code.
>
>
>
> try to alter manually and see what happens
>
>
>
> ALTER TABLE program ALTER COLUMN "type" TYPE varchar(255);
>
>
>
>
>
> 2.  analytics is failing due to fieldname error   (see detailed
> analytics error log attached but here is a short version) The problem is
> that the temp table has a fieldname called de instead of dx – again
> something I don’t know how it happens or how to fix
>
>
>
> *Caused by: org.springframework.jdbc.BadSqlGrammarException:
> StatementCallback; bad SQL grammar [update analytics_temp_2015 set
> "uidlevel1" = null,"uidlevel2" = null,"uidlevel3" = null,"uidlevel4" =
> null,"uidlevel5" = null where level > 5 and de in ('jx6lCxe8gYy',
> 'cjA6JH0kC9B')]; nested exception is org.postgresql.util.PSQLException:
> ERROR: column "de" does not exist*
>
> We checked our other 2.20 databases and the column name is dx but we don’t
> know how to fix this – please help!
>
>
>
> The program we are accessing on 2.19, 2.20 stable and 2.20 snapshot
> Version: Build revision: 19527 Build date: 2015-07-01 08:47 is all set up
> exactly the same way and I don’t see why one would be able to open the
> program, open tracker capture in the UI and log in on tracker capture app
> only on the 2.20 snapshot version and not on 2.20 stable. Can you please
> assist us with what is wrong?
>
>
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to 
> disclai...@hisp.org
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
>
>
> *This me

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen

Hi Halvdan,

 

I don’t see anything failing in the startup routine – here is the log of the 
first startup after the replaced the war file. Maybe the log should give an 
error if the tables was not successfully updated?

 

Can you assist in how we fix the problem with the analytics table which still 
has an incorrect fieldname – “de” instead of “dx”.  The issue with the Program 
was resolved after running the script Abyot suggested but the analytics table 
is a temp table created during the analytics process or something since our db 
does not contain that table?

 

015-07-29 08:31:56,705 Executing startup routine [1 of 15, runlevel 1]: 
InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:31:56,906 Executing startup routine [2 of 15, runlevel 
2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:31:56,911 Executing startup routine [3 of 15, runlevel 
2]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:31:56,961 Linked default category with default concept 
(DataElementDefaultDimensionPopulator.java [localhost-startStop-1])

* INFO  2015-07-29 08:31:57,171 Executing startup routine [4 of 15, runlevel 
3]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:01,337 Tables updated (TableAlteror.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:01,337 Executing startup routine [5 of 15, runlevel 
3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:01,704 Executing startup routine [6 of 15, runlevel 
3]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:01,798 Executing startup routine [7 of 15, runlevel 
4]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:05,640 Executing startup routine [8 of 15, runlevel 
4]: IdentityPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:05,816 Executing startup routine [9 of 15, runlevel 
5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:05,880 Executing startup routine [10 of 15, runlevel 
7]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:05,973 Executing startup routine [11 of 15, runlevel 
7]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,032 Update done, dropped table 
reporttable_indicators (FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,041 Update done, dropped table 
reporttable_dataelements (FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,045 Update done, dropped table 
reporttable_dataelementoperands (FavoriteDataItemUpgrader.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,049 Update done, dropped table reporttable_datasets 
(FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,057 Update done, dropped table chart_indicators 
(FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,061 Update done, dropped table chart_dataelements 
(FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,065 Update done, dropped table 
chart_dataelementoperands (FavoriteDataItemUpgrader.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,069 Update done, dropped table chart_datasets 
(FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,073 Update done, dropped table mapview_indicators 
(FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,076 Update done, dropped table mapview_dataelements 
(FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,080 Update done, dropped table 
mapview_dataelementoperands (FavoriteDataItemUpgrader.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,083 Update done, dropped table mapview_datasets 
(FavoriteDataItemUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,189 Executing startup routine [12 of 15, runlevel 
7]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,191 Upgraded custom case entry form identifiers 
(DataEntryFormUpgrader.java [localhost-startStop-1])

* INFO  2015-07-29 08:32:06,193 Executing startup routine [13 of 15, runlevel 
8]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,214 Executing startup routine [14 of 15, runlevel 
9]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java 
[localhost-startStop-1])

* INFO  2015-07-29 08:32:06,218 Executing startup routin

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland

In addition; please look at the startup log of dhis2 (specifically under
InitTableAlterator) and see if there's any queries failing.

2015-07-30 12:59 GMT+02:00 Abyot Gizaw :

>
>
> On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen  wrote:
>
>> Hi Devs,
>>
>>
>>
>> I have an urgent database issue which I have to resolve as this project
>> is implementing by Monday and my database is not running on 2.20 stable
>> which I need for the tracker capture app to load. Can someone please assist.
>>
>>
>>
>> We have a database called ISHP which Erling has been helping us to set up
>> the Tracker capture app for implementation.
>>
>> Since the app could only connect to 2.20 we upgraded our training
>> database some time ago to 2.20 snapshot build revision 19527 and also
>> kept the program changes we made updated in 2.19 live version since we
>> couldn’t risk updating a live database when we did not know what the
>> implications would be.
>>
>>
>>
>> We now wanting to update the 2.19 Live database to 2.20 which we did on
>> our development instance but get the following errors which does not allow
>> us to
>>
>>
>>
>> 1.  access the program in the UI or via the tracker capture app (see
>> open program error log) The problem seems to be that the programtype in
>> our database is Integer while in other 2.20 instances it is char varying.
>> The update script from 2.19>2.20 does not contain anything changing this so
>> how do I deal with this please…
>>
>>
> This was supposed to be handled internally in the code.
>
> try to alter manually and see what happens
>
> ALTER TABLE program ALTER COLUMN "type" TYPE varchar(255);
>
>
>>
>>
>> 2.  analytics is failing due to fieldname error   (see detailed
>> analytics error log attached but here is a short version) The problem is
>> that the temp table has a fieldname called de instead of dx – again
>> something I don’t know how it happens or how to fix
>>
>>
>>
>> *Caused by: org.springframework.jdbc.BadSqlGrammarException:
>> StatementCallback; bad SQL grammar [update analytics_temp_2015 set
>> "uidlevel1" = null,"uidlevel2" = null,"uidlevel3" = null,"uidlevel4" =
>> null,"uidlevel5" = null where level > 5 and de in ('jx6lCxe8gYy',
>> 'cjA6JH0kC9B')]; nested exception is org.postgresql.util.PSQLException:
>> ERROR: column "de" does not exist*
>>
>> We checked our other 2.20 databases and the column name is dx but we
>> don’t know how to fix this – please help!
>>
>>
>>
>> The program we are accessing on 2.19, 2.20 stable and 2.20 snapshot Version:
>> Build revision: 19527 Build date: 2015-07-01 08:47 is all set up exactly
>> the same way and I don’t see why one would be able to open the program,
>> open tracker capture in the UI and log in on tracker capture app only on
>> the 2.20 snapshot version and not on 2.20 stable. Can you please assist us
>> with what is wrong?
>>
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Elmarie Claasen*
>>
>> [image: Hisp logo]
>>
>> Project Manager
>>
>> Health Information Systems Program
>>
>> Tel:  041-367 1027
>>
>> Cell: 082 374 2209
>>
>> E-mail: elma...@hisp.org
>>
>> Skype:  elmarie.claasen52
>>
>>
>>
>>
>>
>> This message and any attachments are subject to a disclaimer published at 
>> http://www.hisp.org/policies.html#comms_disclaimer
>> .   Please read the disclaimer before opening any attachment or taking
>> any other action in terms of this electronic transmission.
>> If you cannot access the disclaimer, kindly send an email to 
>> disclai...@hisp.org
>> and a copy will be provided to you. By replying to this e-mail or opening
>> any attachment you agree to be bound by the provisions of the disclaimer.
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> .  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclai...@hisp.org
>>  and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>> ___
>> 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
>>
> --
> 
> Thank you,
> Abyot
>
> ___
> 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

Re: [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen

Thanks a lot Abyot, 

 

We ran this script after deleting 2 sql views which referenced this table as it 
would not run until we deleted the 2 sql views. A follow up question –could it 
be that this change did not execute because of the 2 sql views? We know that 
dhis2 drops sql views before running analytics but does it check/drop sql views 
before making changes to tables?

 

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail:   elma...@hisp.org

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  
 
http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
disclaimer before opening any attachment or taking any other action in terms of 
this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to  
 disclai...@hisp.org and a copy will be provided to 
you. By replying to this e-mail or opening any attachment you agree to be bound 
by the provisions of the disclaimer. 

 

From: Abyot Gizaw [mailto:aby...@gmail.com] 
Sent: 30 July 2015 12:59 PM
To: Elmarie Claasen; dhis2-d...@lists.launchpad.net; 
dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] FW: Problem with Tracker program after updating to 
2.20 stable

 

 

On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen  wrote:

Hi Devs,

 

I have an urgent database issue which I have to resolve as this project is 
implementing by Monday and my database is not running on 2.20 stable which I 
need for the tracker capture app to load. Can someone please assist.

 

We have a database called ISHP which Erling has been helping us to set up the 
Tracker capture app for implementation. 

Since the app could only connect to 2.20 we upgraded our training database some 
time ago to 2.20 snapshot build revision 19527 and also kept the program 
changes we made updated in 2.19 live version since we couldn’t risk updating a 
live database when we did not know what the implications would be. 

 

We now wanting to update the 2.19 Live database to 2.20 which we did on our 
development instance but get the following errors which does not allow us to 

 

1.  access the program in the UI or via the tracker capture app (see open 
program error log) The problem seems to be that the programtype in our database 
is Integer while in other 2.20 instances it is char varying. The update script 
from 2.19>2.20 does not contain anything changing this so how do I deal with 
this please…

 

This was supposed to be handled internally in the code.

 

try to alter manually and see what happens

 

ALTER TABLE program ALTER COLUMN "type" TYPE varchar(255);

 

 

2.  analytics is failing due to fieldname error   (see detailed analytics 
error log attached but here is a short version) The problem is that the temp 
table has a fieldname called de instead of dx – again something I don’t know 
how it happens or how to fix

 

Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; 
bad SQL grammar [update analytics_temp_2015 set "uidlevel1" = null,"uidlevel2" 
= null,"uidlevel3" = null,"uidlevel4" = null,"uidlevel5" = null where level > 5 
and de in ('jx6lCxe8gYy', 'cjA6JH0kC9B')]; nested exception is 
org.postgresql.util.PSQLException: ERROR: column "de" does not exist

We checked our other 2.20 databases and the column name is dx but we don’t know 
how to fix this – please help!

 

The program we are accessing on 2.19, 2.20 stable and 2.20 snapshot Version: 
Build revision: 19527 Build date: 2015-07-01 08:47 is all set up exactly the 
same way and I don’t see why one would be able to open the program, open 
tracker capture in the UI and log in on tracker capture app only on the 2.20 
snapshot version and not on 2.20 stable. Can you please assist us with what is 
wrong?

 

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail:   elma...@hisp.org

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  
 
http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
disclaimer before opening any attachment or taking any other action in terms of 
this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to  
 disclai...@hisp.org and a copy will be provided to 
you. By replying to this e-mail or opening any attachment you agree to be bound 
by the provisions of the disclaimer. 

 

 

This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attac

Re: [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Abyot Gizaw

On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen  wrote:

> Hi Devs,
>
>
>
> I have an urgent database issue which I have to resolve as this project is
> implementing by Monday and my database is not running on 2.20 stable which
> I need for the tracker capture app to load. Can someone please assist.
>
>
>
> We have a database called ISHP which Erling has been helping us to set up
> the Tracker capture app for implementation.
>
> Since the app could only connect to 2.20 we upgraded our training database
> some time ago to 2.20 snapshot build revision 19527 and also kept the
> program changes we made updated in 2.19 live version since we couldn’t risk
> updating a live database when we did not know what the implications would
> be.
>
>
>
> We now wanting to update the 2.19 Live database to 2.20 which we did on
> our development instance but get the following errors which does not allow
> us to
>
>
>
> 1.  access the program in the UI or via the tracker capture app (see
> open program error log) The problem seems to be that the programtype in
> our database is Integer while in other 2.20 instances it is char varying.
> The update script from 2.19>2.20 does not contain anything changing this so
> how do I deal with this please…
>
>
This was supposed to be handled internally in the code.

try to alter manually and see what happens

ALTER TABLE program ALTER COLUMN "type" TYPE varchar(255);


>
>
> 2.  analytics is failing due to fieldname error   (see detailed
> analytics error log attached but here is a short version) The problem is
> that the temp table has a fieldname called de instead of dx – again
> something I don’t know how it happens or how to fix
>
>
>
> *Caused by: org.springframework.jdbc.BadSqlGrammarException:
> StatementCallback; bad SQL grammar [update analytics_temp_2015 set
> "uidlevel1" = null,"uidlevel2" = null,"uidlevel3" = null,"uidlevel4" =
> null,"uidlevel5" = null where level > 5 and de in ('jx6lCxe8gYy',
> 'cjA6JH0kC9B')]; nested exception is org.postgresql.util.PSQLException:
> ERROR: column "de" does not exist*
>
> We checked our other 2.20 databases and the column name is dx but we don’t
> know how to fix this – please help!
>
>
>
> The program we are accessing on 2.19, 2.20 stable and 2.20 snapshot Version:
> Build revision: 19527 Build date: 2015-07-01 08:47 is all set up exactly
> the same way and I don’t see why one would be able to open the program,
> open tracker capture in the UI and log in on tracker capture app only on
> the 2.20 snapshot version and not on 2.20 stable. Can you please assist us
> with what is wrong?
>
>
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to 
> disclai...@hisp.org
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> .  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
> ___
> 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
>
-- 

Thank you,
Abyot
___
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

[Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen

Hi Devs,

 

I have an urgent database issue which I have to resolve as this project is
implementing by Monday and my database is not running on 2.20 stable which I
need for the tracker capture app to load. Can someone please assist.

 

We have a database called ISHP which Erling has been helping us to set up
the Tracker capture app for implementation. 

Since the app could only connect to 2.20 we upgraded our training database
some time ago to 2.20 snapshot build revision 19527 and also kept the
program changes we made updated in 2.19 live version since we couldn't risk
updating a live database when we did not know what the implications would
be. 

 

We now wanting to update the 2.19 Live database to 2.20 which we did on our
development instance but get the following errors which does not allow us to


 

1.  access the program in the UI or via the tracker capture app (see
open program error log) The problem seems to be that the programtype in our
database is Integer while in other 2.20 instances it is char varying. The
update script from 2.19>2.20 does not contain anything changing this so how
do I deal with this please.

 

2.  analytics is failing due to fieldname error   (see detailed
analytics error log attached but here is a short version) The problem is
that the temp table has a fieldname called de instead of dx - again
something I don't know how it happens or how to fix

 

Caused by: org.springframework.jdbc.BadSqlGrammarException:
StatementCallback; bad SQL grammar [update analytics_temp_2015 set
"uidlevel1" = null,"uidlevel2" = null,"uidlevel3" = null,"uidlevel4" =
null,"uidlevel5" = null where level > 5 and de in ('jx6lCxe8gYy',
'cjA6JH0kC9B')]; nested exception is org.postgresql.util.PSQLException:
ERROR: column "de" does not exist

We checked our other 2.20 databases and the column name is dx but we don't
know how to fix this - please help!

 

The program we are accessing on 2.19, 2.20 stable and 2.20 snapshot Version:
Build revision: 19527 Build date: 2015-07-01 08:47 is all set up exactly the
same way and I don't see why one would be able to open the program, open
tracker capture in the UI and log in on tracker capture app only on the 2.20
snapshot version and not on 2.20 stable. Can you please assist us with what
is wrong?

 

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail:   elma...@hisp.org

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at

http://www.hisp.org/policies.html#comms_disclaimer .   Please read the
disclaimer before opening any attachment or taking any other action in terms
of this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to
 disclai...@hisp.org and a copy will be provided
to you. By replying to this e-mail or opening any attachment you agree to be
bound by the provisions of the disclaimer. 

 


-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
* INFO  2015-07-29 12:53:45,703 [Level: INFO, category: DATAMART, time: Wed Jul 
29 12:53:45 SAST 2015, message: Analytics table update process started] 
(InMemoryNotifier.java [taskScheduler-2])
* INFO  2015-07-29 12:53:45,754 [Level: INFO, category: DATAMART, time: Wed Jul 
29 12:53:45 SAST 2015, message: Updating resource tables] 
(InMemoryNotifier.java [taskScheduler-2])
* INFO  2015-07-29 12:53:45,773 Using 5 organisation unit levels for org unit 
structure table (DefaultResourceTableService.java [taskScheduler-2])
* INFO  2015-07-29 12:53:45,784 Create organisation unit structure table SQL: 
CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY 
KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, 
"uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), 
"idlevel3" INTEGER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" 
CHARACTER(11), "idlevel5" INTEGER, "uidlevel5" CHARACTER(11)); 
(JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2015-07-29 12:53:47,319 Organisation unit structure table generated 
(DefaultResourceTableService.java [taskScheduler-2])
* INFO  2015-07-29 12:53:47,468 Create category option combo name table SQL: 
CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL 
PRIMARY KEY, categoryoptioncomb

[Dhis2-users] Aggregate Query Builder

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

Re: [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

Re: [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

Re: [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

[Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

10 matches

Site Navigation

Mail list logo

Footer information