GENERAL ERROR: NetBackup for SQL Server backups fail with CoCreateInstance error message: "The requested lookup key was not found in any active activation context."

Article:TECH35016  |  Created: 2004-01-19  |  Updated: 2013-10-23  |  Article URL http://www.symantec.com/docs/TECH35016
Article Type
Technical Solution

Product(s)

Environment

Issue



GENERAL ERROR: NetBackup for SQL Server backups fail with CoCreateInstance error message: "The requested lookup key was not found in any active activation context."

Error



The requested lookup key was not found in any active activation context.

Solution



Overview:
When attempting a backup using the NetBackup (tm) Microsoft SQL client, the backup fails with the error:
CoCreateInstance : 0x80040154.

The text follows: "CONTINUATION: The system cannot find the file specified" in the View | Monitor Jobs status window from within the NetBackup Microsoft SQL client. On the master server, the backup job will fail with a status 2.

The problem is the Microsoft SQL Server sqlvdi.dll file is not properly registered.

Note: This solution resolves the immediate SQL virtual device interface (VDI) issue, but the deeper cause of this problem should be investigated. It would be wise to consider any recent actions that may have moved or deleted other SQL Server or System files, or the Windows registry.


Troubleshooting:

Master Log Files:  N/A

Media Server Log Files:  N/A

Client Log Files:  
This exact error message is provided to NetBackup from SQL Server and may be observed in various log locations, such as:

  • SQL Error log (<install_path:>Microsoft SQL Server\MSSQL\LOG\ERRORLOG)
  • NetBackup progress log (<install_path:>VERITAS\NetBackup\dbext\mssql\logs\<long_name.prg>)
  • NetBackup dbbackup log (NetBackup 4.5 and earlier <install_path>\VERITAS\NetBackup\logs\dbbackup\<date.log>)
  • NetBackup dbclient log (NetBackup 5.0/5.1 and later <install_path:>VERITAS\NetBackup\logs\dbclient\<date.log>)

Error message:
11:03:05.900 [4916.5572] <32> CDBbackrec::InitDeviceSet(): ERR - Error in CoCreateInstance : 0x80040154. The text follows:
11:03:05.900 [4916.5572] <1> CDBbackrec::InitDeviceSet():  CONTINUATION: - The requested lookup key was not found in any active activation context.

Resolution:
1. Verify the location of the file by searching the local computer for the file sqlvdi.dll

2. Verify, in the registry, that the following two keys do not exist:
HKEY_CLASSES_ROOT\CLSID\{40700425-0080-11d2-851f-00c04fc21759}\InprocServer32
HKEY_CLASSES_ROOT\CLSID\{b5e7a132-a7bd-11d1-84c2-00c04fc21759}\InprocServer32

3. Reregister the sqlvdi.dll file from the DOS prompt using the regsvr32 program. In a DOS window, go to the directory where the sqlvdi.dll file is located, and execute the following command:
regsvr32 sqlvdi.dll.  

In the example below, this was done from the C:\Program Files\Microsoft SQL Server\80\COM directory.

 

4. A pop-up message similar to the following one should appear, indicating the successful registration of the DLL file.  

 

5. Rerun the backup, and confirm success

The sqlvdi.dll file can also be re-registered from within Windows Explorer.  Navigate to the directory where the sqlvdi.dll is located, right-click the DLL, select Open with | Other..., navigate to Winnt\System32 and select regsvr32 | Open | OK. Again, there should be a pop-up message indicating successful registration.
 
For more information about "regsvr32" see the following Microsoft article:
 http://support.microsoft.com/default.aspx?scid=kb;en-us;249873


Legacy ID



272407


Article URL http://www.symantec.com/docs/TECH35016


Terms of use for this information are found in Legal Notices