Created a Maintenance Plan with the following Reporting options:
Select "Write a test file report in directory" with given a directory name w/wo file path
OR
Select "Write a html file report in directory" with given a directory name w /wo file path
When the job is being run, errors equal or similar to the following slssqlmaint.exe errors occur:
"slssqlmaint.exe has encountered a problem and needs to close. We are sorry for the inconvenience."
"EInOutError - I/O error 123
Exception EInOutError in module slssqlmaint.exe at 000B6DBA.
I/O error 123.
Runtime error 216 at 00403E3E
Server: Msg 50000, Level 19, State 1, Line 1
slssqlmaint failed"
"EInOutError - Invalid filename
Exception EInOutError in module slssqlmaint.exe at 000D7762.
Invalid filename.
Server: Msg 50000, Level 19, State 1, Line 1
slssqlmaint failed"
The script generated by the GUI has an incorrect file/directory path.
Duplicated directory path put into the script.
Example:
-Rpt "D:\\LOG\D:\\LOG\TestDailyMaintPlan.txt"
-HtmlRpt "D:\\LOG\D:\\LOG\TestDailyMaintPlan.txt"
WORKAROUND:
Manually edit the job's script to ensure the file path is correct:
1. Start Litespeed Enterprise Console.
2. From ServerGroup | ServerName | Management | Jobs, open the job corresponding to the Maintenance Plan by double-clicking on it.
3. Choose the "Steps" tab.
4. The script running by the job is placed at the Command Box.
5. Update the script and click the close button to make the changes.
OR
1. Start SQL Server Enterprise Manager.
2. From ServerGroup | ServerName | Management | SQL Server Agent | Jobs, open the job corresponding to the Maintenance Plan by double-clicking on it.
3. Choose the "Steps" tab.
4. Select the Step containing the script and click the "Edit" button to modify.
5. The script running by the job is placed at the Command Box
6. Update the script and click the OK button to make the changes.
STATUS:
Fixed in a recent release of LiteSpeed for SQL Server.
LiteSpeed is available for download at Quest.com (youuâ€ll need to login in order to access the page). The msi files are specific to 32-bit, 64-bit and 64-bit Itanium, the correct version will be the same as the bit version of your SQL Server and processor version. Release Notes, Installation Guide and Compiled HTML Help Files (.CHM) are also included in the installer package.
The complete release information may be located at http://www.quest.com/litespeed-for-sql-server/release-information.aspx
Â
