1 Reply Latest reply: Apr 26, 2013 11:43 AM by Srini VEERAVALLI RSS

    ODBC DRIVER ERROR

    997624
      Hello developers,
      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
        • 1. Re: ODBC DRIVER ERROR
          Srini VEERAVALLI
          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