4 Replies Latest reply: Sep 30, 2011 10:10 AM by user248025 RSS

    OBIEE RPD Subject area vanished suddenly in answers

      Hello All,

      In one of our clustered production environment we got the below error suddently and we couldn't find any root cause yet, Please help us if you copuld come across the same situation , appreciate your help.

      This error we got when user try to access ther report , and as admin person we identified in the answers the mentioned "Logistics "
      subject area was not shown fully and the ltest has been shrunked , once we restrt the servers again it came back and all the relavant reports were available for the use.

      View Display Error

           Odbc driver returned an error (SQLExecDirectW).
      Error Details
      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
      State: HY000. Code: 2242585400. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27004] Unresolved table: "Logistics ". (HY000)
      SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Alignment Dimension"."Country Code" FROM "Logistics "')}
      SQL Issued: SELECT "Alignment Dimension"."Country Code" FROM "Logistics"