odbc error

Question

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

Thomas Dodds · Answer

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

3363076 · Answer

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

[Deleted User] · Answer

No "from"?