**VIEWDATA ROW LIMITER HIT**

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sriragz
Participant
Posts: 2
Joined: Tue Sep 07, 2010 11:35 pm

**VIEWDATA ROW LIMITER HIT**

Post by sriragz »

Hi,

My job consists of a Oracle enterprise stage and Sequential file.
I am Unable to view the data in the Sequential file.

Below is the error:

##I IIS-DSEE-TFCN-00001 13:53:00(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved



##I IIS-DSEE-TUTL-00031 13:53:00(001) <main_program> The open files limit is 15000; raising to 16000.
##I IIS-DSEE-TOSH-00002 13:53:00(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 13:53:00(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 13:53:00(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 13:53:00(005) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I IIS-DSEE-TFSC-00001 13:53:00(011) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/4node.apt
##I IIS-DSEE-TOIX-00163 13:53:01(000) <Seq_PS_Vendor,0> Import complete; 0 records imported successfully, 0 rejected.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 13:53:01(001) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 13:53:01(002) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
##I IIS-DSEE-USBP-00001 13:53:01(000) <APT_CombinedOperatorController,0> called postFinalRunLocally
>##E IIS-DSEE-TFOR-00089 13:53:01(003) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
>##E IIS-DSEE-TFPM-00040 13:53:01(004) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E IIS-DSEE-TFSC-00011 13:53:07(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 13:53:07(001) <main_program> Startup time, 0:06; production run time, 0:01.


Can anybody tell me how to resolve this issue.

Thanks In Advance!!
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Are you certain that the sequential file exists and is not empty at the time when you are trying to do a "view data"?
##I IIS-DSEE-TOIX-00163 13:53:01(000) <Seq_PS_Vendor,0> Import complete; 0 records imported successfully, 0 rejected.
Post Reply