odbc error — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

odbc error

Received Response
11
Views
3
Comments
3363076
3363076 Rank 4 - Community Specialist

hi ,

when I am trying to run reports or go to dashboard I get this error

SQL Issued: SELECT case when MAX(Rcount("Dim OEM Customer (OEM_CUSTOMER)"."OEM Customer Id")) >1 then VALUEOF(NQ_SESSION.CUST_NUMS)

else  "Dim OEM Customer (OEM_CUSTOMER)"."OEM Customer Id" end FROM "CDF DW Prompts"

please can someone tell me what possibly can the reason be.  

 

Thanks

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    No "from"?

  • 3363076
    3363076 Rank 4 - Community Specialist

    Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P: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: 23006.  [nQSError: 23006] The session variable, NQ_SESSION.CUST_NUMS, has no value definition. (HY000

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    The session variable, NQ_SESSION.CUST_NUMS, has no value definition ... is the init block firing to populate values?