Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
datetime2 column imported into RPD，will be changed varchar(27)
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?
Answers
-
ODBC ODBC in the connection pool rather than native call interface setting?
0 -
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?
0 -
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)
0 -
Ok so it maybe would help to know what version you're on?
0 -
Update the latest ODBC drivers,and the issue will be sovled.
0