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

Question

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.

User_QYX9R · Answer

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.
[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","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.
[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","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

Gianni Ceresa · Answer

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