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® 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® 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
