This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Incorta Community
- Knowledge
- Administration Knowledgebase
- Oracle Connection is not working after Upgrade to ...
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
.png "Employee"){kind=icon}
ahmedezzeldeen
Employee
Options
- Article History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 08-20-2024 02:43 PM
The below issue occurred for a few customers after upgrading to 2024.1.0 .
Issue
Oracle DB connections test is failing.
The exception is found the logs as below :
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:82)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.webapi.SessionCookieConfigFilter.doFilter(SessionCookieConfigFilter.java:49)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.webapi.IncortaCorsFilter.doFilter(IncortaCorsFilter.java:86)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at java.lang.Thread.run(Thread.java:750)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] Caused by: com.incorta.connector.errors.FailedConnectionException: Failed to connect to [Audit_DB] due to: ONS configuration failed [com.incorta.webapi.AbstractServlet.writeError]
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.getConnection(SQLConnector.java:619)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.testConnection(SQLConnector.java:1502)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.ConnectorDecorator.testConnection(ConnectorDecorator.java:62)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.ConnectorHandler.testConnection(ConnectorHandler.java:503)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.DataManagerImpl.testConnectorConnection(DataManagerImpl.java:601)
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] ... skipped 74 common traces
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] Caused by: java.sql.SQLException: ONS configuration failed [com.incorta.webapi.AbstractServlet.writeError]
ERROR: [15:10:32.521] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:332)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:744)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:676)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.getConnection(SQLConnector.java:611)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.testConnection(SQLConnector.java:1502)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.ConnectorDecorator.testConnection(ConnectorDecorator.java:62)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.ConnectorHandler.testConnection(ConnectorHandler.java:503)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.DataManagerImpl.testConnectorConnection(DataManagerImpl.java:601)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] ... skipped 74 common traces
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] Caused by: java.lang.IllegalArgumentException: ONS configuration failed [com.incorta.webapi.AbstractServlet.writeError]
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.simplefan.impl.FanManager.configure(FanManager.java:108)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.configure(HAManager.java:146)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.<init>(HAManager.java:122)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.getInstance(HAManager.java:126)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.enableHAIfNecessary(HAManager.java:725)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:713)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:744)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:676)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.getConnection(SQLConnector.java:611)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.testConnection(SQLConnector.java:1502)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.ConnectorDecorator.testConnection(ConnectorDecorator.java:62)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.ConnectorHandler.testConnection(ConnectorHandler.java:503)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.DataManagerImpl.testConnectorConnection(DataManagerImpl.java:601)
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] ... skipped 74 common traces
ERROR: [15:10:32.522] [11317] [ | admin | POST/service/datasource/testConnection] Caused by: oracle.ons.NoServersAvailable: Subscription time out [com.incorta.webapi.AbstractServlet.writeError]
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.ons.NotificationNetwork.waitUntilOnline(NotificationNetwork.java:96)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.ons.ONS.init(ONS.java:96)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.ons.ONS.<init>(ONS.java:154)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.simplefan.impl.FanManager$1.run(FanManager.java:102)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.simplefan.impl.FanManager$1.run(FanManager.java:100)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at java.security.AccessController.doPrivileged(Native Method)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.simplefan.impl.FanManager.configure(FanManager.java:100)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.configure(HAManager.java:146)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.<init>(HAManager.java:122)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.getInstance(HAManager.java:126)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.HAManager.enableHAIfNecessary(HAManager.java:725)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:713)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:744)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:676)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.getConnection(SQLConnector.java:611)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.sql.SQLConnector.testConnection(SQLConnector.java:1502)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.connector.ConnectorDecorator.testConnection(ConnectorDecorator.java:62)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.ConnectorHandler.testConnection(ConnectorHandler.java:503)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] at com.incorta.server.data.DataManagerImpl.testConnectorConnection(DataManagerImpl.java:601)
ERROR: [15:10:32.523] [11317] [ | admin | POST/service/datasource/testConnection] ... skipped 74 common tracesSolution
Add the property oracle.jdbc.fanEnabled=false to the connection Properties and resave the connection.
Labels:
