dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

This was an issue in old versions. You need to replace all uids that begin
with a number.

Alex

On Thursday, October 20, 2016, Ocaya Stephen <stephocay@xxxxxxxxx> wrote:

> Dear All,
>
> You could have noted after upgrading DHIS2 from lower version to 2.24 or
> so, the organisationunits may not load when opening data entry module or
> user managerment so you can't attach any user to any orgunit.
>
> We noted that the issue is brought about by a Token Error on uid. All the
> orgunits with uid starting with a number will cause this to fail in dhis2
> 2.24 or so. To resolve, we managed to write an SQL query to update the uids
> as below.
>
> UPDATE organisationunit SET uid = (
>  CASE
> WHEN (substring(uid FROM 1 FOR 1)) = '0'
> THEN 'o' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '1'
> THEN 'a' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '2'
> THEN 'b' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '3'
> THEN 'c' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '4'
> THEN 'd' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '5'
> THEN 'e' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '6'
> THEN 'f' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '7'
> THEN 'g' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '8'
> THEN 'h' || substring(uid FROM 2)
> WHEN (substring(uid FROM 1 FOR 1)) = '9'
> THEN 'i' || substring(uid FROM 2)
>     ELSE
>         uid
>     END
>   )
> WHERE uid ~ '^[0-9]';
>
> Replacing the starting number with a letter random.
>
> Hope this helps
>
> --
>
> *You can do anything, but not everything.*
>
>

-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET  | HISP Uganda
Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant


"I don't want to be anything other than what I have been - one tree hill "