PI43878: "AN ERROR HAS OCCURRED" OBSCURES THE COMPONENT AND APPLICATION TABLES AFTER DELETING AUTHORIZATION REALM

APAR status

• Closed as unreproducible in next release.

Error description

• To reproduce:
  1) Create an authorization realm and an authentication realm
  that uses the authorization realm you just created.
  2) Add a user to the authentication realm just created.
  3) Create a component and application as that user.
  4) Delete the user, the authentication realm, and the
  authorization realm.
  5) Attempt to access the Applications tab, Component tab,
  Configuration tab, System Security, or UI Security tab.
  
  No content will appear. Instead the message "An error has
  occurred" will appear, and an error message similar to the
  following will appear in the logs:
  2015-06-26 08:27:37,858 ERROR http-0.0.0.0-8443-2
  com.urbancode.commons.web.filt
  er.ExceptionHandlingFilter -
  org.hibernate.ObjectNotFoundException: No row with
  the given identifier exists:
  [com.urbancode.security.AuthorizationRealm#9b7e6f73
  -7624-40d2-86c4-3e0a7460ae5e]
  org.hibernate.ObjectNotFoundException: No row with the given
  identifier exists:
  [com.urbancode.security.AuthorizationRealm#9b7e6f73-7624-40d2-86
  c4-3e0a7460ae5e]
  
          at
  org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(Ses
  sionF
  actoryImpl.java:435)
          at
  org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoa
  dEven
  tListener.java:233)
          at
  org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(Def
  aultL
  oadEventListener.java:285)
          at
  org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultL
  oadEv
  entListener.java:152)
          at
  org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
          at
  org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:103
  8)
          at
  org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:
  630)
          at
  org.hibernate.type.EntityType.resolve(EntityType.java:438)
          at
  org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.
  java:
  139)
          at
  org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loa
  der.j
  ava:982)
          at org.hibernate.loader.Loader.doQuery(Loader.java:857)
          at
  org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollectio
  ns(Lo
  ader.java:274)
          at org.hibernate.loader.Loader.doList(Loader.java:2533)
          at
  org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:227
  6)
          at org.hibernate.loader.Loader.list(Loader.java:2271)
          at
  org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader
  .java
  :119)
  ...
  

Local fix

• Run the following database command:
  INSERT INTO SEC_AUTHORIZATION_REALM VALUES ('<deleted
  authorization realm id>', 0, 'DELETED', 'DO NOT USE THIS',
  'com.urbancode.security.authorization.ldap.InternalAuthorization
  Module');
  
  The deleted authorization realm id will be in the first line of
  the error in the server logs. In the example, the authorization
  realm id is "9b7e6f73-7624-40d2-86c4-3e0a7460ae5e".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Issues with authorization realms                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• This issue does not occur in the IBM UrbanCode Deploy 6.x
  versions
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels

• R600 PSN

     UP

• R600 PSY

     UP

• R601 PSN

     UP

• R601 PSY

     UP

• R610 PSN

     UP

• R610 PSY

     UP

• R611 PSN

     UP

• R611 PSY

     UP

• R612 PSN

     UP

• R612 PSY

     UP

• R613 PSN

     UP

• R613 PSY

     UP

• R620 PSN

     UP

• R620 PSY

     UP