AMC on Oracle -- talendMeter_DB IO Error: Connection reset

Six Stars

AMC on Oracle -- talendMeter_DB IO Error: Connection reset

Hi, 

On longer running jobs, I keep getting a FATAL error with the message "talendMeter_DB IO Error: Connection reset". I know it is the AMC connection because if I turn the AMC off and run the job it completes without this error. 

Does anyone know how to fix this issue? 

We're using an Oracle ODA 12c for the AMC database.

Thanks!

Croix


Accepted Solutions
Six Stars

Re: AMC on Oracle -- talendMeter_DB IO Error: Connection reset

Yes, I've already created a case with support. 

Thank you!

Six Stars

Re: AMC on Oracle -- talendMeter_DB IO Error: Connection reset

I figured this issue out. 

 

After I put a tFlowMeter and a tFlowMeterCatcher and wrote it to the AMC I stopped getting this error.

The way that I figured it out was that I looked in the flow meter table in the AMC database and noticed that there were almost no entries when I ran the job. I looked into it and figured out that the tFlowMeter and tFlowMeterCatcher wrote data to this table.

 

So, I think it was timing out because nothing was writing to the table. When I put these two components into the job and pointed them to the AMC flow meter table, the error went away.

 

 


All Replies
Moderator

Re: AMC on Oracle -- talendMeter_DB IO Error: Connection reset

Hello,

Could you please clarify in which Talend version/edition you are?

Here is online installation guide V 6.5 about:TalendHelpCenter:Compatible databases.

Could you please refer it to see if your Oracle ODA 12c is in the supported list?

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.
Six Stars

Re: AMC on Oracle -- talendMeter_DB IO Error: Connection reset

Hi,

 

The page connected to the link you shared said that Oracle 12c, the version we have, is not only supported but recommended so that's good.

The version of Talend we are using is the Talend Big Data Platform 6.2.1.

Thanks

Moderator

Re: AMC on Oracle -- talendMeter_DB IO Error: Connection reset

Hello,

With your Talend Big Data Platform 6.2.1 subscription solution, could you please create a case on talend support portal so that we can give you a remote assistance on your AMC Oracle DB connection issue 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.
Six Stars

Re: AMC on Oracle -- talendMeter_DB IO Error: Connection reset

Yes, I've already created a case with support. 

Thank you!

Six Stars

Re: AMC on Oracle -- talendMeter_DB IO Error: Connection reset

I figured this issue out. 

 

After I put a tFlowMeter and a tFlowMeterCatcher and wrote it to the AMC I stopped getting this error.

The way that I figured it out was that I looked in the flow meter table in the AMC database and noticed that there were almost no entries when I ran the job. I looked into it and figured out that the tFlowMeter and tFlowMeterCatcher wrote data to this table.

 

So, I think it was timing out because nothing was writing to the table. When I put these two components into the job and pointed them to the AMC flow meter table, the error went away.

 

 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download