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 <stepho...@gmail.com> 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 <orvaq...@gmail.com>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, <deemo...@yahoo.com> 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 <stepho...@gmail.com> >>> Sender: "Dhis2-users" >>> <dhis2-users-bounces+deemoyes=yahoo....@lists.launchpad.net> >>> Date: Tue, 14 May 2013 10:22:45 >>> To: Orvalho Augusto<orvaq...@gmail.com> >>> Cc: dhis1-users<dhis2-us...@lists.launchpad.net>; DHIS 2 developers< >>> dhis2-devs@lists.launchpad.net> >>> Subject: Re: [Dhis2-users] Troubles running datamart >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-us...@lists.launchpad.net >>> 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-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
