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.
-----Original Message----- From: Orvalho Augusto <orvaq...@gmail.com> Date: Tue, 14 May 2013 12:49:39 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