Some users are not able to log into the system and you see the following error in the logs:
[12/31/12 10:34:37:010 PST] 00000039 E
getAccountByExternalId BMWSD0429E: An SQLException was encountered while
communicating with the database. Error code: 0, SQL State: null,
Message: Error: executeQueryForObject returned too many results.
[12/31/12 10:34:37:012 PST] 00000039 W
loadChildren IGNORING EXCEPTION (error reading account with external id
Groups,DC=myCompany,DC=com), RETURNING NULL
This is caused by duplicate group entries in the ACCOUNT table. The ACCOUNT table should have only one record per group.
To resolve this, first get a listing of the ACCOUNT table.
Use a query such as:
"select oid,external_id from .ACCOUNT"
For example if you find this
When you have identified the duplicates, delete the second one.
"delete from .ACCOUNT where oid=<oid which matches the second instance of the duplicate>"
Repeat this for each duplicate