cannot veiw data

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
tanaya.deshpande@tieto.co
Participant
Posts: 94
Joined: Sun Jul 18, 2010 11:35 pm

cannot veiw data

Post by tanaya.deshpande@tieto.co »

Hi

I am not able to view data from a dataset this is the error it gives

##I IIS-DSEE-TFCN-00001 09:00:38(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 09:00:38(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=FIHEL-S-TE00047; -m=Pentium
##I IIS-DSEE-TOSH-00002 09:00:38(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 09:00:38(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 09:00:38(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 09:00:38(005) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I IIS-DSEE-TFSC-00001 09:00:38(010) <main_program> APT configuration file: C:/IBM/InformationServer/Server/Configurations/default.apt
##I IIS-DSEE-TFSU-00016 09:00:38(011) <main_program>
This step has 2 datasets:
ds0: {F_Personnel_pre
eAny=>eCollectAny
op0[2p] (parallel input repartition(0))}
ds1: {op0[2p] (parallel input repartition(0))
>>eCollectAny
op1[1p] (sequential APT_CombinedOperatorController:_EowGenerator)}

It has 2 operators:
op0[2p] {(parallel input repartition(0))
on nodes (
node1[op0,p0]
node2[op0,p1]
)}
op1[1p] {(sequential APT_CombinedOperatorController:
(_EowGenerator)
(_Head)
(_PEEK_IDENT_)
(_ABORT_IDENT_)
) on nodes (
node1[op1,p0]
)}
It runs 3 processes on 2 nodes.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 09:00:39(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 09:00:39(001) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
>##E IIS-DSEE-TFOR-00089 09:00:39(002) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
>##E IIS-DSEE-TFPM-00040 09:00:39(003) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
##I IIS-DSEE-USBP-00001 09:00:39(000) <APT_CombinedOperatorController,0> called postFinalRunLocally
>##E IIS-DSEE-TFSC-00011 09:00:46(000) <main_program> Step execution finished with status = FAILED.
##I IIS-DSEE-TCOS-00026 09:00:46(001) <main_program> Startup time, 0:06; production run time, 0:02.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What are the stage types in your design?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
tanaya.deshpande@tieto.co
Participant
Posts: 94
Joined: Sun Jul 18, 2010 11:35 pm

Post by tanaya.deshpande@tieto.co »

I have Transformer,SQLServer stage,funnel stage ,lookup stage, Sort stage, Aggregrator stage
tanaya.deshpande@tieto.co
Participant
Posts: 94
Joined: Sun Jul 18, 2010 11:35 pm

Post by tanaya.deshpande@tieto.co »

These are the errors

##E IIS-DSEE-TFOR-00089 09:17:02(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFOR-00089 09:17:02(002) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 09:17:02(003) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
##E IIS-DSEE-TFSC-00011 09:17:09(000) <main_program> Step execution finished with status = FAILED
austin_316
Participant
Posts: 80
Joined: Fri Aug 21, 2009 7:49 am
Location: India

cannot veiw data

Post by austin_316 »

probably there is no data in the dataset :?.
we also get this error when there is no data in the dataset.
Post Reply