3 Replies Latest reply on May 9, 2012 10:52 PM by Srix

    Data type conversion issue

      Trying make the parent-child hierarchy to work, where all the keys in the dimension table and parent-child closure table are RAW ( VARBINARY(16) in admin tool)

      In BI Answer, when parent-child logical dimension is used with the fact table, got the following 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(VARBINARY) nullable(0) unicode(1) external char(0) conversion to datatype(VARCHAR) nullable(0) unicode(1) external char(0) is not supported. (HY000)

      SQL Issued: SELECT 0 s_0, "Chargeback"."Target Instance"."Target Name" s_1, CASE WHEN ISLEAF("Chargeback"."Target Instance"."H51 Target Instance") THEN 1 ELSE 0 END s_2, IDOF("Chargeback"."Target Instance"."H51 Target Instance") s_3, PARENT("Chargeback"."Target Instance"."H51 Target Instance") s_4, "Chargeback"."Base Facts"."Charge" s_5 FROM "Chargeback" WHERE ISROOT("Chargeback"."Target Instance"."H51 Target Instance")

      Two questions:

      1. The column with the conversion problem is not listed in the error message. How to find out the column with the problem?
      2. The SQL listed is not the final text send over to database. How to find out the actual query send over to the database? (Tried EM console, and searched for trace message for bi server, but could not find it there)