IBM Support

PM32371: "STEPS TO INSTALL PRE-CONFIGURED MICROSOFT SQL SERVERJDBC DRIVER" FOR VVM APPEAR TO BE INCORRECT FOR MS SQL 2008

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The steps outlined in the following documentation related to
    "Installing Pre-Configured JDBC Drivers" for MS SQL 2008 appear
    to be
    incorrect.????http://publib.boulder.ibm.com/infocenter/cbi/v10r1
    m0/index.jsp?topic=/com.ibm.swg.im.cognos.vvm_ag_guide.10.1.0.do
    c/vvm_ag_guide_id212ag_instprecojdbcdriv.html????Steps:????Steps
    to install pre-configured Microsoft SQL ServerJDBC Driver??1.
    Obtain the driver file for your version of Microsoft SQL
    Server.????2.  Download the driver version for the appropriate
    platform.????3.  Run the setup.exe installation program, and do
    the following: ????   -For Microsoft SQL 2000, extract
    mssqlserver.jar, msutil.jar, and msbase.jar to a locally
    accessible folder.????   -For Microsoft SQL 2005, extract the
    sqljdbc.jar file.????   -For Microsoft SQL 2008, extract
    sqljdbc4.jar, msbase.jar, mssqlserver.jar, and msutil.jar.????4.
     Copy the JAR file(s) to the Virtual View Manager
    directory:????installation_directory\apps\dlm\cis_ds_mssql\lib??
    ??5.
     Restart the server.????The error appears to be in the third
    point of Step 3.????For Microsoft SQL 2008, extract
    sqljdbc4.jar, msbase.jar, mssqlserver.jar, and msutil.jar.????It
    appears that the only jar file required is sqljdbc4.jar.  There
    does not appear to be any msbase.jar, mssqlserver.jar, and
    msutil.jar available for SQL 2008.??????
    

Local fix

  • Use only sqljdbc4.jar
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Virtual View Manager 10.1 Refresh Pack *
    * 1                                                            *
    ****************************************************************
    

Problem conclusion

  • Updated in documentation
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM32371

  • Reported component name

    COG VIRT VIEW M

  • Reported component ID

    5724W12VM

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-02-10

  • Closed date

    2011-09-13

  • Last modified date

    2011-09-13

  • 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

    COG VIRT VIEW M

  • Fixed component ID

    5724W12VM

Applicable component levels

  • RA11 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCRGHZ","label":"Virtual View Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 September 2011