OBIEE 12.2.1.2.0 and Netezza with ODBC - can't get to work — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 12.2.1.2.0 and Netezza with ODBC - can't get to work

Received Response
21
Views
3
Comments
SPowell42
SPowell42 Rank 5 - Community Champion
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

Hi, I'm trying to connect to Netezza from a clean OBIEE 12.2.1.2.0 install. We have this working with no issues under 11g, but under 12c, when I try to run any analyses that hits the Netezza box, I get the following error. I don't understand this at all - our "server and/or port attributes" are clearly specified in the odbc.ini file under /obiee/user_projects/domains/bi/config/fmwconfig/bienv/core - it's an exact copy of what we used in 11g where everything works fine. Unsure where to turn to, and support is being slow getting to anything useful to help. Any ideas where to start?

Thanks,

Scott

Error Codes: OPR4ONWY: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: 16001.  [nQSError: 16001] ODBC error state: HY000 code: 33 message: Server and/or port attributes are empty. (HY000)

SQL Issued: SELECT   0 s_0,   "CSW - Student Records - Class Enrollment"."Term"."Term Code" s_1 FROM "CSW - Student Records - Class Enrollment" FETCH FIRST 65001 ROWS ONLY

Answers

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

    Hi Scott,

    Just googling this points to a lot of issues with the odbc.ini and the env variables not containing the correct values in the NZ_ODBC_INI_PATH variable.

  • SPowell42
    SPowell42 Rank 5 - Community Champion

    Christian - thank you SO much. I completely thought this was an OBIEE problem, not a Linux NZ odbc setup problem. Once I added the correct environment variables, everything is working perfectly. Thank you VERY much!

    Scott

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

    You're welcome