topic Re: Error Logcatcher and Flowmetercatcher using synonym in Oracle in Talend Studio

Error Logcatcher and Flowmetercatcher using synonym in Oracle

Anonymous — Sat, 16 Nov 2024 10:57:24 GMT

Hello together,
we have one technical user for Talend which we use to connect with our Oracle database.
The tables are in different schemes, but the technical user has grants for SELECT, INSERT, UPDATE, DELETE to the tables.
Also tables LOGCATCHER and FLOWCATCHER in a different scheme. We have created synonyms for these tables.
We also activated tLogCatcher and tFlowCatcher in the project preferences.
The Synonyms we have imported us Metadata.
Unfortunately we got an error starting our jobs. It is an Oracle that we have no rights in this tables.
Is there a problem using synonyms for LOGCATCHER or FLOWCHATCHER?
Using synonyms in jobs is no problem. We can insert or update data.
We are using version 5.6.1 of Talend.
Thanks for information,
Gimli

Re: Error Logcatcher and Flowmetercatcher using synonym in Oracle

Anonymous — Wed, 11 Nov 2015 09:49:27 GMT

Hi,

Also tables LOGCATCHER and FLOWCATCHER in a different scheme. We have created synonyms for these tables.
We also activated tLogCatcher and tFlowCatcher in the project preferences.
The Synonyms we have imported us Metadata.
Unfortunately we got an error starting our jobs. It is an Oracle that we have no rights in this tables.

Do you have administrator role in oracle? Could you please post your job setting screenshots into forum? What's the error info you are facing?
More information about your current situation will be helpful for us to address your issue.
Best regards
Sabrina

Re: Error Logcatcher and Flowmetercatcher using synonym in Oracle

Anonymous — Wed, 18 Nov 2015 14:51:52 GMT

Hi Sabrina,
it seems that Talend tries to find the table FLOWMETERCATCHER and don't uses the Synonym we have created for this table.
That's why Talend tries to create this table. But the database user which Talend uses has no rightsto create tables. Thats
why we got an Oracle-Error: ORA-01031: insufficient privileges.

After we give the database user the rights to create tables, Talend tries to create the table, but got the error
ORA-00955: name is already used by an existing object
That is right because a synonyme with this name exists.

The question is why Talend didn't uses this synonym.
Kind regards,
Gimli

Re: Error Logcatcher and Flowmetercatcher using synonym in Oracle

Anonymous — Thu, 19 Nov 2015 03:45:37 GMT

Hi,
Are you using open studio or subscription product? Does this issue repro on the latest version 6.1?
Is it working well without using synonym in oracle?
Best regards
Sabrina

Re: Error Logcatcher and Flowmetercatcher using synonym in Oracle

Anonymous — Thu, 19 Nov 2015 08:10:49 GMT

Hi Sabrina,
we use subscription product. We didn't test with 6.1 because we didn't have installed 6.1 here.
If we use it without synonym and use table instead it works fine.
Kind regards,
Stefan

Re: Error Logcatcher and Flowmetercatcher using synonym in Oracle

Anonymous — Thu, 19 Nov 2015 08:23:22 GMT

Hi,
Could you please report a ticket on Talend Support Portal so that our colleagues from support team will check it to see if it is a bug?
https://support.talend.com/otrs/customer.pl
Best regards
Sabrina

Re: Error Logcatcher and Flowmetercatcher using synonym in Oracle

Anonymous — Wed, 25 Nov 2015 13:10:14 GMT

Hi Sabrina,
we have created a ticket on Talend Support Portal.
Kind regards,
Stefan