IBM Support

PI36794: VMM DATABASE SCHEMA MISSING 'CITY' PROPERTY DEFINITION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The virtual member manager (VMM) database schema
    (wimdbproperties.xml) is missing the definition of the 'city'
    property, due to which tables created for the database
    repository will not contain the 'city' property.
    

Local fix

  • Ø
    1) Fix the wimdbproperties.xml by adding definition to 'city'
    attribute. Drop the tables in the database, and create them
    again using '$AdminTask setupIdMgrDBTables' command.
    
    2) In most cases, tables contain users/groups information,
    which cannot be deleted and re-created back. So we'll have to
    update the wimdbproperties.xml and manually add the entries to
    the DB tables. Below are the steps for manually adding the
    'city' attribute to DB tables.
    
    - - - - - - - - - - - - - - - - - - - - - - - - - -
     Manual steps to add 'city' attribute in DB table:
    - - - - - - - - - - - - - - - - - - - - - - - - - -
    
    1) Edit $WAS_HOME\etc\wim\setup\wimdbproperties.xml file, look
    for the entry
    <wimprop:property wimPropertyName="street" dataType="String"
    valueLength="128">
      <wimprop:applicableEntityName>
      ...
      ...
    </wimprop:property>
    
    Just next the above entry, add a new property definition for
    'city' as follows:
    
     <wimprop:property wimPropertyName="city" dataType="String"
    valueLength="128">
        <wimprop:applicableEntityName>
          <wimprop:entityName>Person</wimprop:entityName>
          <wimprop:entityName>PersonAccount</wimprop:entityName>
          </wimprop:applicableEntityName>
       </wimprop:property>
    
    Save changes to wimdbproperties.xml.
    
    2) Connect to the database (as defined for the
    DatabaseRepository, normally contained in the dbURL. Eg:
    OVWPSPV1).
    
     (a) Scan the PROP_ID column in DBPROP table (arrange the
         values for PROP_ID in ascending order) to determine the
         last entry (with highest value) say PROP_ID_MAX_VAL.
    
     (b) Then add(insert) another row to the DBPROP table, with the
         following values:
    
         (PROP_ID, NAME, TYPE_ID, META_NAME, DESCRIPTION,
         IS_COMPOSITE, VALUE_LENGTH, READ_ONLY, MULTI_VALUED,
         CASE_EXACT_MATCH, CLASSNAME, APPLICATION_ID) =
         (PROP_ID_MAX_VAL+1, 'city', 'STRING', 'DEFAULT', NULL, 0,
         128, 0, 1, 1, NULL, 'com.ibm.websphere.wim')
    
         where, PROP_ID_MAX_VAL+1 evaluates to numerical value, one
         higher than the current highest value of PROP_ID in the
         table. Eg: If current highest value for PROP_ID is 10014,
         then set [PROP_ID_MAX_VAL+1] = 10015.
    
     (c) Update the DBPROPENT table, by adding(inserting) the
         following two entries:
    
         (PROP_ID, APPLICABLE_ENTTYPE, REQUIRED_ENTTYPE) =
         (PROP_ID_MAX_VAL+1, 'Person', 0)
    
         (PROP_ID, APPLICABLE_ENTTYPE, REQUIRED_ENTTYPE) =
         (PROP_ID_MAX_VAL+1, 'PersonAccount', 0)
    
    3) Re-start database, WAS.
    
    4) Perform operations such as create/update users, to include
         'city' attribute and verify that the DBPROP and other
         tables are being populated successfully.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server virtual member manager (VMM)         *
    ****************************************************************
    * PROBLEM DESCRIPTION: VMM 'city' property is missing in the   *
    *                      VMM database schema definition.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The VMM database schema is missing the definition of a 'city'
    property, due to which tables created for the database
    repository will not contain the 'city' property.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI36794

  • Reported component name

    WEBSPHERE PORTA

  • Reported component ID

    5724E7600

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-03-11

  • Closed date

    2015-06-05

  • Last modified date

    2015-06-05

  • 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

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R700 PSY

       UP

  • R800 PSY

       UP

  • R850 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 850

Reference #: PI36794

Modified date: 05 June 2015