Technical FAQs

Ask a Question

Information Manager archive job is failing during step 6 with the error 'ActiveScripting subsystem failed to load'

Goals and Symptoms

Symptoms
Information Manager archive job fails during step 6.

In the Archive Job History, step 6 gives the following error:

Unable to start execution of step 6 (reason: the ActiveScripting subsystem failed to load (see the SQLAGENT.OUT file for details); the Job has been suspended). The Step Failed.



The following error is displayed in the SQLAGENT.OUT log:

! [LOG] Step 6 of job 'Archive SMS-3000 Data' (0xFD0BF3FE094519469A3873D48CAF032D) cannot be run because the ActiveScripting subsystem failed to load. The job has been suspended


Causes and Fixes

Cause

An incorrect registry string is causing the job to fail. This can occasionally occur after a MSDE upgrade/patch.


Warning: Making incorrect changes to the registry can cause the system to become unstable. Always create a backup of the registry before making any changes.


Resolution

1. Open the Windows Registry Editor (Start->Run->Regedit)
2. Navigate to [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup] 
3. Verify that the path of the key
SQLPATH is correct. In some instances, the "s" at the end is missing.

C:\Program Files\Microsoft SQL Server\80\Tools

4. Re-run the SMS Archive Job

Was this helpful?
What can we do to improve the information ?