Hi Orvalho, I am working on a fix, in the meantime you can provide the following medicine as SQL:
delete from systemsetting where name='orgUnitGroupSetAggregationLevel'; Then go to data admin -> cache and clear cache. regards, Lars On Tue, May 14, 2013 at 2:49 PM, Orvalho Augusto <orvaq...@gmail.com> wrote: > Lord forgive me for my sins. > > These criminal negatives come from a legacy system. They have been > migrated... I am in the process of migrating them actually: > 308527 records < 1 > 2275573 records are zeros! > 1096806 records > 0 > > I will report this to the owners of the data. > > Thank you > Orvalho > > > > On Tue, May 14, 2013 at 2:35 PM, <deemo...@yahoo.com> wrote: > >> ** >> There is not suppose to be negative counting though. That is why it is >> very necessary to have validation rules in place. >> Sent from my BlackBerry(R) smartphone from Etisalat. Enjoy high speed >> mobile broadband on our easyblaze and plans for BlackBerry. Visit >> www.etisalat.com.ng for details. >> ------------------------------ >> *From: * Orvalho Augusto <orvaq...@gmail.com> >> *Date: *Tue, 14 May 2013 12:49:39 +0200 >> *To: *Ocaya Stephen<stepho...@gmail.com> >> *Cc: *Dayo Adeyomoye<deemo...@yahoo.com>; >> Dhis2-users<dhis2-users-bounces+deemoyes=yahoo....@lists.launchpad.net>; >> dhis1-users<dhis2-us...@lists.launchpad.net>; DHIS 2 developers< >> dhis2-devs@lists.launchpad.net> >> *Subject: *Re: [Dhis2-users] Troubles running datamart >> >> One thing: >> >> Couldn't negative numbers trouble datamart? >> >> I do not know how people here count negatively! >> >> Orvalho >> >> >> >> On Tue, May 14, 2013 at 11:34 AM, Orvalho Augusto <orvaq...@gmail.com>wrote: >> >>> Thank you! >>> >>> Yes those logs seemed to be clean. >>> >>> I can not run datamart now because it is a modest machine and there is >>> a lot of users. >>> >>> I will try to set logs to DEBUG level. >>> >>> By the way tail, is a nice tool but when one expects huge logs like that >>> is better to have a new log file.. and use less, grep etc; And my >>> connection to the server keeps failing a lot of times. >>> >>> Orvalho >>> >>> >>> >>> >>> On Tue, May 14, 2013 at 11:09 AM, Ocaya Stephen <stepho...@gmail.com>wrote: >>> >>>> Did the manual generation produce any data/reports ?? >>>> >>>> Looking at the Log file, I looks rather crowded and Setting Tomcat LOG >>>> LEVELS to INFO, DEBUG (I am not sure how now) only would be great so that >>>> it skips out all the logs like Hibernate:... >>>> >>>> Could also try to rectify the indicators(I am not sure whether it also >>>> affects DATAMART generation). I did not see the cause of the error in the >>>> log. >>>> >>>> To View Log on the Fly, you could >>>> >>>> tail -f /var/logs/tomcat7/catalina.out (if the log file is in >>>> /var/logs/tomcat7 path ... and the log file is catalina.out >>>> >>>> Thanks >>>> >>>> >>>> On Tue, May 14, 2013 at 11:18 AM, Orvalho Augusto >>>> <orvaq...@gmail.com>wrote: >>>> >>>>> OK! >>>>> >>>>> The log I gave is after I start datamart the same way you describe. I >>>>> was not aware that it is manual way :-) >>>>> >>>>> The catalinaout.txt is attached... since the begining of the datamart. >>>>> How I wish I have zipped that file! >>>>> >>>>> I saw some invalid indicators there but those have been there before >>>>> these symptoms. >>>>> >>>>> Orvalho >>>>> >>>>> >>>>> On Tue, May 14, 2013 at 9:54 AM, Ocaya Stephen <stepho...@gmail.com>wrote: >>>>> >>>>>> To run DataMart Manually (U need to have the Right i guess), >>>>>> Analytics and Data Mart >>>>>> >>>>>> - Analytics and Data Mart (In version 2.11 Hopefully 2.10 also) >>>>>> >>>>>> But idealy it should be under Reports then on the left pane, select >>>>>> *Analytics >>>>>> and Data Mart* >>>>>> >>>>>> *There, You can select the periods, and other parameters ...* >>>>>> >>>>>> *The hit Start Export* >>>>>> On Tue, May 14, 2013 at 10:44 AM, Orvalho Augusto <orvaq...@gmail.com >>>>>> > wrote: >>>>>> >>>>>>> Thank you! >>>>>>> >>>>>>> The dataset report does not bring any data that I see on dataentry. >>>>>>> For other reports the fields are numeric. >>>>>>> >>>>>>> For the datamart. Pardon my ignorance. How do I run it mannualy? >>>>>>> >>>>>>> Orvalho >>>>>>> >>>>>>> >>>>>>> On Tue, May 14, 2013 at 9:36 AM, Ocaya Stephen >>>>>>> <stepho...@gmail.com>wrote: >>>>>>> >>>>>>>> What are the properties of the Fields for the Data Elements used >>>>>>>> for reporting? >>>>>>>> >>>>>>>> Could you try manually generating the datamart and send us the >>>>>>>> complete LOG from where the error start upto where you can see Caused >>>>>>>> by: >>>>>>>> .... >>>>>>>> >>>>>>>> That kind of gives a clear picture of what is causing the problem >>>>>>>> Waiting ... >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Tue, May 14, 2013 at 10:33 AM, Orvalho Augusto < >>>>>>>> orvaq...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Dears! >>>>>>>>> >>>>>>>>> Thank you for the answers. >>>>>>>>> >>>>>>>>> I have no text on value field according to this >>>>>>>>> >>>>>>>>> dhis2=# select * from datavalue where value is NULL; >>>>>>>>> dataelementid | periodid | sourceid | categoryoptioncomboid | >>>>>>>>> value | storedby | lastupdated | comment | followup >>>>>>>>> >>>>>>>>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >>>>>>>>> (0 rows) >>>>>>>>> >>>>>>>>> dhis2=# select * from datavalue where trim(value) = ''; >>>>>>>>> dataelementid | periodid | sourceid | categoryoptioncomboid | >>>>>>>>> value | storedby | lastupdated | comment | followup >>>>>>>>> >>>>>>>>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >>>>>>>>> (0 rows) >>>>>>>>> >>>>>>>>> dhis2=# select * from datavalue where trim(value) ~ '[A-Za-z]'; >>>>>>>>> dataelementid | periodid | sourceid | categoryoptioncomboid | >>>>>>>>> value | storedby | lastupdated | comment | followup >>>>>>>>> >>>>>>>>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >>>>>>>>> (0 rows) >>>>>>>>> >>>>>>>>> dhis2=# select * from datavalue where trim(value) !~ '[0-9]'; >>>>>>>>> dataelementid | periodid | sourceid | categoryoptioncomboid | >>>>>>>>> value | storedby | lastupdated | comment | followup >>>>>>>>> >>>>>>>>> ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- >>>>>>>>> (0 rows) >>>>>>>>> >>>>>>>>> Orvalho >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Tue, May 14, 2013 at 9:30 AM, <deemo...@yahoo.com> wrote: >>>>>>>>> >>>>>>>>>> I think the value type for the data elements are not properly set >>>>>>>>>> because if you set the value to be α number and an integer and also >>>>>>>>>> specify >>>>>>>>>> to or not to allow zeros plus your validation rules then I don't >>>>>>>>>> think you >>>>>>>>>> would these issues. >>>>>>>>>> >>>>>>>>>> The values are probably set to be text or so. >>>>>>>>>> Sent from my BlackBerry(R) smartphone from Etisalat. Enjoy high >>>>>>>>>> speed mobile broadband on our easyblaze and plans for BlackBerry. >>>>>>>>>> Visit >>>>>>>>>> www.etisalat.com.ng for details. >>>>>>>>>> >>>>>>>>>> -----Original Message----- >>>>>>>>>> From: Ocaya Stephen <stepho...@gmail.com> >>>>>>>>>> Sender: "Dhis2-users" >>>>>>>>>> <dhis2-users-bounces+deemoyes= >>>>>>>>>> yahoo....@lists.launchpad.net> >>>>>>>>>> Date: Tue, 14 May 2013 10:22:45 >>>>>>>>>> To: Orvalho Augusto<orvaq...@gmail.com> >>>>>>>>>> Cc: dhis1-users<dhis2-us...@lists.launchpad.net>; DHIS 2 >>>>>>>>>> developers<dhis2-devs@lists.launchpad.net> >>>>>>>>>> Subject: Re: [Dhis2-users] Troubles running datamart >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> 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 >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> *You can do anything, but not everything.* >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> *You can do anything, but not everything.* >>>>>> >>>>>> >>>>> >>>> >>>> >>>> -- >>>> >>>> *You can do anything, but not everything.* >>>> >>>> >>> >> > > _______________________________________________ > 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
