Support wrote:Hello,
We confirm this is a bug and it will be fixed in the next release.
For now, please use the query below to workaround the error:
UPDATE "ou=0,ou=accounts,erglobalid=00000000000000000000,ou=CFC,ou=tim,ou=idB2B,ou=applications,o=cinfin"
SET $owner=SUBSTRING($owner FROM 1 FOR ABS(POSITION('ou=idb2b' IN $owner)-1)) || 'ou=idB2B' ||
SUBSTRING($owner FROM POSITION('ou=idb2b' IN $owner) + CHARACTER_LENGTH('ou=idb2b'))
WHERE EXISTS $owner AND POSITION('ou=idb2b' IN $owner) > 0;
Ah, that's a better work-around than what I came up with. Thanks for the help.
FYI, I tweaked the search string from 'ou=idB2B' which may not always be there to 'ou=id' which does and got rid of the negative length errors. Worked great then.
UPDATE "ou=systemUser,ou=itim,ou=CFC,ou=tim,ou=idb2b,ou=applications,o=cinfin"
SET $owner=SUBSTRING($owner FROM 1 FOR POSITION('ou=id' IN $owner)-1) || 'ou=idB2B' ||
SUBSTRING($owner FROM POSITION('ou=idb2b' IN $owner) + CHARACTER_LENGTH('ou=idb2b'))
WHERE EXISTS $owner AND POSITION('ou=idb2b' IN $owner) > 0;