PM78699: [WI 243266] Setup wizard fails to create tables with J2EE connection type

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Description:
    
    The Setup Wizard fails when having DataSource data pool
    connection with WAS to connect to DB2 repository. During step 3
    Create Database Tables of  Configure Database for ccm, the
    following error is thrown:
    
    The
    'com.ibm.team.repository.service.internal.DatabaseCreationRestSe
    rvice'
    service failed to activate because a service that it depends on,
    'com.ibm.team.repository.service.IServerDescriptionService',
    failed to be activated. For more details, open the help system
    and search for CRJAZ1972E.ID CRJAZ1972E
    com.ibm.team.repository.common.transport.TeamServiceRegistryExce
    ption
    ..
    ..
    
    How to reproduce:
    - Use DataSource data pool connection with WAS to connect to DB2
    - Run the setup wizard, specify J2EE as connection type, and
    give the proper value for J2EE DataSource
    - At step 3 the error occurs
    
    This happens because the repotool that gets involved in the
    setup wizard cannot handle DataSource data pool connections
    
    Workaround:
    Configure JDBC connection first, run the setup wizard and create
    the tables within the setup.
    After the setup is run successfully the DataSource Data pool
    connection can be used without issues.
    
    Note that when an upgrade has to be done later, the repotool
    gets involved.  Change back to
    JDBC connection for running the upgrade scripts.
    
    For further information see:
    https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.Wo
    rkItem/243266
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The Setup Wizard fails when having DataSource data pool
    connection with WAS to connect to DB2 repository. During
    step 3 Create Database Tables of  Configure Database for
    ccm, the following error is thrown:
    
    The
    "com.ibm.team.repository.service.internal.DatabaseCreationRe
    stService" service failed to activate because a service that
    it depends on,
    "com.ibm.team.repository.service.IServerDescriptionService",
    failed to be activated. For more details, open the help
    system and search for CRJAZ1972E.ID CRJAZ1972E
    com.ibm.team.repository.common.transport.TeamServiceRegistry
    Exception
    ..
    ..
    
    How to reproduce:
    

Problem conclusion

  • Problem Summary:  The ConnectionPoolService class uses lock
    files to make sure two processes are not connected to the
    same database. The lock file name is a hash based on the
    db.jdbc.location setting.  When datasources are being used,
    the db.jdbc.location setting is removed, causing a default
    "db2://" location, which causes conflicts between
    applications using datasources.
    
    The fix is to base this hash on the db.j2ee.dataSource
    setting when using datasources.  There's still a small hole
    where two apps defined in two different app servers on the
    same machine may access two different datasources with the
    same name under different JNDI scopes. But that's unlikely
    to ever be encountered.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM78699

  • Reported component name

    RATL TEAM CONCE

  • Reported component ID

    5724V0400

  • Reported release

    400

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-07

  • Closed date

    2013-07-29

  • Last modified date

    2013-07-29

  • 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

    RATL TEAM CONCE

  • Fixed component ID

    5724V0400

Applicable component levels

  • R400 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Team Concert

Software version:

4.0

Reference #:

PM78699

Modified date:

2013-07-29

Translate my page

Machine Translation

Content navigation