← Back to team overview

dhis2-devs team mailing list archive

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 <orvaquim@xxxxxxxxx>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 <stephocay@xxxxxxxxx>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 <orvaquim@xxxxxxxxx>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 <stephocay@xxxxxxxxx>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 <orvaquim@xxxxxxxxx>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 <stephocay@xxxxxxxxx>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 <orvaquim@xxxxxxxxx
>>>>>> > 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, <deemoyes@xxxxxxxxx> 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 <stephocay@xxxxxxxxx>
>>>>>>>> Sender: "Dhis2-users"
>>>>>>>>         <dhis2-users-bounces+deemoyes=yahoo.com@xxxxxxxxxxxxxxxxxxx
>>>>>>>> >
>>>>>>>> Date: Tue, 14 May 2013 10:22:45
>>>>>>>> To: Orvalho Augusto<orvaquim@xxxxxxxxx>
>>>>>>>> Cc: dhis1-users<dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2
>>>>>>>> developers<dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>>>>>>> Subject: Re: [Dhis2-users] Troubles running datamart
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>> 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.*
>>
>>
>

Follow ups

References