Oracle Analytic Desktop hangs with ODBC connection while reading tables from Vertica DB.

User_QYX9R

Oracle Analytic Desktop hangs with ODBC connection while reading tables from Vertica DB. Below are the steps:

1) Create System DSN with Vertica DB.

2) Create connection in Oracle Analytics Desktop with the DSN using ODBC.

3) Preview the table's data. Do this repeatedly for 5-6 tables.

Oracle Analytics will hang and on waiting for 5-10 Minutes, it will give an error message:

"Create Embedded Data Set Failure"

Note: Table contains very less data. Only 3-4 rows having 3 columns.

Gianni Ceresa

Look for the log file, it is more verbose about what's going on than just "Internal error" or "failure".

User_QYX9R

Hi Gianni,

I have gathered different logs and have cropped some part from them. Do you get some clue from them

Jetty Logs:

Oct 13, 2021 4:13:00 AM oracle.bi.datasource.logging.ODLLoggerWrapper error

SEVERE: INVALID_DATABASE [JDSError : 115] Invalid Database Name

Cause - java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.

[nQSError: 43119] Query Failed: 

[nQSError: 46281] Failed to download metadata for dataset 'weblogic'.'Vertica_ODBC'.

[nQSError: 46283] An HTTP operation timed out after 60 seconds. Operation aborted.

Action - Please refer to logs for more Details

oracle.bi.datasource.jdbc.connector.SQLExceptionMapper.convert(SQLExceptionMapper.java:60)

oracle.bi.datasource.jdbc.connector.BIJDBCConnector.execute(BIJDBCConnector.java:260)

oracle.bi.datasource.jdbc.connector.BIJDBCConnector.execute(BIJDBCConnector.java:99)

oracle.bi.datasource.jdbc.connector.BIJDBCProvider.getTypeOptions(BIJDBCProvider.java:212)

oracle.bi.datasource.service.DatasourceServiceProcessor.getTypeOptions(DatasourceServiceProcessor.java:1115)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Oct 13, 2021 4:13:00 AM oracle.bi.datasource.logging.ODLLoggerWrapper error

SEVERE: JDS_JSON_ERROR_RESPONSE [JDSError : 105] HTTP Status Code: 404, JDS JSON Error Response: {"detail-message":"Cause: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.\r\n[nQSError: 43119] Query Failed: \r\n[nQSError: 46281] Failed to download metadata for dataset 'weblogic'.'Vertica_ODBC'.\r\n[nQSError: 46283] An HTTP operation timed out after 60 seconds. Operation aborted.\nAction: Please refer to logs for more Details","code":"404115","message":"Invalid Database Name"}

Cause - JDS JSON Response

Action - HTTP Status Code: 404, JDS JSON Error Response: {"detail-message":"Cause: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.\r\n[nQSError: 43119] Query Failed: \r\n[nQSError: 46281] Failed to download metadata for dataset 'weblogic'.'Vertica_ODBC'.\r\n[nQSError: 46283] An HTTP operation timed out after 60 seconds. Operation aborted.\nAction: Please refer to logs for more Details","code":"404115","message":"Invalid Database Name"}

oracle.bi.datasource.service.adf.server.DatasourceServlet.doGet(DatasourceServlet.java:642)

oracle.bi.datasource.service.adf.server.DatasourceServlet.doPost(DatasourceServlet.java:767)

javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

App Logs:

[1013/030551.415:INFO:dvd_app.cc(70)] DISPLAYING MAIN BROWSER

[1013/030551.419:INFO:dvd_server_manager_win.cc(509)] Starting the rest of the apps

[1013/030551.421:INFO:dvd_server_manager_win.cc(514)] Wrote ports file

[1013/030551.761:INFO:CONSOLE(5)] "Creating component framework.", source: http://127.0.0.1:42435/dv/static/application/1.0.0.e30a3abd2db0/application.js (5)

[1013/030606.113:INFO:CONSOLE(0)] "Autofocus processing was blocked because a document already has a focused element.", source: http://127.0.0.1:42435/dv/home.jsp?pageid=home (0)

[1013/041149.823:INFO:CONSOLE(6)] "obitech.appservices/eventmanager/ERROR: Error during non-accumulated event publishing: ActionContext initialization failed because we do not currently support multiple actions

    at new h (http://127.0.0.1:42435/dv/static/application/1.0.0.e30a3abd2db0/application.js:1:11587)

    at http://127.0.0.1:42435/dv/static/application/1.0.0.e30a3abd2db0/application.js:22:7585

    at new L (http://127.0.0.1:42435/dv/static/application/1.0.0.e30a3abd2db0/application.js:22:8197)

  at T.Y._addDatasourceToProjectHandler

OBIPS Logs:

[2021-10-13T03:07:14-07:00] [OBIPS] [ERROR:31] [] [saw.soap.xmlviewservice] [ecid: ] [tid: 6308] [SI-Key: ssi] [userId: weblogic] Error occurred while processing the query.

Odbc driver returned an error (SQLExecDirectW).

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: 47107. [nQSError: 47107] Driver Vertica is not installed on your system. (HY000)

OBIS Logs:

[2021-10-13T04:29:54.091-07:00] [OBIS] [TRACE:2] [USER-34] [] [ecid: ] [sik: ssi] [tid: 132c] [messageId: USER-34] [requestid: 747b0003] [sessionid: 747b0000] [username: weblogic] -------------------- Query Status: [nQSError: 46283] An HTTP operation timed out after 60 seconds. Operation aborted. [[

[nQSError: 46281] Failed to download metadata for dataset 'weblogic'.'Vertica_ODBC'.

[nQSError: 43119] Query Failed:

OBIS Diagnostics:

[2021-10-13T03:05:13.625-07:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 1b00] [nQSError: 100041] Failed to read data from Java Datasource server. [[

file: server\Utility\JavaIntegration\Src\SUJIHTTPStream.cpp; line: 238