Oracle Retrieve schema doesn't work

[Anonymous]

Hi.

I have upgrade talend version from 5.3 to 6.5.1

I have import the oracle db connection from the previous version. If I use the table already in the table schema as toracleinput the job work correctly.

If I try to add a new table in the retrieve schema like the figure above

but no table is in my table list

If I try to add schema directly from the schema list like the table "PROVA"

when I press the finish button I have this error

Why this?

Monica

[Anonymous · Accepted solution]

Hello,

Are you able to create a new oracle DB connection and retrieve schema on v 6.5 successfully ?

Best regards

Sabrina

[Anonymous]

Hello - I am experience the same with Oracle 12.1x.

I have the Oracle 12.1x sid connector working and a simple "select * from scott.dept" query working.

The "retrieve schema" for SCOTT however does not work.

What am I doing wrong? Sorry for missing the obvious. Thanks AR

[Anonymous]

Hello @ar ,

Could you please indicate on which talend build version you got this issue?

Best regards

Sabrina

[Anonymous]

Hi Sabrina

Build Ver: TOS_DI-20181218_1206-V7.2.1M1

from: https://www.talend.com/products/data-integration-manuals-release-notes/

[Anonymous]

Hello @ar ,

The M1 of Talend Open Studio v7.2.1 is milestone version and for testing only. Could you please try to use released version 7.1.1 to see if this issue repro?

Best regards

Sabrina

[Anonymous]

Hi Sabrina...7.1.1.x error attached with [next] button disabled during interactive view schema:

Oracle 12.102 on Centos6.6 inside MAC fusion.  

[Anonymous]

Hello,

We are supposing that you have already checked this online user guide about:TalendHelpCenter:Retrieving table schemas

Did you enter the filter you want to use in the dialog box?

Best regards

Sabrina

[Anonymous]

Yes I did.

I have the demo working with Oracle during interactive sessions... I just won't show the "touch a button for schema stuff" in the demo.

Have a custom module doing some #ai with text analytics running in the demo. You have a great software, easy to use. 

Cheers! ar

[Anonymous]

Hello,

Is there any permission issue for your table?

Best regards

Sabrina