Document ID: 290465
http://support.veritas.com/docs/290465 E-Mail Colleague IconE-Mail this document to a colleague

Symantec Indepth (tm) for SQL Server 7.5.1 - BU_SQ_751_003
Details:
THIS FILE HAS BEEN UPDATED! PLEASE CLICK HERE TO GET THE LATEST VERSION OF THE FILE
 
This Bundle Patch BU_SQ_751_003 is the Symantec Indepth for SQL Server version 7.5.1 Maintenance and Platform Support Pack, May 2007 release. It contains the following patches:
• SQ_SQFP_751_001
• SQ_SQCOL_751_002

This bundle patch contains the following enhancements:
• Adds support to Indepth for SQL Server to monitor:
o Windows 2003 (and release R2) on 64-bit platforms (ia64 and x64)
o MS-SQL Server 2005 SP2.

For the latest information on platform and products support, refer to the Symantec i3 version 7.5.1 Support Matrix (  http://support.veritas.com/docs/283453 ).
• Adds the Collector agent recovery mode - pssq_start has its own recovery mode that keeps on trying until the server is back up or the Collector agent is stopped.
• Improves the performance of the SQL Server Load Performance Data warehouse process.
• improves the Scalability of the Collect Space Utilization process by only collecting space information for objects with size greater than 20KB. This restriction reduces the number of objects which are analyzed by the process.

This bundle patch fixes the following issues:
• MS-SQL Collector:
o Incident 1003160:

GUI shows tables that belong to a different database due to applying incorrect mapping.
o Incident 1030015:

An Availability file corruption occurs.
o Incident 1035904:

A Current workspace error of stack overflows in high-activity environments. (Due to an pssq_pv stack overflow in the output tree creation).
• MS-SQL Tuner:
o Incident 1017584:

pssq_tuner.exe crashes if the amount of SQL text equals the maximum of 200KB.
o Incident 1017585:

A division by zero occurs in the Statistics workspace when there is a connection problem.
o Incident 1017586:

When associating to Statements in the Activity workspace, the user interface is hanging or an error is displayed due to a time out.
o Incident 1010778:

The Pssq_truner crashes, which can happen when:
- stmtIdInBatch is negative.
- parsing the argument with no parenthesis.
- there is an access violation. This is caused by the number of closing parenthesis in the same clause that exceeds 50.
o Incident 813535 (PR #5927):

The Load process fails with an access violation when the amount of text reaches 200KB.
o Incident 1035903:

Errors in Explain statements process:
- The error message "Invalid length parameter passed to the SUBSTRING function message" is received when associating to the Locked Objects entity in the Activity workspace.
- The Collect Schema Changes process shows the following error in the log file (pw_schema_changes_load.log):
SQL error while Preparing SQL statement. Message text from [Microsoft][ODBCSQL Server Driver][SQL Server]Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict. SQLCODE=457


Notes


Windows:
<i3_root>\logs\infra.bundle.patch.action.items.log
Installation instructions
1. Download and save the patch self extract file.
2. Run the patch self extract zip file and extract all files that are inside.
3. Open the Symantec i3 AdminPoint.
4. Go to the Patches View.
5. Choose the option Apply Patch.
6. Browse to the location to which you unzipped the patch.
7. Select and install the patch via the patch installation screens.

No pre installation tasks are required

No post installation tasks are required


THIS FILE HAS BEEN UPDATED! PLEASE CLICK HERE TO GET THE LATEST VERSION OF THE FILE

Download Now

Click Below to Browse the FTP files by Product:
ftp.support.veritas.com/pub/support/products


Supplemental Material:

System: Ref.#Description
ATGID: 6741

Products Applied:
 Indepth for SQL Server 7.5.1
Last Updated: August 07 2007 02:48 PM GMT
Expires on: 08-04-2017
Subscribe Via E-Mail IconSubscribe to receive critical updates about this document

Subjects:
 Indepth for SQL Server
   General Question: General Question

Languages:
 English (US)

Operating Systems:
Windows 2000

Advanced Server SP2, Advanced Server SP3, Advanced Server SP4, Professional SP2, Professional SP3, Professional SP4, Server SP2, Server SP3, Server SP4

Windows XP

5.2, Home 5.1, Home 5.1 SP1, Home 5.1 SP2, Pro 5.1, Pro 5.1 64 bit SP1, Pro 5.1 64 bit SP2, Pro 5.1 64-bit, Pro 5.1 SP1, Pro 5.1 SP2

Windows Server 2003

Enterprise Server, R2, Standard Server