Unable to connect to Oracle Database for Report Generation

Highlighted
Four Stars

Unable to connect to Oracle Database for Report Generation

Hi,
We are using Talend Big Data Platform v6.1.1.20151214_1327. In that we have performed some Columnar Analysis on certain tables. Now we would like to generate the Report for that Analysis. 
In the Report Settings, under "Database Connection Settings", we are giving db type as "Oracle with SID" and providing all the details as required. However, when we are checking for this connection, we are getting the following error:

!ENTRY org.talend.platform.logging 4 0 2016-11-02 14:48:50.144
!MESSAGE 2016-11-02 14:48:50,144 ERROR org.hibernate.tool.hbm2ddl.SchemaExport  - schema export unsuccessful

!STACK 0
org.hibernate.JDBCException: Error during import script execution
      at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:258)
      at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:192)
      at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
      at org.talend.dataprofiler.datamart.utils.DatamartUtils.create(DatamartUtils.java:560)
      at org.talend.dataprofiler.datamart.utils.DatamartUtils.createDatamartForOthers(DatamartUtils.java:659)
      at org.talend.dataprofiler.datamart.utils.DatamartUtils.createDatamart(DatamartUtils.java:632)
      at org.talend.dataprofiler.datamart.utils.DatamartUtils.createDatamart(DatamartUtils.java:1318)
      at org.talend.dataprofiler.core.tdq.ui.helper.DatamartHelper.handleDatamart(DatamartHelper.java:74)
      at org.talend.dataprofiler.core.tdq.ui.editor.report.ReportMasterDetailsPage$14$1$1.run(ReportMasterDetailsPage.java:765)
      at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
      at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)
      at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)
      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
      at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
      at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
      at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
      at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
      at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
      at org.talend.rcp.intro.Application.start(Application.java:197)
      at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
      at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
      at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
      at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
      at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
      at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:254)
      ... 33 more

This is the first time when we are trying to connect to that database using these values. Still its showing "name is already used by an existing object". 

However, when we use HSQL and check, everything works fine as we get the message "Connection successful and Data Mart well configured". 

Could you please help us to get the Data Mart configured in our oracle database? Also, do you have the list of tables that are generally created during the first run. By that atleast I can check if these tables are currently existing or not. Any help in this regards is highly appreciated.

Thanks,
Swapnadeep Ganguly
Moderator

Re: Unable to connect to Oracle Database for Report Generation

Hi,
For your Talend Big Data Platform v6.1.1.20151214_1327 product, have you already reported a ticket on talend support portal? In this way, we can give you a remote assistance through support cycle with priority.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read