-
Title
Error executing xp_sls_WriteConfiguration extended stored procedure: Failed to save/rewrite configur -
Description
SQL Agent job running following procedures failed:
exec [LiteSpeedLocal]..[LiteSpeed_ImportNativeHistory] exec [master]..[xp_replicate_activity_statistics] Fails with following error: Executed as user: Server\instancename.
'Error executing xp_sls_WriteConfiguration extended stored procedure: Failed to save/rewrite configuration file [SQLSTATE 42000] (Error 61202).' -
Cause
The litespeed.ini file is opened for editing by another process
-
Resolution
RESOLUTION 1
Change the time the job executes. Ideally once a day is more than enough.RESOLUTION 2
Remove collection on Native Backup activity
1. Go to Start | All Programs | Quest Software | Litespeed for SQL Server
2. Launch Instance configuration
3. On the Native Activity Backup option, select 'Do not collect Native Backup Activity'