Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback
When using an SQL Server source or target with smalldatetime or datetime2 datatype, the PowerCenter Integration Service cannot convert the date or time from character string
Problem Description

When using an SQL Server source or target with smalldatetime or datetime2 datatype, the following error is displayed in the session log:

WRT_8229 Database errors occurred: FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]Inconsistent descriptor information. FnName: Execute -- [DataDirect][ODBC lib] Function sequence error

Cause
Solution

This is a known issue and CR 300999 has been submitted to be addressed in a future release.

Workaround

On Windows, do the following:

  1. Go to HKEY_LOCAL_MACHINE > Software > ODBC > ODBC.INI.
  2. Right-click the source name.
  3. Go to New > String Value.
  4. Double-click the string.
  5. Set the value name as WorkArounds2.
  6. Set the value data as 2.

On Linux, do the following:

  1. Go to ODBC.INI file.
  2. Add a string under the ODBC source name.
  3. Set the custom flag, WorkArounds2=2 in the ODBC.ini file.

The following example shows the custom flag set at the ODBC.ini file in Linux:

[SQL Server Wire Protocol]
Driver=<INFA_HOME>/9.5.0/ODBC6.1/lib/DWsqls25.so
Description=DataDirect 6.1 New SQL Server Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
WorkArounds2=2

More Information
Applies To
Product(s): PowerCenter
Product Version(s): PowerCenter
Database:
Operating System(s): Linux; Windows
Other Software:

Reference
300999
Attachments
Last Modified Date:5/25/2012 1:50 AMID:139677
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)