Sequential stage file view error.

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
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

Sequential stage file view error.

Post by kollurianu »

Hi All ,

When I am trying to view empty file I am getting following error messages , I would expect the message to be file is emptyor just see the header column names.
Any inputs on why I am getting below messages.

It runs 1 process on 1 node.
##I TOIX 000163 12:11:25(000) <Copy_of_src_Corporate_Actions,0> Import complete; 0 records imported successfully, 0 rejected.
##I TOIX 000094 12:11:25(001) <Copy_of_src_Corporate_Actions,0> Output 0 produced 0 records.
##I TFOP 000163 12:11:25(002) <_Head,0> Input 0 consumed 0 records.
##I TFOP 000094 12:11:25(003) <_Head,0> Output 0 produced 0 records.
##I TOPK 000163 12:11:25(004) <_PEEK_IDENT_,0> Input 0 consumed 0 records.
##I TOPK 000094 12:11:25(005) <_PEEK_IDENT_,0> Output 0 produced 0 records.
**VIEWDATA ROW LIMITER HIT**

Any inputs greatly appreciated and thanks you all in advance.
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

This is not an error message. I guess this is how PX view data works ;) When the file is empty, it does not throw a message saying the file is empty. You will see 2 options on the right top corner when the message is displayed. If you check "View only error message", you will see something like

The runLocally() of the operator failed.
Kandy
_________________
Try and Try again…You will succeed atlast!!
vivekgadwal
Premium Member
Premium Member
Posts: 457
Joined: Tue Sep 25, 2007 4:05 pm

Post by vivekgadwal »

The tool will display the behavior that you mentioned if you are dealing with Server jobs. In Parallel, it will produce this elegant "ERROR" kind of a message if you View the data. It should be fine while running a job with empty source/target files.
Vivek Gadwal

Experience is what you get when you didn't get what you wanted
Post Reply