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
