ODBC stage fetches only 1 row

just4geeks · Post by **just4geeks** » Thu May 03, 2007 7:42 am

I am using a ODBC Enterprise Stage to read data off of a Oracle database. When I click on "view data", it shows only 1 row. Even though I choose 30 rows to display in the data browser.

When I looked into the table via Toad, I see it contains more than a 1000 rows. Does anyone have any ideas? Thanks for your time....

Edwink · Post by **Edwink** » Thu May 03, 2007 8:10 am

what is query you are using to fetch the data?

just4geeks · Post by **just4geeks** » Thu May 03, 2007 8:13 am

Edwink wrote:what is query you are using to fetch the data?

I dont have a query. The read method is a table. I read the table and dump the results into a flat file.

Edwink · Post by **Edwink** » Thu May 03, 2007 8:32 am

do you have the options set inthe ODBC stage like fetch array size =1?

just4geeks · Post by **just4geeks** » Thu May 03, 2007 8:54 am

Edwink wrote:do you have the options set inthe ODBC stage like fetch array size =1?

I hadn't set fetch array size earlier. Now even after setting it to 10, I get only 1 row.

DSguru2B · Post by **DSguru2B** » Thu May 03, 2007 9:23 am

WHat happens when you run the job. Do all the records get processed?

just4geeks · Post by **just4geeks** » Thu May 03, 2007 10:40 am

DSguru2B wrote:What happens when you run the job. Do all the records get processed?

It runs successfully processing all the rows which are more than 2 million. When I do a view data on the seq file stage asking for 30 rows, I only get 15 rows.

Any idea what is causing this discrepancy? Thanks for your time.....

DSguru2B · Post by **DSguru2B** » Thu May 03, 2007 10:44 am

When you view data, make sure your Skip Count is set to 0 and Period is set to 1.

just4geeks · Post by **just4geeks** » Thu May 03, 2007 10:49 am

DSguru2B wrote:When you view data, make sure your Skip Count is set to 0 and Period is set to 1.

Yes, I made sure that the skip count is 0 and Period is set to 1. I get the same error again, i.e. lesser number of rows than I asked for.

When I do a view count on the seq file stage asking for 30, I get 15, asking for 40, I get 26 and finally asking for 60, I get exactly 60 rows.

DSguru2B · Post by **DSguru2B** » Thu May 03, 2007 11:23 am

Is this the only job thats behaving like this. If yes then I have no idea whats going on, without further detective work. Delete the job and rebuild it. See if this behaviour goes away.