IBM Support

JR27512: DISCOVERY FUNCTION DOES NOT WORK CORRECTLY FOR MS SQL SERVER 2005 BECAUSE OF SYSTEM TABLE CHANGES IN MS SQL SERVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The discover function in the Control Center displays incorrect
    remote schemas for a MS SQL Server 2005 data source.
    

Local fix

  • Modify the remote schema before you click OK to create the
    nicknames.
    

Problem summary

  • Users affected: Users of the discovery dialogs to query MS SQL
    Server in WebSphere Federation Server
    
    Problem description and summary:
    See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9, FixPak 5 (s080512).  This
    fix should be applied on the federation server.
    

Temporary fix

  • See LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    JR27512

  • Reported component name

    CONTROL CENTER

  • Reported component ID

    5724N9704

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-09-21

  • Closed date

    2008-06-23

  • Last modified date

    2008-06-23

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

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

    JR28859

Fix information

  • Fixed component name

    CONTROL CENTER

  • Fixed component ID

    5724N9704

Applicable component levels

  • R910 PSN

       UP

  • R911 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"DELETE","label":"DELETE CONTENT"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
24 March 2022