Symantec Control Compliance Suite fails to export query results to exchange.

Article:TECH173832  |  Created: 2011-11-08  |  Updated: 2011-11-08  |  Article URL http://www.symantec.com/docs/TECH173832
Article Type
Technical Solution


Issue



Symantec Control Compliance Suite fails to export query results to exchange.

 


Error



The task list job results shows the following error:

 

Task List : machines_task Start Time      : 08/11/2011 08:29:38
Completion Time : 08/11/2011 08:32:06
Status          : Completed = 1; Error = 0; Total = 1
Summary :
   
    Completed Tasks: 1
    Total Tasks: 1
Task : machines
---------------
    Type            : Query
    Status          : Completed
    Summary         : Records: 7/7
    Start Time      : 08/11/2011 08:29:39
    Completion time : 08/11/2011 08:29:52
   
    Post process summary :
   
    Export Grid: MS Excel (using OLE) export to Exchange mailbox - Failed.
Error in Exporting: Error:
 Code    = -2147024770
 Message = The specified module could not be found.
 Source  = ADODB.Connection
 Desc    =
    Save Result-Set to Query-Binder - Successful.
 

If debug was enabled the [Volume]:\Program Files\Symantec\RMS\log\HandleExport_YYYYMMDD_PID.log would show:

 

08:29:58 | 2376 | 3884 | .\src\BVDBClasses.cpp(487) | 3: Warning: SQL connection to [Provider=SQLOLEDB;DATA SOURCE=ccs03-rms;DATABASE=BV;Connect Timeout=100000;Trusted_Connection=Yes;] attempt 1 failed with error [Error:
 Code    = -2147024770
 Message = The specified module could not be found.
 Source  = ADODB.Connection
 Desc    =
]; pausing for retry...
08:29:59 | 2376 | 3884 | .\src\BVDBClasses.cpp(471) | 3: Info: BVDatabase: Opening SQL Connection [Provider=SQLOLEDB;DATA SOURCE=ccs03-rms;DATABASE=BV;Connect Timeout=100000;Trusted_Connection=Yes;] attempt 2 of 7...
08:29:59 | 2376 | 3884 | .\src\BVDBClasses.cpp(487) | 3: Warning: SQL connection to [Provider=SQLOLEDB;DATA SOURCE=ccs03-rms;DATABASE=BV;Connect Timeout=100000;Trusted_Connection=Yes;] attempt 2 failed with error [Error:
 Code    = -2147024770
 Message = The specified module could not be found.
 Source  = ADODB.Connection
 Desc    =
]; pausing for retry...
08:30:01 | 2376 | 3884 | .\src\BVDBClasses.cpp(471) | 3: Info: BVDatabase: Opening SQL Connection [Provider=SQLOLEDB;DATA SOURCE=ccs03-rms;DATABASE=BV;Connect Timeout=100000;Trusted_Connection=Yes;] attempt 3 of 7...
08:30:01 | 2376 | 3884 | .\src\BVDBClasses.cpp(487) | 3: Warning: SQL connection to [Provider=SQLOLEDB;DATA SOURCE=ccs03-rms;DATABASE=BV;Connect Timeout=100000;Trusted_Connection=Yes;] attempt 3 failed with error [Error:
 Code    = -2147024770
 Message = The specified module could not be found.
 Source  = ADODB.Connection
 Desc    =
 

Environment



Windows 2008 x64

Symantec Control Compliance Suite RMS 10.x

 


Cause



When exporting, RMS needs and looks for oledb32.dll, by default this is located in: C:\Program Files (x86)\Common Files\System\Ole DB\. However the location could be different from the default and when RMS searches for the dll it uses the system variable %CommonProgramFiles(x86)% to find this location.

There is a known issue in Windows Vista X64 and Windows 2008 X64 that when the CreateEnvironmentBlock function is called without inheriting environment variables from the current process, the returned environment block is missing the following environment variables: CommonProgramFiles(x86), CommonProgramW6432, ProgramFiles(x86), ProgramW6432.

This causes RMS to fail to find oledb32.dll and the export fails.

 

 


Solution



Create a system environment variable "CommonProgramFiles(x86)" and set its value to the folder for common program files (32bit). This folder can be found out by going to Start > Run > "%CommonProgramFiles(x86)%" . Generally this folder is located at "C:\Program Files (x86)\Common Files"

 

 




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


Terms of use for this information are found in Legal Notices