Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE nQSError: 46035 Datatype error

829439Jun 30 2011 — edited Jul 14 2011

I have a column name task_received_date whose datatype is set to timestamp.

But when i try to pull this column in OBI Answers and display result i have the following error.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46035] Datatype(VARCHAR) nullable(1) unicode(1) external char(0) conversion to datatype(TIMESTAMP) nullable(1) unicode(0) external char(0) is not supported. (HY000)

I really cant understand how varchar comes in the error message even though i set the column datatype to timestamp.

Can someone please help what is the cause of this error .

Please Note, I have disabled the cache as well but still the error pops out.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2011

Added on Jun 30 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

6 comments

4,205 views