When I run data integrity check on my database I get this on the logs and on
the browser it shows that interesting message: Please wait while the system
is processing
I waited for more that a hour!!! And nothing.
My DHIS is 2.0.5 the beta from the last week. Yes I am on MySQL.
Hi Orvalho,
I think you should check whether you have exactly the same IDs in both
the source and organisationunit tables. Any discrepancy here is likely
to result in that kind of error.
Knut
On Tue, Aug 31, 2010 at 11:06 PM, Orvalho Augusto orvaq...@gmail.com wrote:
When I run data integrity
In other words, both of the following queries should yield no results:
SELECT organisationunitid
FROM source RIGHT JOIN organisationunit ON sourceid = organisationunitid
WHERE sourceid is null
SELECT sourceid
FROM organisationunit RIGHT JOIN source ON sourceid = organisationunitid
WHERE
3 matches
Mail list logo