dhis2-users team mailing list archive

[Ocaya Stephen <stephocay@xxxxxxxxx>]

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.*