5 Replies Latest reply: Apr 8, 2013 8:37 AM by Srini VEERAVALLI RSS

    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

    1000983
      Hello again,

      I am working on OBIEE 10g
      I would like to add a new column on my presentation layer that will involve calculations ( based on 2 other existing columns). I have added the column on the physical layer + on the BMM layer, but I am having the following error when displaying results on presentation layer:

      <<State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 911, message: ORA-00911: invalid character at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
      SQL Issued: SELECT SUM(DAILY_SALES.NETSALES) saw_0, DAILY_SALES.PRODUCT saw_1, DAILY_SALES.RETAILER_NUMBER saw_2, DAILY_SALES.RETAILER_NAME saw_3, LOTTO_BUDGET.BUDGET_AMOUNT saw_4, LOTTO_BUDGET.BUDGET_MONTH saw_5, LOTTO_BUDGET.BUDGET_TYPE saw_6, LOTTO_BUDGET.BUDGET_YEAR saw_7, LOTTO_BUDGET.SALES_REP_NAME saw_8, LOTTO_BUDGET."% Achieved" saw_9 FROM "LOTTO_BI#1" WHERE (DAILY_SALES.WEEK_NUM >= 166) AND (DAILY_SALES.WEEK_NUM <= 169) AND (DAILY_SALES.PRODUCT = 'INSTANT') AND (LOTTO_BUDGET.BUDGET_MONTH = 'JANUARY') AND (LOTTO_BUDGET.BUDGET_TYPE = 'INSTANT') AND (LOTTO_BUDGET.BUDGET_YEAR = 2013) ORDER BY saw_1, saw_2, saw_3, saw_4, saw_5, saw_6, saw_7, saw_8, saw_9
      >>

      Can anyone please help?

      Many thanks,
      Gunajee.