IV30523: SQL SERVER SCHEMA NAMES ARE RESTRICTED TO 8 CHARACTERS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If you are specifying schema names for an SQL Server database
    using either the Profile Management Tool (PMT) or the WAS
    administration console WSRR deployment wizard, they are
    currently restricted to a maximum length of 8 characters.
    
    SQL Server supports a length of 128 characters.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of WebSphere Service Registry and Repository Server
    Version 7.5.0 and 8.0.0
    
    ****************************************************************
    PROBLEM SUMMARY:
    If you are using the profile management tool to create/augment a
    stand-alone server profile or the admin console deployment
    wizard you will be prompted for database configuration
    parameters.
    
    If you are using an SQL Server database, when you are prompted
    to provide a schema name, you will not be able to enter more
    then 8 characters.
    
    SQL Server allows schema names to be up to 128 characters long
    so the current length limit is overly restrictive.
    

Problem conclusion

  • The profile management tool wizard and admin console
    deployment wizard have been amended to allow you to enter a
    schema name that is up to 128 characters long.
    
    Please note that you must unaugment and re-augment existing
    deployment manager profiles for this change to take effect in
    the WAS admin console deployment wizard. If you create a new
    deployment manager profile, it will contain the change. The
    following Infocenter page describes how you can unaugment a
    WAS profile:
    
    http://publib.boulder.ibm.com/infocenter/sr/v7r5/topic/com.ibm.s
    r.doc/twsr_profile_unaugment_manual.html
    
    This fix is targeted for inclusion in fix pack 3 for WSRR v7.5
    and fix pack 2 for WSRR v8.0.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV30523

  • Reported component name

    SERVICE REGISTR

  • Reported component ID

    5724N7200

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-19

  • Closed date

    2012-11-05

  • Last modified date

    2012-11-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

    SERVICE REGISTR

  • Fixed component ID

    5724N7200

Applicable component levels

  • R750 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Service Registry and Repository

Software version:

7.5

Reference #:

IV30523

Modified date:

2012-11-05

Translate my page

Machine Translation

Content navigation