
Anonymous
Not applicable
2011-02-25
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create New Database Connection - Oracle w/ SID - Can't "Finish."
Hi,
I am new to Open Profiler and am running v 4.1.2.r53616. I am creating a database connection for Oracle w/ SID.
I test the connection and it is successful.
When I click "Finish" in the wizard, nothing happens. I can go back, or I can cancel - but clicking finish accomplishes nothing and the connection does not appear to be made in my DQ Repository.
Any help out there?
Thanks,
Kelly
I am new to Open Profiler and am running v 4.1.2.r53616. I am creating a database connection for Oracle w/ SID.
I test the connection and it is successful.
When I click "Finish" in the wizard, nothing happens. I can go back, or I can cancel - but clicking finish accomplishes nothing and the connection does not appear to be made in my DQ Repository.
Any help out there?
Thanks,
Kelly
474 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
10 Replies

Anonymous
Not applicable
2011-02-25
07:38 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
Please upload the log file which locates on <TDQ installation directory>/workspace/.metadata/
Best regards
Shong
Please upload the log file which locates on <TDQ installation directory>/workspace/.metadata/
Best regards
Shong
398 Views

Anonymous
Not applicable
2011-03-01
12:11 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The AE with the lead has also asked me to check into this. I will simulate a connection and post when I can profile Oracle Express tables.
398 Views

Anonymous
Not applicable
2011-03-01
12:14 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks; I appreciate it.
398 Views

Anonymous
Not applicable
2011-03-01
12:30 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have already e-mailed a reply but for other users with Oracle connection issues, here is a sample of a fully functioning connection to the sample HR database found in Express.
398 Views

Anonymous
Not applicable
2011-03-10
10:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
I am using TOS version 4.1.2.453616. I am getting the same problem mentioned in the post
"Create New Database Connection - Oracle w/ SID - Can't "Finish.""
However I should point out that my New DB Connection Screen doesn't look the same as the one uploaded by rmorris from the Talend Team !
My problem : Doesn't "Finish" the new db connection using Oracle. I have the same issue with both Oracle with SID as well as Oracle with ServiceName.
My screen has DB Type as the first element on the window
Can someone help me with this, please?
Thanks
Pady
I am using TOS version 4.1.2.453616. I am getting the same problem mentioned in the post
"Create New Database Connection - Oracle w/ SID - Can't "Finish.""
However I should point out that my New DB Connection Screen doesn't look the same as the one uploaded by rmorris from the Talend Team !
My problem : Doesn't "Finish" the new db connection using Oracle. I have the same issue with both Oracle with SID as well as Oracle with ServiceName.
My screen has DB Type as the first element on the window
Can someone help me with this, please?
Thanks
Pady
398 Views

Anonymous
Not applicable
2011-03-10
11:49 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Pady,
My issue remains open, despite trying a number of suggestions. It's still got me stumped, but unfortunately I don't have a ton of time to spend troubleshooting it. Hopefully we'll get an answer.
My issue remains open, despite trying a number of suggestions. It's still got me stumped, but unfortunately I don't have a ton of time to spend troubleshooting it. Hopefully we'll get an answer.
398 Views

Anonymous
Not applicable
2011-03-10
02:02 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
Here's an update.
Instead of the Open Studio - I used the Open Profiler and now I get the same screen as the one posted by the talend team member.
I also got an error message now. It says:
"Check connection failure: Failed to create a data provider for the given connection parameters:Io Exception: The Network Adapter could not establish the connection"
I am able to connect to Oracle using SQLPlus and other means. I am not sure if the problem could be occuring because the port we have defined for our oracle system is 1550 instead of 1521 as shown in the example. But my thinking is that it shouldn't matter.
Thanks
Here's an update.
Instead of the Open Studio - I used the Open Profiler and now I get the same screen as the one posted by the talend team member.
I also got an error message now. It says:
"Check connection failure: Failed to create a data provider for the given connection parameters:Io Exception: The Network Adapter could not establish the connection"
I am able to connect to Oracle using SQLPlus and other means. I am not sure if the problem could be occuring because the port we have defined for our oracle system is 1550 instead of 1521 as shown in the example. But my thinking is that it shouldn't matter.
Thanks
398 Views

Anonymous
Not applicable
2011-04-28
06:46 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi All,
I have the same issue with MySQL. Tried mine on v 4.1.2.r53616 TDQ EE. I'm running TDQ on Windows 7 64bit.
Have anyone found a resolution to this issue?
I also encounter the same issue with TOP, trying to connect to MS SQL 2008. Can't click on Finish button.
I got the following error when after clicking Finish button.
Regards
I have the same issue with MySQL. Tried mine on v 4.1.2.r53616 TDQ EE. I'm running TDQ on Windows 7 64bit.
Have anyone found a resolution to this issue?
I also encounter the same issue with TOP, trying to connect to MS SQL 2008. Can't click on Finish button.
I got the following error when after clicking Finish button.
!ENTRY org.eclipse.ui 4 0 2011-04-28 23:06:24.271
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NullPointerException
at org.talend.cwm.db.connection.ConnectionUtils.getConnectionMetadata(Unknown Source)
at org.talend.dq.dbms.DbmsLanguageFactory.createDbmsLanguage(Unknown Source)
at org.talend.cwm.builders.CwmBuilder.<init>(Unknown Source)
at org.talend.cwm.builders.CwmBuilder.<init>(Unknown Source)
at org.talend.cwm.builders.DataProviderBuilder.<init>(Unknown Source)
at org.talend.cwm.db.connection.DBConnect.retrieveDriverInformations(Unknown Source)
at org.talend.cwm.db.connection.TalendCwmFactory.getTdDataProvider(Unknown Source)
at org.talend.cwm.db.connection.TalendCwmFactory.createDataProvider(Unknown Source)
at org.talend.dq.connection.DataProviderBuilder.initializeDataProvider(Unknown Source)
at org.talend.dataprofiler.core.ui.wizard.database.DatabaseConnectionWizard.initCWMResourceBuilder(Unknown Source)
at org.talend.dataprofiler.core.ui.wizard.AbstractWizard.performFinish(Unknown Source)
at org.talend.dataprofiler.core.ui.wizard.database.DatabaseConnectionWizard.performFinish(Unknown Source)
at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:752)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:373)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3880)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3473)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.talend.dataprofiler.core.ui.action.actions.CreateConnectionAction.run(Unknown Source)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3880)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3473)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.talend.dataprofiler.rcp.intro.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Regards
398 Views

Anonymous
Not applicable
2011-05-06
02:19 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello i would have a idée how to use talend to crete a datawerhouse and integrate a text in a data werehouse
398 Views

- « Previous Replies
-
- 1
- 2
- Next Replies »