Re: [Dhis2-devs] Missing DataValues when we add 'Categories' dimenssion in the layout
Hi guys, any feedback on this? Regards Jose On Sat, Jul 12, 2014 at 12:36 PM, Jose Garcia Muñoz wrote: > > Dear all, > > in pivot tables when we add the 'Categories' dimenssion to the layouts, > the values are not showed. I have tested it in Sierra Leone Demo. > > > Without categories > > [image: Inline image 1] > > With categories > > [image: Inline image 2] > > Am I missing something? or do we have a bug here? > > Thanks > Jose > ___ 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
Re: [Dhis2-devs] [Dhis2-users] Error prune period
Hi Jason, I am happy that when I run prune period, it doesn’t appear error in console and success. But when I run generate “Resource Table”. I got the UI still processing so long time. and the console appear like in attached file. DO you know what is this problem? NOTE: I am using -DHIS2 v2.16 -Build revision: 16253 -Java version: jre7 -Database: PostgreSQL -OS: windows 8 thank you channara From: channara rin Sent: Thursday, July 31, 2014 12:37 Evening To: Jason Pickering Cc: DHIS 2 Users list, DHIS 2 Developers list Here is the error. ERROR: update or delete on table " period" violates foreign key constraint "mapview_periods_periodid_fkey" on table "mapview_periods" Detail: Key (periodid)=(427) I might try "DELETE FROM mapview_period where periodid = 427;" in the database, clear your DHIS2 cache and try again. Best regards, Jason On Thu, Jul 31, 2014 at 6:33 AM, wrote: HI Jason, I am using -DHIS2 v2.16 -Build revision: 16253 -Java version: jre7 -Database: PostgreSQL -OS: windows 8 plz check attached file. thanks channara From: Jason Pickering Sent: Thursday, July 31, 2014 11:16 Morning To: channara rin Cc: DHIS 2 Users list, DHIS 2 Developers list Hi Channara, It will help if you could send the output of the console when you execute the command, along with the usual (DHIS2 version, Java version, OS). Best regards, Jason On Thu, Jul 31, 2014 at 4:50 AM, wrote: Hi all developers, when I go to services→maintenance, then I checked run “prune period”, I always got the error in console. DO you know how can I solve this problem? thank you CHANNARA ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-us...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelpandalone. Jul 31, 2014 4:43:49 PM com.hazelcast.core.LifecycleService INFO: [10.11.57.39]:5701 [dev] [3.2.1] Address[10.11.57.39]:5701 is STARTED Jul 31, 2014 4:43:49 PM com.hazelcast.util.HealthMonitor INFO: [10.11.57.39]:5701 [dev] [3.2.1] memory.used=115.1M, memory.free=56.1M, me mory.total=171.2M, memory.max=227.6M, memory.used/total=67.22%, memory.used/max= 50.57%, load.process=-100.00%, load.system=100.00%, load.systemAverage=-100.00%, thread.count=34, thread.peakCount=34, event.q.size=0, executor.q.async.size=0, executor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, executor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, exe cutor.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.respon se.size=0, operations.remote.size=0, operations.running.size=0, proxy.count=1, c lientEndpoint.count=0, connection.active.count=0, connection.count=0 * INFO 2014-07-31 16:44:03,387 Found the following message senders: [org.hisp.d his.message.EmailMessageSender@56ae1c39, org.hisp.dhis.sms.SmsMessageSender@40bf 0ea4] (DefaultMessageService.java [localhost-startStop-1]) * INFO 2014-07-31 16:44:15,316 Detected apps: [] (DefaultAppManager.java [local host-startStop-1]) * INFO 2014-07-31 16:44:19,029 Scheduled task with key: aggregateQueryBuilder a nd cron: 0 0 0 * * ? (SpringScheduler.java [localhost-startStop-1]) Jul 31, 2014 4:44:19 PM com.hazelcast.util.HealthMonitor INFO: [10.11.57.39]:5701 [dev] [3.2.1] memory.used=200.0M, memory.free=48.5M, me mory.total=248.5M, memory.max=248.5M, memory.used/total=80.50%, memory.used/max= 80.50%, load.process=43.00%, load.system=58.00%, load.systemAverage=-100.00%, th read.count=39, thread.peakCount=39, event.q.size=0, executor.q.async.size=0, exe cutor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exe cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, execut or.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response. size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cl ientEndpoint.count=0, connection.active.count=0, connection.count=0 * WARN 2014-07-31 16:44:28,989 RP discovery / realm validation disabled; (Real mVerifier.java [localhost-startStop-1]) * INFO 2014-07-31 16:44:40,555 Executing startup routine [1 of 14, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2014-07-31 16:44:40,720 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1] ) * INFO 2014-07-31 16:44:40,727 Executing startup routine [3 of 14, runlevel 2]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [local host-startStop-1]) * INFO 2014-07-31 16:44:41,665 Linked default category with default concept (Da taElementDefaultDimensionPopulator.java [localhost-startStop-1]) * INFO 2014-07-31 16:44:41,881 Executing startup routine [4 of 14, runlevel 3]: TrackerIdentityPopulator (DefaultStartupRouti
Re: [Dhis2-devs] Missing DataValues when we add 'Categories' dimenssion in the layout
Hi Jose While trying to duplicate the error mentioned in your previous email I found that the current version 2.16 in https://apps.dhis2.org/demo is not displaying the list of data elements if details is selected and there are no dimensions in table layout, I tested with both chrome and firefox. Can you check and confirm? Best regards, JM El 31/07/2014, a las 04:54, Jose Garcia Muñoz escribió: > > Hi guys, > > any feedback on this? > > Regards > Jose > > > On Sat, Jul 12, 2014 at 12:36 PM, Jose Garcia Muñoz > wrote: > > Dear all, > > in pivot tables when we add the 'Categories' dimenssion to the layouts, the > values are not showed. I have tested it in Sierra Leone Demo. > > > Without categories > > > > With categories > > > > Am I missing something? or do we have a bug here? > > Thanks > Jose > > ___ > 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 ___ 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
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 16285: Extended AggQueryBuilder to support QtyValidated; Fixes-Tariffvalue; Totals
revno: 16285 committer: Bharath chbhara...@gmail.com branch nick: dhis2 timestamp: Wed 2014-07-30 12:58:29 +0100 message: Extended AggQueryBuilder to support QtyValidated; Fixes-Tariffvalue;Totals modified: local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/AddAggregationQueryAction.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/RunAggregationQueryAction.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/Lookup.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/TariffDataValueService.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/TariffDataValueStore.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/dataentry/LoadDataEntryFormAction.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/impl/DefaultPBFAggregationService.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/impl/DefaultTariffDataValueService.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/impl/HibernateTariffDataValueStore.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/impl/HibernateUtilizationRateStore.java local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/quality/dataentry/GetOrganisationUnitForMaxAction.java local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/loadDataEntryForm.vm -- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription === modified file 'local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/AddAggregationQueryAction.java' --- local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/AddAggregationQueryAction.java 2014-04-26 11:27:06 + +++ local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/AddAggregationQueryAction.java 2014-07-30 11:58:29 + @@ -121,6 +121,14 @@ aggregationConditionService.addCaseAggregationCondition( condition ); } +else if( aggType.equals( Lookup.PBF_AGG_TYPE_QUANTITY_VALIDATED ) ) +{ +String query = "NONE"; + +CaseAggregationCondition condition = new CaseAggregationCondition( dataElement.getName(), aggType, query, dataElement, dataElementCategoryService.getDefaultDataElementCategoryOptionCombo() ); + +aggregationConditionService.addCaseAggregationCondition( condition ); +} /*if ( aggType.equals( Lookup.CCEI_AGG_TYPE_STORAGE_CAPACITY ) ) { === modified file 'local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/RunAggregationQueryAction.java' --- local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/RunAggregationQueryAction.java 2014-04-26 11:27:06 + +++ local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/aggregation/action/RunAggregationQueryAction.java 2014-07-30 11:58:29 + @@ -175,6 +175,7 @@ Period period = new Period(); period = PeriodType.getPeriodFromIsoString( selectedPeriodId ); +period = periodService.reloadPeriod( period ); if( period != null ) { @@ -240,6 +241,21 @@ aggregationResultMap.putAll( defaultPBFAggregationService.calculateOverallUnadjustedPBFAmount( periods, dataElement, orgUnits, dataSetId ) ); } +else if( condition.getOperator().equals( Lookup.PBF_AGG_TYPE_QUANTITY_VALIDATED ) ) +{ +Set orgUnits = new HashSet(); + +orgUnits.addAll( orgUnitList ); + +List periods = new ArrayList(); + +//periods.add( getCurrentPeriod( dataSet.getPeriodType(), new Date() ) ); + +periods.add( period ); + +aggregationResultMap.putAll( defaultPBFAggregationService.calculateQuantityValidated( periods, orgUnits ) ); + +} dataElements.add( dataElement ); } === modified file 'local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/Lookup.java' --- local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/Lookup.java 2014-04-26 11:27:06 + +++ local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/Lookup.java 2014-07-30 11:58:29 + @@ -21,6 +21,7 @@ public static final String PBF_AGG_TYPE_OVERALL_QUALITY_SCORE = "OVERALL QUALITY SCORE"; public static final String PBF_AGG_TYPE_OVERALL_UNADJUSTED_PBF_AMOUNT = "OVERALL UNAD
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 16286: Allow to select any time period in the past for lock exceptions.
revno: 16286 committer: Tran Chau branch nick: dhis2 timestamp: Thu 2014-07-31 21:17:58 +0700 message: Allow to select any time period in the past for lock exceptions. removed: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/java/org/hisp/dhis/dataadmin/action/lockexception/GetPeriodsAction.java modified: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/META-INF/dhis/beans.xml dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/org/hisp/dhis/dataadmin/i18n_module.properties dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/struts.xml dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/webapp/dhis-web-maintenance-dataadmin/addLockExceptionForm.vm dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/webapp/dhis-web-maintenance-dataadmin/javascript/lockException.js dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/webapp/dhis-web-maintenance-dataadmin/jsonDataSets.vm -- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription === removed file 'dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/java/org/hisp/dhis/dataadmin/action/lockexception/GetPeriodsAction.java' --- dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/java/org/hisp/dhis/dataadmin/action/lockexception/GetPeriodsAction.java 2014-03-18 08:10:10 + +++ dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/java/org/hisp/dhis/dataadmin/action/lockexception/GetPeriodsAction.java 1970-01-01 00:00:00 + @@ -1,123 +0,0 @@ -package org.hisp.dhis.dataadmin.action.lockexception; - -/* - * Copyright (c) 2004-2014, University of Oslo - * All rights reserved. - * - * Redistribution and use in source and binary forms, with or without - * modification, are permitted provided that the following conditions are met: - * Redistributions of source code must retain the above copyright notice, this - * list of conditions and the following disclaimer. - * - * Redistributions in binary form must reproduce the above copyright notice, - * this list of conditions and the following disclaimer in the documentation - * and/or other materials provided with the distribution. - * Neither the name of the HISP project nor the names of its contributors may - * be used to endorse or promote products derived from this software without - * specific prior written permission. - * - * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND - * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED - * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE - * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR - * ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES - * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; - * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON - * ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT - * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS - * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. - */ - -import java.util.ArrayList; -import java.util.Collections; -import java.util.Date; -import java.util.List; - -import org.hisp.dhis.dataset.DataSet; -import org.hisp.dhis.dataset.DataSetService; -import org.hisp.dhis.i18n.I18nFormat; -import org.hisp.dhis.period.CalendarPeriodType; -import org.hisp.dhis.period.Period; -import org.hisp.dhis.period.PeriodType; -import org.hisp.dhis.system.filter.PastAndCurrentPeriodFilter; -import org.hisp.dhis.system.util.FilterUtils; - -import com.opensymphony.xwork2.Action; - -/** - * @author Morten Olav Hansen - */ -public class GetPeriodsAction -implements Action -{ -// - -// Dependencies -// - - -private DataSetService dataSetService; - -public void setDataSetService( DataSetService dataSetService ) -{ -this.dataSetService = dataSetService; -} - -private I18nFormat format; - -public void setFormat( I18nFormat format ) -{ -this.format = format; -} - -// - -// Input & Output -// - - -private int id; - -public void setId( int id ) -{ -this.id = id; -}
Re: [Dhis2-devs] Missing DataValues when we add 'Categories' dimenssion in the layout
Yes Juan Manuel, you are right. I confirm the same issues. On Thu, Jul 31, 2014 at 3:30 PM, Juan Manuel Alcantara Acosta < jmalcanta...@gmail.com> wrote: > Hi Jose > While trying to duplicate the error mentioned in your previous email I > found that the current version 2.16 in https://apps.dhis2.org/demo is not > displaying the list of data elements if details is selected and there are > no dimensions in table layout, I tested with both chrome and firefox. Can > you check and confirm? > Best regards, > JM > > > > El 31/07/2014, a las 04:54, Jose Garcia Muñoz > escribió: > > > Hi guys, > > any feedback on this? > > Regards > Jose > > > On Sat, Jul 12, 2014 at 12:36 PM, Jose Garcia Muñoz > wrote: > >> >> Dear all, >> >> in pivot tables when we add the 'Categories' dimenssion to the layouts, >> the values are not showed. I have tested it in Sierra Leone Demo. >> >> >> Without categories >> >> >> >> With categories >> >> >> >> Am I missing something? or do we have a bug here? >> >> Thanks >> Jose >> > > ___ > 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 > > > ___ 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
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 16287: Translation
revno: 16287 committer: Tran Chau branch nick: dhis2 timestamp: Thu 2014-07-31 22:38:39 +0700 message: Translation modified: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/org/hisp/dhis/dataadmin/i18n_module.properties -- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription === modified file 'dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/org/hisp/dhis/dataadmin/i18n_module.properties' --- dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/org/hisp/dhis/dataadmin/i18n_module.properties 2014-07-31 14:17:58 + +++ dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-dataadmin/src/main/resources/org/hisp/dhis/dataadmin/i18n_module.properties 2014-07-31 15:38:39 + @@ -361,4 +361,6 @@ sort_options = Sort options available_options = Available options please_select_a_dataset = Please select a dataset -please_select_an_organisation_unit = Please select an organisation unit \ No newline at end of file +please_select_an_organisation_unit = Please select an organisation unit +prev_year = Prev year +next_year = Next year \ No newline at end of file ___ 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
Re: [Dhis2-devs] Missing DataValues when we add 'Categories' dimenssion in the layout
Will be fixed shortly. Thanks for reporting. On Jul 31, 2014 5:20 PM, "Jose Garcia Muñoz" wrote: > > Yes Juan Manuel, you are right. I confirm the same issues. > > > On Thu, Jul 31, 2014 at 3:30 PM, Juan Manuel Alcantara Acosta < > jmalcanta...@gmail.com> wrote: > >> Hi Jose >> While trying to duplicate the error mentioned in your previous email I >> found that the current version 2.16 in https://apps.dhis2.org/demo is >> not displaying the list of data elements if details is selected and there >> are no dimensions in table layout, I tested with both chrome and firefox. >> Can you check and confirm? >> Best regards, >> JM >> >> >> >> El 31/07/2014, a las 04:54, Jose Garcia Muñoz >> escribió: >> >> >> Hi guys, >> >> any feedback on this? >> >> Regards >> Jose >> >> >> On Sat, Jul 12, 2014 at 12:36 PM, Jose Garcia Muñoz >> wrote: >> >>> >>> Dear all, >>> >>> in pivot tables when we add the 'Categories' dimenssion to the layouts, >>> the values are not showed. I have tested it in Sierra Leone Demo. >>> >>> >>> Without categories >>> >>> >>> >>> With categories >>> >>> >>> >>> Am I missing something? or do we have a bug here? >>> >>> Thanks >>> Jose >>> >> >> ___ >> 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 >> >> >> > > ___ > 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 > > ___ 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
[Dhis2-devs] Upload Apps name
Hi, In App Management, I noticed that if we have '/' on the Apps name, it fails to remove the application. When 'Remove' is used on app in 'Settings', it goes through, but does not actually remove it. So, I ended up removing the app from server file directly. ___ 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
Re: [Dhis2-devs] [Dhis2-users] Error prune period
Hi there. Again, hard to say without seeing the entire log. It sort of stops at the point of generating the periodstructure table. Is there more to the log? Regards, Jason On Thu, Jul 31, 2014 at 11:46 AM, wrote: > Hi Jason, > I am happy that when I run prune period, it doesn’t appear error in > console and success. But when I run generate “Resource Table”. I got the UI > still processing so long time. and the console appear like in attached file. > DO you know what is this problem? > NOTE: > I am using > -DHIS2 v2.16 > -Build revision: 16253 > -Java version: jre7 > -Database: PostgreSQL > -OS: windows 8 > > thank you > channara > *From:* channara rin > *Sent:* Thursday, July 31, 2014 12:37 Evening > *To:* Jason Pickering > > *Cc:* DHIS 2 Users list , DHIS 2 > Developers list > > Here is the error. > > ERROR: update or delete on table " > period" violates foreign key constraint "mapview_periods_periodid_fkey" on > table > "mapview_periods" > Detail: Key (periodid)=(427) > > I might try "DELETE FROM mapview_period where periodid = 427;" in the > database, clear your DHIS2 cache and try again. > > > Best regards, > Jason > > > > On Thu, Jul 31, 2014 at 6:33 AM, wrote: > >> HI Jason, >> I am using >> -DHIS2 v2.16 >> -Build revision: 16253 >> -Java version: jre7 >> -Database: PostgreSQL >> -OS: windows 8 >> plz check attached file. >> >> thanks >> channara >> >> >> *From:* Jason Pickering >> *Sent:* Thursday, July 31, 2014 11:16 Morning >> *To:* channara rin >> *Cc:* DHIS 2 Users list , DHIS 2 >> Developers list >> >> Hi Channara, >> It will help if you could send the output of the console when you >> execute the command, along with the usual (DHIS2 version, Java version, >> OS). >> >> Best regards, >> Jason >> >> >> >> On Thu, Jul 31, 2014 at 4:50 AM, wrote: >> >>> Hi all developers, >>> when I go to services→maintenance, then I checked run “prune period”, I >>> always got the error in console. DO you know how can I solve this problem? >>> >>> thank you >>> CHANNARA >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-us...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> > ___ 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
Re: [Dhis2-devs] [Dhis2-users] Error prune period
YES! now it work fine. After I waited to see log around 5mn for complete it’s task. It seem take longer than previous version. Thank you for helping From: Jason Pickering Sent: Friday, August 01, 2014 12:58 Evening To: channara rin Cc: DHIS 2 Users list, DHIS 2 Developers list Hi there. Again, hard to say without seeing the entire log. It sort of stops at the point of generating the periodstructure table. Is there more to the log? Regards, Jason On Thu, Jul 31, 2014 at 11:46 AM, wrote: Hi Jason, I am happy that when I run prune period, it doesn’t appear error in console and success. But when I run generate “Resource Table”. I got the UI still processing so long time. and the console appear like in attached file. DO you know what is this problem? NOTE: I am using -DHIS2 v2.16 -Build revision: 16253 -Java version: jre7 -Database: PostgreSQL -OS: windows 8 thank you channara From: channara rin Sent: Thursday, July 31, 2014 12:37 Evening To: Jason Pickering Cc: DHIS 2 Users list, DHIS 2 Developers list Here is the error. ERROR: update or delete on table " period" violates foreign key constraint "mapview_periods_periodid_fkey" on table "mapview_periods" Detail: Key (periodid)=(427) I might try "DELETE FROM mapview_period where periodid = 427;" in the database, clear your DHIS2 cache and try again. Best regards, Jason On Thu, Jul 31, 2014 at 6:33 AM, wrote: HI Jason, I am using -DHIS2 v2.16 -Build revision: 16253 -Java version: jre7 -Database: PostgreSQL -OS: windows 8 plz check attached file. thanks channara From: Jason Pickering Sent: Thursday, July 31, 2014 11:16 Morning To: channara rin Cc: DHIS 2 Users list, DHIS 2 Developers list Hi Channara, It will help if you could send the output of the console when you execute the command, along with the usual (DHIS2 version, Java version, OS). Best regards, Jason On Thu, Jul 31, 2014 at 4:50 AM, wrote: Hi all developers, when I go to services→maintenance, then I checked run “prune period”, I always got the error in console. DO you know how can I solve this problem? thank you CHANNARA ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-us...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp___ 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