[jira] Resolved: (JS2-324) Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system

["Ate Douma (JIRA)" <je...@portals.apache.org>]

     [ https://issues.apache.org/jira/browse/JS2-324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ate Douma resolved JS2-324.
---------------------------

       Resolution: Fixed
    Fix Version/s: 2.2

The new Jetspeed 2.2 security model no longer loads user credentials automatically.

> Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system
> ------------------------------------------------------------------------------------------------------
>
>                 Key: JS2-324
>                 URL: https://issues.apache.org/jira/browse/JS2-324
>             Project: Jetspeed 2
>          Issue Type: Bug
>    Affects Versions: 2.1
>         Environment: Linux
>            Reporter: Teijo Lallukka
>            Priority: Minor
>             Fix For: 2.2
>
>
> I bulk loaded 500 users to jetspeed and noticed that management portlets(add user, add user to group and so on) don't work any more.
> I found out that queries to db are slow and creation of one index is good workaround. I haven't tested latest version that will it be fixed there.
> Workaround: create index SECURITY_CREDENTIAL_PRINID_IDX on SECURITY_CREDENTIAL (PRINCIPAL_ID) 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org