**VIEWDATA ROW LIMITER HIT**

[sumit.tiwari]

Hi,

I have bunch of file to load and I am using file pattern to read all the files.
When I am reading all the files togather I am getting "VIEW DATA LIMILTER HIT"... I have tried diferent patterns to read small groups of files, It is working fine but when I am giving the pattern to read all the files togather I am getting this error.

Pls suggest Is there any parameter do I need to set?

Below mentioned is the error I am getting.


##I TFCN 000001 12:33:16(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TUTL 000031 12:33:16(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 12:33:16(002) <main_program> orchgeneral: loaded
##I TOSH 000002 12:33:16(003) <main_program> orchsort: loaded
##I TOSH 000002 12:33:17(000) <main_program> orchstats: loaded
##I TFSC 000001 12:33:17(001) <main_program> APT configuration file: /etlstg/dshome/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 12:33:37(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000202 12:34:05(000) <MSISDN,0> Couldn't find any files on host eisdbt with pattern /etlstg/SMG/RC/ZERO_USG/file_run/MSISDN_REPORT_SSC_CU*.TXT.
**VIEWDATA ROW LIMITER HIT**


Attaching the OSH also.

#### STAGE: MSISDN.msisdn_rej_Copy
## Operator
copy
## General options
[ident('MSISDN.msisdn_rej_Copy'); jobmon_ident('MSISDN.msisdn_rej_Copy')]
## Inputs
0< 'MSISDN:msisdn_rej.v'
;

#################################################################
#### STAGE: MSISDN
## Operator
import
## Operator options
-schema record
{final_delim=end, delim='\t', quote=none}
(
Acc_external_id:string[max=255];
AC_ACTIVE_DATE:string[max=10];
MOBILE_NO:string[max=20] {quote=none};
STATUS:string[max=255];
)
-keepPartitions
-rejects save
-reportProgress yes
-firstLineColumnNames
-filepattern '/etlstg/SMG/RC/ZERO_USG/file_run/MSISDN_REPORT_SSC_CU*.TXT'

## General options
[ident('MSISDN'); jobmon_ident('MSISDN')]
## Outputs
0> [] 'MSISDN:msisdn.v'
1> [] 'MSISDN:msisdn_rej.v'
;

#### STAGE: _Head
## Operator
head -nrecs 99
## General options
[ident('_Head'); jobmon_ident('_Head'); seq]
## Inputs
0< 'MSISDN:msisdn.v'
## Outputs
0> [] 'MSISDN:msisdn_Head.v'
;

#### STAGE: _PEEK_IDENT_
## Operator
peek -all -delim '%%PEEK%%DELIM%%' -field Acc_external_id -field AC_ACTIVE_DATE -field MOBILE_NO -field STATUS
## General options
[ident('_PEEK_IDENT_'); jobmon_ident('_PEEK_IDENT_'); seq]
## Inputs
0< 'MSISDN:msisdn_Head.v'
## Outputs
0> [] 'MSISDN:msisdn_Head_PEEK_IDENT_.v'
;

#### STAGE: _ABORT_IDENT_
## Operator
abort -nrecs 99
## General options
[ident('_ABORT_IDENT_'); jobmon_ident('_ABORT_IDENT_'); seq]
## Inputs
0< 'MSISDN:msisdn_Head_PEEK_IDENT_.v'
;

[ray.wurlod]

Try checking the box that says "show errors only".