-
Title
LiteSpeed for SQL Server version 6.5 - defect or enhancement requests that have been addressed in -
Description
LiteSpeed for SQL Server version 6.5 - defect or enhancement requests that have been addressed in release 6.5 of LiteSpeed for SQL Server.
-
Resolution
Issues fixed in LiteSpeed 6.5.0, 6.5.1 and 6.5.2:
The following is a complete list of issues addressed and enhancements implemented in LiteSpeed 6.5.2 release.
Feature
Resolved Issue
Issue ID
Restore Wizard
The Restore Wizard may generate duplicate file names for a restore.
ST#88323
Maintenance Plans
HTML reports are not sent to email recipients after upgrade.
ST#90555
The following is a complete list of issues addressed and enhancements implemented in LiteSpeed 6.5.1 release.
Feature
Resolved Issue
Issue ID
Installation
Automatic cluster installation may fail on a passive node.
ST#86763
Backup and Restore
LiteSpeed may fail to overwrite old Double Click Restore backups.
ST#86861
Fast Compression job may hang after the backup completed.
ST#86321
Backup to TSM may fail if the filespace name is longer than 99 characters.
ST#87655
Backing up with the "Optimize Object Level Recovery speed" option may cause the "Unable to access Temp directory () for OLR Map generation" error.
ST#87491
Backup Cleanup
Smart Cleanup only removes one file in a multi-stripe backup.
ST#86365
Backups to UNC path are not deleted by the maintenance plan cleanup task or the "Remove files older than" option.
ST#86326
Object Level Recovery
Object Level Recovery may fail to recover a table if an empty system page is found.
ST#86076
Object Level Recovery may fail to recover a table with a persisted computed column.
ST#63060
Object Level Recovery should support the LIKE operator in queries.
ST#71016
Maintenance Plans
Backup to TSM may fail with the error 'Unable to create backup sub directory "<name>". Error: "Access is denied"'.
ST#86319
Rebuild index task does not work on LiteSpeed local.
ST#84934
HTML reports are only created if the user also selects to create a text report.
ST#86516
Documentation
Syntax example for xp_restore_database is incorrect.
ST#86530
The following is a complete list of issues addressed and enhancements implemented in LiteSpeed 6.5.0 release.
Feature
Resolved Issue
Issue ID
General
If the destination drive runs out of space to hold the backup file, LiteSpeed aborts but leaves an open SPID.
ST#80772
Server instances exported into SS2005 .regsrvr and SS2000 .csv files cannot be imported into the LiteSpeed UI Console.
ST#62846
Backup and Restore
LiteSpeed replaces double quotes with single quotes before sending the SQL to SQL Server.
Any scripts that may be using double quotes need to be reviewed and changed prior to upgrading.
Incorrect, will fail in LiteSpeed 6.5:
exec master.dbo.xp_restore_database
@database = N'Test'
,@filename = N'C:\temp\AdventureWorks_full_1309016094.bak'
,@with = N'REPLACE'
,@with = N'MOVE N"AdventureWorks" TO N"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test.mdf"'
,@with = N'MOVE N"AdventureWorks_log" TO N"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_log.ldf"'Correct:
exec master.dbo.xp_restore_database
@database = N'Test'
,@filename = N'C:\temp\AdventureWorks_full_1309016094.bak'
,@with = N'REPLACE'
,@with = N'MOVE N''AdventureWorks'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test.mdf'''
,@with = N'MOVE N''AdventureWorks_log'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_log.ldf'''ST#83448
A backup cannot be restored if the encryption password is longer than 91 characters.
ST#82798
Changing the Init backup set option in LiteSpeed defaults does not affect the default shown in the backup wizard.
ST#53542
Remote Deploy
Ability to run LiteSpeed wizards, such as Remote Deploy and Instance Configuration using an account with no access to SQL Server.
ST#61006
Should display a warning if the server does not have .NET 2 SP1 installed prior to the installation of LiteSpeed.
ST#77344
Provide an option to ignore a server instance in the XML file to avoid installing LiteSpeed onto this instance.
ST#67324
Maintenance Plans
Fill factor for the index is changed to 100 when using the Rebuild Index task.
ST#84211
Cannot open or convert a native SQL 2005 maintenance plan after LiteSpeed was upgraded to 6.1.
ST#80683
When saving a maintenance plan an error "Retrieving the COM class factory..." may occur.
ST#68674
Maintenance plans tasks other than backup should also have the option to ignore offline databases.
ST#64372
If a plan is disabled and then enabled later again it does not remember schedule settings and defaults to 1 hour interval.
ST#79096
The Copy Only Backup option is not scripted and not saved.
ST#82898
Object Level Recovery
Object Level Recovery may fail to read a backup with the "LSM File generation is not available" error.
ST#82080
The "Not null column was null" error may occur when restoring a table.
ST#79421
UI does not script out objects for recovery.
ST#75921
IDENTITY data type is not being transferred to the new table.
ST#38827
The @onFileGroup parameter only recovers tables to the PRIMARY filegroup.
ST#44044
Object Level Recovery should check databases for TDE and abort the request immediately if TDE is detected.
ST#66782
Object Level Recovery UI does not support Generate DDL Scripts and Recover of Schema against table names with Japanese characters.
ST#67463
Object Level Recovery may take several hours to complete recovering objects.
ST#81814
"Failed to read objects to recover" error may occur when reading a backup created with the previous LiteSpeed version.
ST#81143
Log Shipping
"The DELETE statement conflicted with the REFERENCE constraint" error may occur when removing a subscriber from a log shipping plan.
ST#83417
Backup Activity
If databases or SQL instances were renamed, the Update Native Backup statistics jobs can fail with the error "Cannot insert the value NULL into column 'DatabaseID'".
ST#82797
Central repository may update with the correct information from the local repository.
ST#79503
Maintenance plan history on LiteSpeed activity page is only updated after backup task completes.
ST#65396
TSM
Restoring a TSM backup using 'Restore from database' in UI errors out. 'Restore from Device TSM Backup' must be selected.
ST#70107
The TSM device retry time option is limited by 7 times.
ST#82379
Log Reader
The "Table <table_name> not found" error may occur when reading an offline log of a detached database.
ST#79815
The "Table 'sysfiles1' not found' error may occur when reading SQL Server 2008 offline database.
ST#81383
The "Page <page_details> is out of range" and "Page <page_details> not found" errors may occur when reading an offline database log.
ST#80073
UI
Cannot sort jobs by the 'Enabled' and 'Last Result' columns on the LiteSpeed jobs page.
ST#83647
When standard license is installed, the UI allows to create a Fast Compression job if a database uses the simple recovery model.
ST#80034
Advanced Options selections are not retained after editing a log shipping plan.
ST#82911
Maintenance plan tasks are sometimes displayed incorrectly in the maintenance plan design window and cannot be scrolled to.
ST#83669
Documentation
Better documentation regarding %z variable.
ST#80569
More details about file creation behavior with Fast Compression and Maintenance Plans.
ST#80614