Error in Analytics

Dears all,

I have Error in Analytics recently after I added some tracker data element to programs and updated ‘ACTIVE’ stages to ‘COMPLETED’ from database

Dhis2 version: 2.26

Build revision: b9e629d

Database: PostgreSQL

Server: Linux

I don’t know I that’s the reason or not, also when analytics was working well in 2.25 and I tried to upgrade to 2.26 I had the same error.

Any ideas?

Here is the error image

Screen Clipping

Regards,

Abdul karim

Hello Abdul Karim,

You probably have an error message in your Tomcat server log also. Please share that one.

Regards,

Knut

image

···

On Thu, Feb 9, 2017 at 11:12 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

Dears all,

I have Error in Analytics recently after I added some tracker data element to programs and updated ‘ACTIVE’ stages to ‘COMPLETED’ from database

Dhis2 version: 2.26

Build revision: b9e629d

Database: PostgreSQL

Server: Linux

I don’t know I that’s the reason or not, also when analytics was working well in 2.25 and I tried to upgrade to 2.26 I had the same error.

Any ideas?

Here is the error image

Regards,

Abdul karim


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Dear Knut,

Kindly find the attachments that images from server tomcat with hundred null values as you can see

Regards,

Abdulkarim

···

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Thursday, February 9, 2017 1:20 PM
To: Abdul karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Error in Analytics

Hello Abdul Karim,

You probably have an error message in your Tomcat server log also. Please share that one.

Regards,

Knut

On Thu, Feb 9, 2017 at 11:12 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

Dears all,

I have Error in Analytics recently after I added some tracker data element to programs and updated ‘ACTIVE’ stages to ‘COMPLETED’ from database

Dhis2 version: 2.26

Build revision: b9e629d

Database: PostgreSQL

Server: Linux

I don’t know I that’s the reason or not, also when analytics was working well in 2.25 and I tried to upgrade to 2.26 I had the same error.

Any ideas?

Here is the error image

Screen Clipping

Regards,

Abdul karim


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Dear Kunt,

For you kindly reminder,

We ‘re in huge problem because there is an important event data need daily monitoring and we can’t extract new event data.

any ideas or suggestions.

Regards,

Abdulkarim,

image

···

From: Abdul karim Jaafar [mailto:abdulkarim.jaafar87@gmail.com]
Sent: Thursday, February 9, 2017 2:01 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Error in Analytics

Dear Knut,

Kindly find the attachments that images from server tomcat with hundred null values as you can see

Regards,

Abdulkarim

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Thursday, February 9, 2017 1:20 PM
To: Abdul karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Error in Analytics

Hello Abdul Karim,

You probably have an error message in your Tomcat server log also. Please share that one.

Regards,

Knut

On Thu, Feb 9, 2017 at 11:12 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

Dears all,

I have Error in Analytics recently after I added some tracker data element to programs and updated ‘ACTIVE’ stages to ‘COMPLETED’ from database

Dhis2 version: 2.26

Build revision: b9e629d

Database: PostgreSQL

Server: Linux

I don’t know I that’s the reason or not, also when analytics was working well in 2.25 and I tried to upgrade to 2.26 I had the same error.

Any ideas?

Here is the error image

Screen Clipping

Regards,

Abdul karim


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Dear Abludkraim,

Unfortunately, I don’t know what might be the issue - hopefully someone else on the list will have an idea.

Knut

image

···

On Mon, Feb 13, 2017 at 7:17 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

Dear Kunt,

For you kindly reminder,

We ‘re in huge problem because there is an important event data need daily monitoring and we can’t extract new event data.

any ideas or suggestions.

Regards,

Abdulkarim,

From: Abdul karim Jaafar [mailto:abdulkarim.jaafar87@gmail.com]
Sent: Thursday, February 9, 2017 2:01 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Error in Analytics

Dear Knut,

Kindly find the attachments that images from server tomcat with hundred null values as you can see

Regards,

Abdulkarim

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Thursday, February 9, 2017 1:20 PM
To: Abdul karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Error in Analytics

Hello Abdul Karim,

You probably have an error message in your Tomcat server log also. Please share that one.

Regards,

Knut

On Thu, Feb 9, 2017 at 11:12 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

Dears all,

I have Error in Analytics recently after I added some tracker data element to programs and updated ‘ACTIVE’ stages to ‘COMPLETED’ from database

Dhis2 version: 2.26

Build revision: b9e629d

Database: PostgreSQL

Server: Linux

I don’t know I that’s the reason or not, also when analytics was working well in 2.25 and I tried to upgrade to 2.26 I had the same error.

Any ideas?

Here is the error image

Regards,

Abdul karim


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Dears,

I found the query that contains the error, by applying this query in PostgreSQL I get the same error message

Query and error message in attachments

Regards,

Abdulkarim

errormessage.txt (24.3 KB)

erroranalytics.sql (421 KB)

···

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Monday, February 13, 2017 11:02 AM
To: Abdul karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Error in Analytics

Dear Abludkraim,

Unfortunately, I don’t know what might be the issue - hopefully someone else on the list will have an idea.

Knut

On Mon, Feb 13, 2017 at 7:17 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

Dear Kunt,

For you kindly reminder,

We ‘re in huge problem because there is an important event data need daily monitoring and we can’t extract new event data.

any ideas or suggestions.

Regards,

Abdulkarim,

From: Abdul karim Jaafar [mailto:abdulkarim.jaafar87@gmail.com]
Sent: Thursday, February 9, 2017 2:01 PM
To: ‘Knut Staring’ knutst@gmail.com
Cc: ‘DHIS 2 Users list’ dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Error in Analytics

Dear Knut,

Kindly find the attachments that images from server tomcat with hundred null values as you can see

Regards,

Abdulkarim

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Thursday, February 9, 2017 1:20 PM
To: Abdul karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Error in Analytics

Hello Abdul Karim,

You probably have an error message in your Tomcat server log also. Please share that one.

Regards,

Knut

On Thu, Feb 9, 2017 at 11:12 AM, Abdul karim Jaafar abdulkarim.jaafar87@gmail.com wrote:

Dears all,

I have Error in Analytics recently after I added some tracker data element to programs and updated ‘ACTIVE’ stages to ‘COMPLETED’ from database

Dhis2 version: 2.26

Build revision: b9e629d

Database: PostgreSQL

Server: Linux

I don’t know I that’s the reason or not, also when analytics was working well in 2.25 and I tried to upgrade to 2.26 I had the same error.

Any ideas?

Here is the error image

Screen Clipping

Regards,

Abdul karim


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org