← Back to team overview

dhis2-users team mailing list archive

Re: Troubles running datamart

 

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, <deemoyes@xxxxxxxxx> 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 <orvaquim@xxxxxxxxx>
> *Date: *Tue, 14 May 2013 12:49:39 +0200
> *To: *Ocaya Stephen<stephocay@xxxxxxxxx>
> *Cc: *Dayo Adeyomoye<deemoyes@xxxxxxxxx>;
> Dhis2-users<dhis2-users-bounces+deemoyes=yahoo.com@xxxxxxxxxxxxxxxxxxx>;
> dhis1-users<dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers<
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *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 <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