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