Thank you every one!
I was granted permission to remove zeros and negative "energy" from the
dataset. And applied the Lars's medicine and Mr Datamart got back to our
lives again:
* INFO 2013-05-14 20:46:08,118 Completeness export task done
(AbstractDataSetCompletenessService.java [SimpleAsyncTas
Hi Orvalho,
I am working on a fix, in the meantime you can provide the following
medicine as SQL:
delete from systemsetting where name='orgUnitGroupSetAggregationLevel';
Then go to data admin -> cache and clear cache.
regards,
Lars
On Tue, May 14, 2013 at 2:49 PM, Orvalho Augusto wrote:
Lord forgive me for my sins.
These criminal negatives come from a legacy system. They have been
migrated... I am in the process of migrating them actually:
308527 records < 1
2275573 records are zeros!
1096806 records > 0
I will report this to the owners of the data.
Thank you
Orvalho
On Tu
There is not suppose to be negative counting though. That is why it is very
necessary to have validation rules in place.
Sent from my BlackBerry® smartphone from Etisalat. Enjoy high speed mobile
broadband on our easyblaze and plans for BlackBerry. Visit www.etisalat.com.ng
for details.
-Or
One thing:
Couldn't negative numbers trouble datamart?
I do not know how people here count negatively!
Orvalho
On Tue, May 14, 2013 at 11:34 AM, Orvalho Augusto wrote:
> Thank you!
>
> Yes those logs seemed to be clean.
>
> I can not run datamart now because it is a modest machine and there
Thank you!
Yes those logs seemed to be clean.
I can not run datamart now because it is a modest machine and there is a
lot of users.
I will try to set logs to DEBUG level.
By the way tail, is a nice tool but when one expects huge logs like that is
better to have a new log file.. and use less,
Did the manual generation produce any data/reports ??
Looking at the Log file, I looks rather crowded and Setting Tomcat LOG
LEVELS to INFO, DEBUG (I am not sure how now) only would be great so that
it skips out all the logs like Hibernate:...
Could also try to rectify the indicators(I am not sur
To run the datamart manually, you go to Services, Reports and to the left you
see Datamart for version 2.10 or Analytic Datamart for version 2.11.
Click on it, and make the fields as you desire then period and run
Dayo
Sent from my BlackBerry® smartphone from Etisalat. Enjoy high speed mobile
b
To run DataMart Manually (U need to have the Right i guess),
Analytics and Data Mart
- Analytics and Data Mart (In version 2.11 Hopefully 2.10 also)
But idealy it should be under Reports then on the left pane, select *Analytics
and Data Mart*
*There, You can select the periods, and other par
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 wrote:
> What are the properties of the Fields for
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 .
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
---+--+--+
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
Dear Orvalho,
DHIS2 Datamart sometim sometimes fails to run due to Invalid Data submitted
during Reporting e.g. if it is expected a Number and either Text or just
space or NULL (java.lang.NullPointerException) is submitted, It fails to
run. This has been sorted in the latest version. Please try Up
14 matches
Mail list logo
