datetime2 column imported into RPD，will be changed varchar(27)

User472204-OC

Hi experts,

In SQL Server 2014, it has one table which contains some datetime columns, but if the format data is datetime2 and imported into physical layer in RPD by ODBC, it will be changed to varchar(27) automatically. Why? How to solve this issue, thanks.

By the way , if  the format data is datetime, it will be OK. Is it BUG in OBIEE 11.1.1.141014?

[Deleted User]

ODBC ODBC in the connection pool rather than native call interface setting?

[Deleted User]

Can't edit my post. What I meant to say was

ODBC basic or Advanced in the database type of the data source definition settings of your top-level physical layer object instead of a native call interface to SQL Server?

User472204-OC

Hi  Christian,

Thanks for your kindly support.

Firstly, I do not find the SQL SERVER 2012 in physical payer,but only 2008 or others.

I also change the default database type 'SQL SERVER 7.0/2000' into ODBC basic or Advanced, but it does not work sucessfylly.

The error message as below:

State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed:  [nQSError: 46008] Internal error: File server\Utility\Server\DataType\SUKeyCompare.cpp, line 1020. (HY000)

[Deleted User]

Ok so it maybe would help to know what version you're on?

How To Ask Questions The Smart Way

User472204-OC

Update the latest ODBC drivers,and the issue will be sovled.