I am saying the truth. This is what I have on my catalina.out: * INFO 16:31:50,284 User login success: 'admin' (DefaultUserAuditService.java [http-8081-3]) Jul 14, 2010 4:31:50 PM org.apache.velocity.runtime.log.JdkLogChute log SEVERE: #parse() null argument
Caveman On Wed, Jul 14, 2010 at 5:35 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Caveman, > There must be something being logged in apache-tomcat-X.X.XX/logs > directory. Open up a terminal, and then do tail -f catalina.out and in a > separate terminal, start Tomcat. Post the result and we may be able to help. > > > Let me know if something is not clear. > > Regards, > Jason > > > > On Wed, Jul 14, 2010 at 4:40 PM, Orvalho Augusto <orvaq...@gmail.com>wrote: > >> There is nothing being logged. >> >> There are no views. >> >> Caveman >> >> >> >> On Wed, Jul 14, 2010 at 9:03 AM, Jason Pickering < >> jason.p.picker...@gmail.com> wrote: >> >>> Hi Caveman, >>> >>> Can you please post a stack trace of your application (use >>> pastebin.com) from startup until you start the datamart/report table >>> process? >>> >>> Do you have any external views that are linked to the report table you >>> are attempting to aggregate? >>> >>> Regards, >>> Jason >>> >>> >>> On Wed, Jul 14, 2010 at 8:57 AM, Orvalho Augusto <orvaq...@gmail.com> >>> wrote: >>> > And even do those resource tables on Postgres it does not aggregate. >>> > >>> > Caveman >>> > >>> > On Wed, Jul 14, 2010 at 6:35 AM, Orvalho Augusto <orvaq...@gmail.com> >>> wrote: >>> >> >>> >> I have changed the database (from MySQL to Postgres)... and used DHIS >>> >> tools to export and import the data. >>> >> >>> >> Well, those resource tables are being built in seconds on Postgres >>> now. So >>> >> I think there is a bug with MySQL. And I want to help to correct it. >>> >> >>> >> One verry bad consequence of not importing the dataelementids is: The >>> >> entering forms does not work no more. We have to redesign the forms >>> after an >>> >> import. >>> >> >>> >> Caveman >>> >> >>> >> >>> >> On Tue, Jul 13, 2010 at 10:28 PM, Orvalho Augusto <orvaq...@gmail.com >>> > >>> >> wrote: >>> >>> >>> >>> Ok. >>> >>> >>> >>> >>> >>> On Tue, Jul 13, 2010 at 11:55 AM, Bob Jolliffe < >>> bobjolli...@gmail.com> >>> >>> wrote: >>> >>>> >>> >>>> On 13 July 2010 07:17, Orvalho Augusto <orvaq...@gmail.com> wrote: >>> >>>> > I recompiled DHIS2.05 yesterday with help of a magician Jason >>> >>>> > yesterday. And >>> >>>> > the first thing I tried was this aggregation thing. >>> >>>> > >>> >>>> > So I started redoing the orgunitstructure. It gave the same error. >>> >>>> > >>> >>>> > While it was running I used the >>> >>>> > show full processlist >>> >>>> > to find out that it is a verry long insert to be run at once. I >>> have >>> >>>> > 1664 >>> >>>> > orgunits. So it sounds like indexing trouble. >>> >>>> > >>> >>>> > As there is a faith and "antimysql fight" I am moving my data to >>> >>>> > postgres. I >>> >>>> > have to do it manually. >>> >>>> >>> >>>> There is no mysql fight. Just more people using postgres I guess. >>> >>>> >>> >>>> > >>> >>>> > I have to do it manually because DHIS does not keep de ids fixed >>> >>>> > (organisationunid, dataelementid etc). That affects our mapping >>> data >>> >>>> > for >>> >>>> > data importation from other systems. So if someone could suggest a >>> >>>> > good >>> >>>> > strategy is welcomed. >>> >>>> >>> >>>> How are you doing mapping data from other systems? If you tell me a >>> >>>> bit about these systems and the data they have maybe we can make a >>> >>>> plan :-) >>> >>> >>> >>> Basically these systems are: >>> >>> The dataset (the DHIS concept) is represented by a table (in EpiInfo >>> >>> 6.06, DBF or MSAccess) where each record should have a month (or week >>> or >>> >>> quarter), year, province, district and health center columns - >>> sometimes >>> >>> they place the name of the association or a special sector of the >>> health >>> >>> center - then the other columns define a dataelement for DHIS. >>> >>> >>> >>> So what we were doing is: >>> >>> 1. Migrate the data from anywhere (EpiInfo, MSAccess and DBF) to >>> MySQL. >>> >>> >>> >>> 2. On MySQL we have tables where the columns names of those tables >>> >>> mapping to the dataelementid (which Lars recommend not be like this) >>> >>> >>> >>> 3. There is a script on Python made to run routinely to process this >>> data >>> >>> and insert the new one on DHIS 2 tables. >>> >>> When I say routinely, I mean each month or whenever I want it. >>> >>> >>> >>> The objective were to use solely DHIS for report and one day for data >>> >>> entry. >>> >>> >>> >>> Caveman >>> >>> >>> >>>> >>> >>>> Cheers >>> >>>> Bob >>> >>>> >>> >>>> > >>> >>>> > Thanks for your patience guys >>> >>>> > Caveman >>> >>>> > >>> >>>> > >>> >>>> > >>> >>>> > >>> >>>> > >>> >>>> > 2010/7/12 Jason Pickering <jason.p.picker...@gmail.com> >>> >>>> >> >>> >>>> >> Hi Lars, >>> >>>> >> Well, yes and no. If the resource tables (namely >>> orgunitstructure) is >>> >>>> >> not generated, it would not be possible to assign any orgunits to >>> a >>> >>>> >> given data mart/report table? Likewise, if the orgunit levels >>> have >>> >>>> >> not >>> >>>> >> been defined, it is also not possible to assign any orgunits to a >>> >>>> >> given report table/datamart, or perhaps I am just hallucinating ? >>> I >>> >>>> >> have run into this problem several times actually when creating >>> new >>> >>>> >> databases. Ideally, the orgunitstructure table should be >>> regenerated >>> >>>> >> when there have been changes to the orgunit hierarchy and users >>> >>>> >> should >>> >>>> >> be warned that it is not possible to create a report >>> table/datamart >>> >>>> >> without first defining orgunit level names. >>> >>>> >> >>> >>>> >> Regards, >>> >>>> >> Jason >>> >>>> >> >>> >>>> >> >>> >>>> >> 2010/7/12 Lars Helge Øverland <larshe...@gmail.com>: >>> >>>> >> > Generating any of the resource tables don't affect the >>> aggregation >>> >>>> >> > / >>> >>>> >> > report tables... >>> >>>> >> > >>> >>>> >> > >>> >>>> >> > >>> >>>> >> > On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto >>> >>>> >> > <orvaq...@gmail.com> >>> >>>> >> > wrote: >>> >>>> >> >> Thanks!!! >>> >>>> >> >> >>> >>>> >> >> Caveman >>> >>>> >> >> >>> >>>> >> >> >>> >>>> >> >> On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering >>> >>>> >> >> <jason.p.picker...@gmail.com> wrote: >>> >>>> >> >>> >>> >>>> >> >>> A very common mistake is not having generated the resource >>> >>>> >> >>> tables, >>> >>>> >> >>> namely "orgunitstructure". Consult the documentation for more >>> >>>> >> >>> details >>> >>>> >> >>> on how to generate these tables. >>> >>>> >> >>> >>> >>>> >> >>> Regards, >>> >>>> >> >>> Jason >>> >>>> >> >>> >>> >>>> >> >>> >>> >>>> >> >>> On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto >>> >>>> >> >>> <orvaq...@gmail.com> >>> >>>> >> >>> wrote: >>> >>>> >> >>> > I have a dataelement collected at a Health Centre level >>> (eg: >>> >>>> >> >>> > ats_posfem) >>> >>>> >> >>> > in >>> >>>> >> >>> > one province and only in some particular districts. In >>> >>>> >> >>> > unpredictible >>> >>>> >> >>> > future >>> >>>> >> >>> > at National level we will be collecting on every health >>> centre. >>> >>>> >> >>> > >>> >>>> >> >>> > Now, my ignorance: How can I obtain the provincial total on >>> >>>> >> >>> > Report >>> >>>> >> >>> > Table? I >>> >>>> >> >>> > have been battled with DHIS so far and nothing. >>> >>>> >> >>> > >>> >>>> >> >>> > Thanks guys >>> >>>> >> >>> > Caveman >>> >>>> >> >>> > >>> >>>> >> >>> > >>> >>>> >> >>> > _______________________________________________ >>> >>>> >> >>> > Mailing list: >>> >>>> >> >>> > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> >>>> >> >>> > Post to : dhis2-devs@lists.launchpad.net >>> >>>> >> >>> > Unsubscribe : >>> >>>> >> >>> > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> >>>> >> >>> > More help : https://help.launchpad.net/ListHelp >>> >>>> >> >>> > >>> >>>> >> >>> > >>> >>>> >> >>> >>> >>>> >> >>> >>> >>>> >> >>> >>> >>>> >> >>> -- >>> >>>> >> >>> -- >>> >>>> >> >>> Jason P. Pickering >>> >>>> >> >>> email: jason.p.picker...@gmail.com >>> >>>> >> >>> tel:+260968395190 >>> >>>> >> >> >>> >>>> >> >> >>> >>>> >> >> >>> >>>> >> >> >>> >>>> >> >> _______________________________________________ >>> >>>> >> >> Mailing list: >>> >>>> >> >> https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> >>>> >> >> Post to : dhis2-devs@lists.launchpad.net >>> >>>> >> >> Unsubscribe : >>> >>>> >> >> https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> >>>> >> >> More help : https://help.launchpad.net/ListHelp >>> >>>> >> >> >>> >>>> >> >> >>> >>>> >> > >>> >>>> >> >>> >>>> >> >>> >>>> >> >>> >>>> >> -- >>> >>>> >> -- >>> >>>> >> Jason P. Pickering >>> >>>> >> email: jason.p.picker...@gmail.com >>> >>>> >> tel:+260968395190 >>> >>>> > >>> >>>> > >>> >>>> > >>> >>>> > _______________________________________________ >>> >>>> > Mailing list: >>> >>>> > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> >>>> > Post to : dhis2-devs@lists.launchpad.net >>> >>>> > Unsubscribe : >>> >>>> > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> >>> >>>> > More help : https://help.launchpad.net/ListHelp >>> >>>> > >>> >>>> > >>> >>> >>> >>> >>> >> >>> >> >>> > >>> > >>> > >>> > >>> >>> >>> >>> -- >>> -- >>> Jason P. Pickering >>> email: jason.p.picker...@gmail.com >>> tel:+260968395190 >>> >> >> > > > -- > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+260968395190 >
_______________________________________________ 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
