dhis2-users team mailing list archive

[Nami Ghadri <nami_ghadri@xxxxxxxxxxx>]

I did record this 

 

org.postgresql.util.PSQLException: error: relation "analytics_2015"donse not exist postion: 54

at org.postgresql.code.v3.queryexeutor[mp].receiveerrorresponse(queryexecutor[mp].java:2198)

at org.postgresql.code.v3.queryexeutor[mp].processresult(queryexecutor[mp.java:1927)

at org.postgresql.code.v3.queryexeutor[mp].execute(queryexecutor[mp].java:255)

at org.postgresql.jdbc2.abstractjdbc2$statement.execute(abstractjdbc2$statement.java:561)

 

I hope it could help analyzing 

 

Regards and thanks in advance

 

From: Nami Ghadri [mailto:nami_ghadri@xxxxxxxxxxx] 
Sent: Tuesday, September 8, 2015 11:25 AM
To: 'Knut Staring'
Cc: 'DHIS 2 Users list'
Subject: RE: [Dhis2-users] Analytics tables export

 

Ok I will try to find it

 

Thanks very much

 

 

From: Knut Staring [mailto:knutst@xxxxxxxxx] 
Sent: Tuesday, September 8, 2015 11:16 AM
To: Nami Ghadri
Cc: DHIS 2 Users list
Subject: Re: [Dhis2-users] Analytics tables export

 

In the tomcat directory on the server there is a folder called logs, I think. Others on the list can guide further, about to take off on a long flight here ;-)

On Tuesday, September 8, 2015, Nami Ghadri <nami_ghadri@xxxxxxxxxxx> wrote:

Where could I find the such log and copy it in order to send it

 

Regards,

 

 

From: Knut Staring [mailto:knutst@xxxxxxxxx <javascript:_e(%7B%7D,'cvml','knutst@xxxxxxxxx');> ] 
Sent: Tuesday, September 8, 2015 11:05 AM
To: Nami Ghadri
Cc: DHIS 2 Users list
Subject: Re: [Dhis2-users] Analytics tables export

 

That should  be a clear indicator something is going wrong. Please share the whole log (at least all the relevant parts).

On Tuesday, September 8, 2015, Nami Ghadri <nami_ghadri@xxxxxxxxxxx <javascript:_e(%7B%7D,'cvml','nami_ghadri@xxxxxxxxxxx');> > wrote:

I have 32 g ram  I think nothing related to it but I have a lot of category combos 

 

I also have log: that says : ERROR : relation “analytics table” analytics_2015 does not exists

 

Regards,

 

 

From: Knut Staring [mailto:knutst@xxxxxxxxx] 
Sent: Tuesday, September 8, 2015 10:20 AM
To: Nami Ghadri
Cc: DHIS 2 Users list
Subject: Re: [Dhis2-users] Analytics tables export

 

Not sure, but maybe it will be easier to judge if you can provide some more details about your server setup (ram), db size, as well as the log/screenshot which will show what parts of the process take how long?

On Sep 8, 2015 9:08 AM, "Nami Ghadri" <nami_ghadri@xxxxxxxxxxx> wrote:

Hello,

 

When performing Analytics tables update export it takes too long 

 

Is there is any way to make easier or less in time 

 

Regards,

 


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
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