I have exactly the same 1769 sourceids as the 1769 organisationunitids.
Just to resume the facts:
1. My problem is, I can have the indicators/datalements summed if on the
report I choose an parent orgnaisatiounitid.
Eg. For Niassa province I want to have all the districs summed at a certain
month
Without the logs when aggregation takes place, it will be difficult to
determine what is happening.
Be sure that there are no sourceids in the "source" table without
corresponding organisationanunitids in the organisationunit table.
This has caused problems for yours truly in the past. Trawl the
Is all I have on the logs.
The thing it never finishs to run the creation of the organisation
structure. And when I check MySQL is occupided running a very long INSERT
query. Last time I left it from 12 hours and nothing happened.
Thanks
Caveman
On Wed, Jul 14, 2010 at 8:03 PM, Jason Pickering
No need for medical help. I have had many of these sorts of problems as
well, so you are not alone.
Can you post the log when you begin the aggregation process?
Regards,
Jason
On Wed, Jul 14, 2010 at 7:40 PM, Orvalho Augusto wrote:
> I understood that you want since I click on the create res
I understood that you want since I click on the create resource tables.
This is what since tomcat starts begin I have:
===
Jul 14, 2010 6:41:14 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native li
Hi Caveman,
Not doubting you but I have not seen DHIS start without some more
information.
You see nothing similar to this when DHIS starts up?
* INFO 11:15:58,359 Executing startup routine [1 of 13, runlevel 0]:
DataSetSho
rtNamePopulator (DefaultStartupRoutineExecutor.java [main])
* INFO 11:15
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:3
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 1
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
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
And even do those resource tables on Postgres it does not aggregate.
Caveman
On Wed, Jul 14, 2010 at 6:35 AM, Orvalho Augusto 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
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
Ok.
On Tue, Jul 13, 2010 at 11:55 AM, Bob Jolliffe wrote:
> On 13 July 2010 07:17, Orvalho Augusto 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.
On Tue, Jul 13, 2010 at 11:55 AM, Bob Jolliffe wrote:
> On 13 July 2010 07:17, Orvalho Augusto 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 ga
2010/7/12 Jason Pickering
> 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?
The orgunitstructure table is just a resource table intended to be used by
3rd party
On 13 July 2010 07:17, Orvalho Augusto 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
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 b
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 ta
Good!
Hope will not be a problem said like that.
Anyway we need people using it. It is not a doubt. We know that on India
there are MySQL with more than 5GB.
For vaccum yes postgres guys have daemonized the vaccum data clean. You are
right.
Caveman
2010/7/12 Lars Helge Øverland
> 2010/7/
2010/7/12 Orvalho Augusto :
> Thanks!!
>
> That of restoring a database of huge size is not everyday you do.
>
Well that depends :-)
> I need people with databases of Postgres with sizes above 5GB. And tell us
> how their postgres behave, specifically tell us how they address the vaccum
> data th
Thanks!!
That of restoring a database of huge size is not everyday you do.
I need people with databases of Postgres with sizes above 5GB. And tell us
how their postgres behave, specifically tell us how they address the vaccum
data thing.
Please is not a war.
Caveman
2010/7/12 Lars Helge Øv
Hi Caveman, we are definitely not dropping mysql support, its just
that most of the devs are using postgres so a function not being
mysql-compliant might sneak in from time to time. I tested most of the
application on mysql recently without trouble.
A common problem with aggregation earlier was th
I need to have a repo/table that aggregates data as I asked before. I did
not find it on docs.
Someone told me that can happens if a generate those resource tables. I try
to generate those tables and I get stuck on that error I reported.
Good for me if I do not need to generate such tables and as
Guys I found why.
It is because generating organitstructure takes a long time. (Mytop
monitored this query: INSERT INTO orgunitstructure ...)
The default transaction waiting time on MySQL is 50seconds.
I increased this innodb_lock_wait_timeout to 600seconds and it runs.
Please someone can help m
Generating any of the resource tables don't affect the aggregation /
report tables...
On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto wrote:
> Thanks!!!
>
> Caveman
>
>
> On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering
> wrote:
>>
>> A very common mistake is not having generated the resource
I did not have success. My logs are:
===
* ERROR 21:24:31,306 Error while executing action (ExceptionInterceptor.java
[http-8081-6])
java.lang.RuntimeException: Failed to flush BatchHandler
at
org.amplecode.quick.batchhandler.AbstractBatc
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,
>
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 wrote:
> I have a dataelement collected at a Health Centre le
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 b
29 matches
Mail list logo
