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 <[email protected]>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, <[email protected]> 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 <[email protected]> >> Sender: "Dhis2-users" >> <[email protected]> >> Date: Tue, 14 May 2013 10:22:45 >> To: Orvalho Augusto<[email protected]> >> Cc: dhis1-users<[email protected]>; DHIS 2 developers< >> [email protected]> >> Subject: Re: [Dhis2-users] Troubles running datamart >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > -- *You can do anything, but not everything.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
