Analytics Error

Dear All,
I created a test instance but analytics takes time to run and doesn't
complete. The error below was found in the catalina.out file during
analytics:

Caused by: org.Postgresql.util.PSQLException: ERROR: relation
"analytics_completenesstarget" does not exist
Postion: 51

Please find the screen print after analytics failed.

image

···

--
Regards,

Gerald

Dear all,
I finally got it to successfully run but it took almost 4 hours for it
to ran completely after tweaking the postgresql.conf file based on the
explanations on the implementation manual.

Now, my question will be how can i reduce time for analytics giving
that my RAM is 7168 MB, 150 GB disk space.

image

···

On 5/28/17, gerald thomas <gerald17006@gmail.com> wrote:

Dear All,
I created a test instance but analytics takes time to run and doesn't
complete. The error below was found in the catalina.out file during
analytics:

Caused by: org.Postgresql.util.PSQLException: ERROR: relation
"analytics_completenesstarget" does not exist
Postion: 51

Please find the screen print after analytics failed.

--
Regards,

Gerald

--
Regards,

Gerald

Dear Gerald,

The picture you sent only shows the last 20 steps or so, and indicates that they took only a second. Are you able to see which earlier steps took so much longer?

Knut

···

On Sun, May 28, 2017 at 3:23 PM, gerald thomas gerald17006@gmail.com wrote:

Dear all,

I finally got it to successfully run but it took almost 4 hours for it

to ran completely after tweaking the postgresql.conf file based on the

explanations on the implementation manual.

Now, my question will be how can i reduce time for analytics giving

that my RAM is 7168 MB, 150 GB disk space.

On 5/28/17, gerald thomas gerald17006@gmail.com wrote:

Dear All,

I created a test instance but analytics takes time to run and doesn’t

complete. The error below was found in the catalina.out file during

analytics:

Caused by: org.Postgresql.util.PSQLException: ERROR: relation

“analytics_completenesstarget” does not exist

Postion: 51

Please find the screen print after analytics failed.

Regards,

Gerald

Regards,

Gerald


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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Dear Knut,
Please find the attached copy of the full process.

Analytics Process.txt (2.68 KB)

···

On May 28, 2017 14:49, "Knut Staring" <knutst@gmail.com> wrote:

Dear Gerald,

The picture you sent only shows the last 20 steps or so, and indicates that they took only a second. Are you able to see which earlier steps took so much longer?

Knut

On Sun, May 28, 2017 at 3:23 PM, gerald thomas <gerald17006@gmail.com> wrote:

Dear all,
I finally got it to successfully run but it took almost 4 hours for it
to ran completely after tweaking the postgresql.conf file based on the
explanations on the implementation manual.

Now, my question will be how can i reduce time for analytics giving
that my RAM is 7168 MB, 150 GB disk space.

On 5/28/17, gerald thomas <gerald17006@gmail.com> wrote:
> Dear All,
> I created a test instance but analytics takes time to run and doesn't
> complete. The error below was found in the catalina.out file during
> analytics:
>
> Caused by: org.Postgresql.util.PSQLException: ERROR: relation
> "analytics_completenesstarget" does not exist
> Postion: 51
>
> Please find the screen print after analytics failed.
>
> --
> Regards,
>
> Gerald
>

--
Regards,

Gerald

_______________________________________________
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

--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org