You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-11-03 09:16:06

swapnadeepganguly
Member
19 posts

swapnadeepganguly said:

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

Offline

#2 2016-11-07 04:27:28

xdshi
Talend Team


xdshi said:

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


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy