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_gha...@hotmail.com] 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:knu...@gmail.com] 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_gha...@hotmail.com> wrote: Where could I find the such log and copy it in order to send it Regards, From: Knut Staring [mailto:knu...@gmail.com <javascript:_e(%7B%7D,'cvml','knu...@gmail.com');> ] 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_gha...@hotmail.com <javascript:_e(%7B%7D,'cvml','nami_gha...@hotmail.com');> > 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:knu...@gmail.com] 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_gha...@hotmail.com> 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@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
_______________________________________________ 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