Forum Stats

  • 3,759,483 Users
  • 2,251,549 Discussions
  • 7,870,674 Comments

Discussions

Inconsistent datatypes: expected NUMBER got CHAR at OCI call OCIStmtExecute

Hi Team,

I am getting below error while creating measure while converting tableau formula to OBIEE RPD(12.2.1.4)

Tableau Formula : DATE(STR(MONTH([Earliest Date]))+"/"+STR([[[[[Billing Cycle]]]] Start 1])+"/"+STR(YEAR([Earliest Date])))

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1843, message: ORA-01843: not a valid month at OCI call OCIStmtFetch. (HY000)

State: HY000. Code: 17012. [nQSError: 17012] Bulk fetch failed. (HY000)

SQL Issued: SELECT 0 s_0, CAST(CAST(Month("AR Analytics"."Fact WNS AR RR Select Billinginfo"."Earliest Date") AS CHARACTER(30))||'/'||CAST("AR Analytics"."Fact WNS AR RR Select Billinginfo"."Billing Cycle Start 1" AS CHARACTER(30))||'/'||CAST("AR Analytics"."Fact WNS AR RR Select Billinginfo"."Billing Cycle Start 1" AS CHARACTER(30)) AS DATE) s_1 FROM "AR Analytics" FETCH FIRST 10000000 ROWS ONLY.

If i removed CAST AS Date then it is running fine and giving below output

1/15/15

10/1/1

11/15/15

Here i need to convert above output(11/15/15) to Date format.

can anyone help me here

Regards,

sudheer

Tagged:

Best Answer

  • Christian Berg-0racle
    Christian Berg-0racle Managing Director Member Posts: 9,439 Gold Crown
    Accepted Answer

    That would be a 1:1 transformation of Tableau to OA I assume? Because the conversions are dreadful and assured to give you the most headache possible and conceivable for the most punishing performance input and also least maintainability.

Answers