dhis2-devs team mailing list archive

[Ocaya Stephen <stephocay@xxxxxxxxx>]

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(R) 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.*