System.OleDbData

  • Article

Applies To: System Center 2012 - Operations Manager, System Center 2012 R2 Operations Manager, System Center 2012 SP1 - Operations Manager

Defines the data type for all OLE DB data items that are passed within a workflow.

Remarks

All OLE DB data item types are defined in accordance with the System.OleDbData schema. Workflow modules that take OLE DB data as input will define their input data type as System.OleDbData.

System.OleDbData has the following structure:

<DataItem type="System.OleDbData" time="2008-03-11T03:08:55.0343534-08:00" sourceHealthServiceId="0A0800A0-A802-E90B-6045-D961D516CA78">
   <HRResult></HRResult>
   <ResultLength></ResultLength>
   <Result></Result>
   <InitializationTime></InitializationTime>
   <OpenTime></OpenTime>
   <ExecutionTime></ExecutionTime>
   <FetchTime></FetchTime>  
   <RowLength></RowLength>
   <Columns>
      <Column></Column>
      <Column></Column>
   </Columns>
   <OriginalDataLength></OriginalDataLength>
   <ErrorDescriptionLength></ErrorDescriptionLength>
   <ErrorDescription></ErrorDescription> 
   <ResultCode></ResultCode>
</DataItem>

The System.OleDbData data type contains the elements described in the following table.

Element Description

HRResult

Represents the HRESULT that represents whether or not the Ole DB operation succeeded.

ResultLength

The length of the string value in the Result element.

Result

Represents the string value of the result represented by the ResultCode element.

InitializationTime

Represents the time taken, in milliseconds, to initialize the Ole DB data source.

OpenTime

Represents the time taken, in milliseconds, to initialize to open the Ole DB session.

ExecutionTime

Represents the time taken, in milliseconds, to run the Ole DB query.

FetchTime

Represents the time taken, in milliseconds, to fetch all records.

RowLength

Represents the number of rows returned in the single result set.

Columns

Represents the collection of columns in a row. For each row returned, there is a corresponding Columns element.

OriginalDataLength

Represents the length of the original data item if the original item is to be returned in the result set. For more information, see System.OleDbProbe.

ErrorDescriptionLength

Represents the length of the string represented by the ErrorDescription element.

ErrorDescription

Represents a detailed description of an error when an error has occurred.

ResultCode

Represents the result code of the error that occurred.

Result Code and Result Description

The ResultCode and ResultDescription elements represent the success or failure of an Ole DB operation. Both are to be understood in tandem. The following table lists their possible values.

ResultCode ResultDescription

0

Success

1

Data Source could not be initialized

2

Session could not be opened

3

Execution of query failed

4

Fetch Failed

HRESULT and Error Description

The HRResult and ErrorDescription elements offer a more precise identification of the error that occurred and that is represented by the ResultCode element.

See Also

Reference

System.BaseData