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 |
Problem
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
Thank you.