So I have a union of 3 different subject areas, everything works fine except when I add the fourth subject area then I keep getting the odbc driver error. I have double checked all my rows are aligned correctly still I am getting an error..
Below is the error message.
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
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: 46035] Datatype(INTEGER) nullable(1) unicode(1) external char(0) conversion to datatype(VARCHAR) nullable(1) unicode(0) external char(0) is not supported. (HY000)
any idea where I am going wrong
I will appreciate your help
Edited by: 994621 on Apr 26, 2013 8:21 AM
Try to run alone the report from 4th subject area.
Looks like you are adding to existing union all report, try to recreate it from scratch... if you are trying to add 4th to already existing union all might causing issue. BI creates its own outer query based on union to that another report is odd.
Edited by: Srini VEERAVALLI on Apr 26, 2013 11:40 AM