Using tdbinput component (oracle) input query and output to csv file - Hanging

[Anonymous]

Hello Gurus,

I am trying since many days to as my dbinput as oracle (the connection is successful) in the query section I am writing a query to fetch records for August month 2018 and then I have output connection a a csv file (tFileOutputDelimited) but it is hanging to starting. Not sure why... However I have questions below.

1. Can I write a sql query in the query section of tDBInput component to fetch data for 1 month ? inside the quotes?

2. is there any other component I should be using.

I used cursor option and extended the rows to fetch but it doesn't work.

please help

[Anonymous]

Attached is the screenshot of the job from my previous post and query I am trying to run.

I'm wondering if the TX_DATE has the problem because in the database the format is 8/1/2018 12:00:00 AM for a particular record.

So I am trying to convert using to_date to a particular data format.

Am I missing anything?

Please help .

screenshot2.png

[Anonymous]

That looks OK. However, my brain is a not SQL parser and I can make mistakes 🙂 Have you tried running that query in something like TOAD? You should always try out your queries in another tool to get them to work first.

[Anonymous]

Yes , I tried this query first in TOAD and then put the same query in Open studio dbinput component.

It gets executed on Toad and hangs here...

That's the part i'm struggling with  😞

[Anonymous]

OK, if it doesn't appear to complete (or hangs) in Talend, this is not an error. In TOAD the resultset will be broken down into pages of results. The first 1000 records will be return (for example) and they will appear. But the query will continue running in the background. Try limiting the results to the TOP 1000 in Talend. To do this, add....

 AND rownum < 1000

....to your WHERE clause. This should return some records. If that works, your problem is your table probably needs indexing or you need to further filter your query

[Anonymous]

Thanks A LOT!!!!

And for all the quick responses. Rownum<1000 worked and it opened a window to fetch other records....

This has worked for me. Thanks much for your help and suggestions.

[Anonymous]

Another problem with the query.

Can't I remove some of the columns in the dbinput component query? It says schema is different  and throws a warning at my component and job fails.

Please advice.

[Anonymous]

The schema must match the selected columns and they must be in the same order. If you remove columns from the query, you will need to remove them from the schema as well

[Anonymous]

Ok, understood. Thank you for the quick one

[Anonymous]

There seems to be a problem in retrieving schemas in Talend Open Studio 7.0.1

The next and finish buttons are greyed out. and the schema is not visible as well.

I saw that this was a bug and it was solved? Any ideas if this bug still remains in OS 7.0.1 version.

I actually tried to resize the window and then tried close test connection etc. but it didn't work.

Any thoughts ? and how I can proceed....

[Anonymous]

Hello,

What's OS version are you using? I cannot reproduce this issue on my end, Win 10 64 bit. Have you tried to restart your studio to see if it is OK with you?

Best regards

Sabrina