Some problem in Sequntial file???

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed Oct 24, 2007 5:21 am

Hi,
We are facing a problem while reading the sequntial file.We have a single column in the sequential file whic has few records, but when we click to "view data" it is showing me following errors:

##I TUTL 000031 11:16:16(001) <main_program> The open files limit is 100; raising to 8192.
##I TOSH 000002 11:16:16(002) <main_program> orchgeneral: loaded
##I TOSH 000002 11:16:16(003) <main_program> orchsort: loaded
##I TOSH 000002 11:16:16(004) <main_program> orchstats: loaded
##I TFSC 000001 11:16:16(005) <main_program> APT configuration file: /tools/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 11:16:17(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TOIX 000163 11:16:18(000) <Sequential_File_6,0> Import complete; 2 records imported successfully, 0 rejected.
**VIEWDATA ROW LIMITER HIT**

We are unable to see the data but when we run the job....which is having same sequntial file as source and another seq file (target) , in the director we can see 2 records inserted sucessfully....

Can anybody tell us why we can not view the data even though job is running fine( data is getting populated in the target )???

Maveric · Post by **Maveric** » Wed Oct 24, 2007 5:44 am

Looking at this

"##I TOIX 000163 11:16:18(000) <Sequential_File_6,0> Import complete; 2 records imported successfully, 0 rejected.
**VIEWDATA ROW LIMITER HIT** "

to me it looks like you might have given the property "Skip Count" or "Period". Check the view data options and try again.

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed Oct 24, 2007 6:24 am

No i almost check each and every option still i am unable to view the records.
The problem is occuring for this job only, other jobs are working fine.
In the properties i have made the only change..that is
"Read Method= File Pattern" , rest everthing is same....

roy · Post by **roy** » Wed Oct 24, 2007 1:06 pm

Hi,
Can you try closing your designer and openning a new one?
Is it a new client installation that someone forgot installing the XP SP2 patch on?

IHTH,

AmeyJoshi14 · Post by **AmeyJoshi14** » Thu Oct 25, 2007 2:11 am

I have tried it but still it is not working....

Can anybody knows what exactly happening....??

vikasjawa · Post by **vikasjawa** » Thu Oct 25, 2007 4:40 am

Hi,
The message "**VIEWDATA ROW LIMITER HIT** "comes up when the file you are trying to view is empty.Please check that your skip count is "0" and Period "1" while viewing the data.

AmeyJoshi14 · Post by **AmeyJoshi14** » Thu Oct 25, 2007 7:03 am

vikasjawa wrote:Hi,
The message "**VIEWDATA ROW LIMITER HIT** "comes up when the file you are trying to view is empty.Please check that your skip count is "0" and Period "1" while viewing the data.

Thanks buddy it is working...