Analytics Software

Hi All,

We have OBIEE installed on RH Linux server. On the same server we have the Netezza ODBC CLI installed.
So I set up the ODBC connection from OBI to Netezza and build a test rpd.
Everything seemed to work fine with very simple queries. Just querying one table for example.

However, once I started doing more complex reports in answers, the OBI server started to crash.

Symptoms would be I would create the answers report and try to look at the results. After a few seconds I'd get an error message like this...

Odbc driver returned an error (SQLExecDirectW). [Error Details|javascript:void(null)]
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 12010] Communication error connecting to remote end point: address = LOCALHOST; port = 9703. (HY000)

And the SQL at the bottom of course.

Then, I'd log out and try to log back in and I'd get this error...
Odbc driver returned an error (SQLDriverConnectW). [Error Details|javascript:void(null)]
Error Codes: OPR4ONWY:U9IM8TAC
State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not currently running.
Cannot connect to server machine (08004)

And I'd have to bounce the OBI services to get things working again. If I built reports off of any other area that connected to Oracle DBs (via OCI) there was no crash and no problem.

So basically, I've got an intermittent problem of crashes somehow related to using ODBC connection.

Anyone else seen this?

E