Dear Knut, Please find the attached copy of the full process.
On May 28, 2017 14:49, "Knut Staring" <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 : [email protected] >> 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
2017-05-28 12:58:43 Analytics tables updated: 03:53:14.237 2017-05-28 12:58:43 No events exist, not updating event analytics tables 2017-05-28 12:58:43 Updating tables: ENROLLMENT 2017-05-28 12:58:43 No events exist, not updating event analytics tables 2017-05-28 12:58:43 Updating tables: EVENT 2017-05-28 12:58:43 Table update done 2017-05-28 12:58:43 Clearing caches 2017-05-28 12:58:43 Creating SQL views 2017-05-28 12:58:43 Swapping tables 2017-05-28 12:58:43 Swapping analytics tables 2017-05-28 12:58:43 Analyzing analytics tables 2017-05-28 12:58:43 Creating indexes 2017-05-28 12:58:43 Applying aggregation levels 2017-05-28 12:58:42 Populating analytics tables 2017-05-28 12:58:42 Creating analytics tables 2017-05-28 12:58:42 Performing pre-create table work, org unit levels: 4 2017-05-28 12:58:42 Updating tables: ORG_UNIT_TARGET 2017-05-28 12:58:42 Table update done 2017-05-28 12:58:42 Clearing caches 2017-05-28 12:58:42 Creating SQL views 2017-05-28 12:58:42 Swapping tables 2017-05-28 12:58:42 Swapping analytics tables 2017-05-28 12:58:42 Analyzing analytics tables 2017-05-28 12:58:42 Creating indexes 2017-05-28 12:58:42 Applying aggregation levels 2017-05-28 12:58:41 Populating analytics tables 2017-05-28 12:58:41 Creating analytics tables 2017-05-28 12:58:41 Performing pre-create table work, org unit levels: 4 2017-05-28 12:58:41 Updating tables: COMPLETENESS_TARGET 2017-05-28 12:58:41 Table update done 2017-05-28 12:58:41 Clearing caches 2017-05-28 12:58:41 Creating SQL views 2017-05-28 12:58:41 Swapping tables 2017-05-28 12:58:41 Swapping analytics tables 2017-05-28 12:58:35 Analyzing analytics tables 2017-05-28 12:58:14 Creating indexes 2017-05-28 12:58:14 Applying aggregation levels 2017-05-28 12:58:09 Populating analytics tables 2017-05-28 12:58:09 Creating analytics tables 2017-05-28 12:58:09 Performing pre-create table work, org unit levels: 4 2017-05-28 12:58:08 Updating tables: COMPLETENESS 2017-05-28 12:58:08 Table update done 2017-05-28 12:58:08 Clearing caches 2017-05-28 12:58:07 Creating SQL views 2017-05-28 12:58:04 Swapping tables 2017-05-28 12:58:03 Swapping analytics tables 2017-05-28 12:55:46 Analyzing analytics tables 2017-05-28 12:11:30 Creating indexes 2017-05-28 11:37:19 Applying aggregation levels 2017-05-28 09:06:50 Populating analytics tables 2017-05-28 09:06:49 Creating analytics tables 2017-05-28 09:06:49 Performing pre-create table work, org unit levels: 4 2017-05-28 09:05:56 Updating tables: DATA_VALUE 2017-05-28 09:05:29 Updating resource tables 2017-05-28 09:05:29 Analytics table update process started
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
