Issue creating SQLviews

Dear DHIS2 Dev team,

When I try to generate the resource tables (build date:2015-02-28 02:06, ver 2.18), I get this error attached.

I checking to see if it is a bug.

sqlview-creation error.txt (44.7 KB)

···

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

I see the same thing as well, so likely a bug. In my case, it is

Version:
2.18
Build revision:
18194

···

On Sat, Feb 28, 2015 at 7:49 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear DHIS2 Dev team,

When I try to generate the resource tables (build date:2015-02-28 02:06, ver 2.18), I get this error attached.

I checking to see if it is a bug.


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "


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.pickering@gmail.com
tel:+46764147049

Dear Jason,

It is bug. I have used the 28 Feb,2015 builds on our test server which was running an old build and it also failed with the same error [SQL views].

The old build on the test server was functional.

Lars, how can obtain an old build lets #52 from the jerkins?

I tried this https://apps.dhis2.org/ci/job/dhis-2.18/52/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war and it failed

Please help us fix the issue as it affects the resource generation.

Thanks.

Alex

···

On Sat, Feb 28, 2015 at 10:44 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

I see the same thing as well, so likely a bug. In my case, it is

Version:
2.18
Build revision:
18194

On Sat, Feb 28, 2015 at 7:49 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear DHIS2 Dev team,

When I try to generate the resource tables (build date:2015-02-28 02:06, ver 2.18), I get this error attached.

I checking to see if it is a bug.


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "


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.pickering@gmail.com
tel:+46764147049

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

If you have Java, Maven and Bazaar installed you can install it by checking out this version and compiling

bzr branch -r 18215 lp:~dhis2-devs-core/dhis2/2.18

I’ve built the war file which you can find here for the next couple of days

https://www.dropbox.com/s/lvkocbt90dfxxk4/dhis.war?dl=0

Dan Cocos
BAO Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos

···

On Sat, Feb 28, 2015 at 10:44 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

I see the same thing as well, so likely a bug. In my case, it is

Version:
2.18
Build revision:
18194

On Sat, Feb 28, 2015 at 7:49 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear DHIS2 Dev team,

When I try to generate the resource tables (build date:2015-02-28 02:06, ver 2.18), I get this error attached.

I checking to see if it is a bug.


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "


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.pickering@gmail.com
tel:+46764147049

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Dan,

Thanks.

I should have thought of that. Probably I wanted a finished product!!!

Thanks again.

Alex

···

On Sun, Mar 1, 2015 at 3:11 AM, Dan Cocos dan@dancocos.com wrote:

If you have Java, Maven and Bazaar installed you can install it by checking out this version and compiling
bzr branch -r 18215 lp:~dhis2-devs-core/dhis2/2.18

I’ve built the war file which you can find here for the next couple of days

https://www.dropbox.com/s/lvkocbt90dfxxk4/dhis.war?dl=0

Dan Cocos
BAO Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos

On Feb 28, 2015, at 2:54 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Jason,

It is bug. I have used the 28 Feb,2015 builds on our test server which was running an old build and it also failed with the same error [SQL views].

The old build on the test server was functional.

Lars, how can obtain an old build lets #52 from the jerkins?

I tried this https://apps.dhis2.org/ci/job/dhis-2.18/52/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war and it failed

Please help us fix the issue as it affects the resource generation.

Thanks.

Alex


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

On Sat, Feb 28, 2015 at 10:44 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

I see the same thing as well, so likely a bug. In my case, it is

Version:
2.18
Build revision:
18194


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

On Sat, Feb 28, 2015 at 7:49 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear DHIS2 Dev team,

When I try to generate the resource tables (build date:2015-02-28 02:06, ver 2.18), I get this error attached.

I checking to see if it is a bug.


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "


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.pickering@gmail.com
tel:+46764147049

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Hi,

this bug should have been fixed and backported to 2.18 now.

Lars

Dear Lars,

Thank you for this.

The bug is fixed. I have tested it in 2.18 latest build.

image to the Dev team.

Alex

···

On Tue, Mar 3, 2015 at 8:20 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi,

this bug should have been fixed and backported to 2.18 now.

Lars

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Thanks Alex.

image

···

On Tue, Mar 3, 2015 at 8:20 PM, Lars Helge Øverland larshelge@gmail.com wrote:


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Hi,

this bug should have been fixed and backported to 2.18 now.

Lars