Oracle Analytics Cloud and Server

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

Getting error while creating datasource in OBI console

Received Response
31
Views
5
Comments
User_B7ZTH
User_B7ZTH Rank 5 - Community Champion

Hello Experts,

We have upgraded our OBI environment to Oracle Business Intelligence 12.2.1.3.0.

We are getting below error while creating the datasource in OBI Console:-

Could not establish a connection because of java.lang.IllegalArgumentException: ONS configuration failed<br/>weblogic.jdbc.common.internal.DataSourceUtil.testConnection0(DataSourceUtil.java:423)<br/>weblogic.jdbc.common.internal.DataSourceUtil.access$000(DataSourceUtil.java:24)<br/>weblogic.jdbc.common.internal.DataSourceUtil$1.run(DataSourceUtil.java:285)<br/>java.security.AccessController.doPrivileged(Native Method)<br/>weblogic.jdbc.common.internal.DataSourceUtil.testConnection(DataSourceUtil.java:282)<br/>com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:937)<br/>com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:524)<br/>sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br/>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br/>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br/>java.lang.reflect.Method.invoke(Method.java:498)<br/>org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870)<br/>org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)<br/>org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)<br/>org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)<br/>org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)<br/>org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)<br/>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)<br/>org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)<br/>org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)<br/>...

I have tried to google it and got the below link

https://stackoverflow.com/questions/48294023/weblogic-12c-database-connection-error

But its not helping we are getting the same error.

Can anyone have idea, do i need to configure anything extra in configuration file.

Thanks & Regards,

Abhi

Answers