Cannot view data in Sequential stage

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
Subhasree
Participant
Posts: 11
Joined: Fri Jul 27, 2007 12:12 am

Cannot view data in Sequential stage

Post by Subhasree »

Hi all,
Iam new to IBM Information Server.I just created 1 job containg one source a.d one target sequential file and 1 transformer.
So when i run the job the target file is getting created and i can view the data in Linux.But when i use the view data option in Sequential stage for both source and target im getting the error as runlocally() operation failed.
please let me know the solution for this.
Thanks.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

There should be quite a bit more in that error message, and that information will be helpful in diagnosing what your problem is. Could you post the full error message?
G SHIVARANJANI
Participant
Posts: 137
Joined: Sun Jan 07, 2007 11:17 pm
Location: VISAKHAPATNAM

Re: Cannot view data in Sequential stage

Post by G SHIVARANJANI »

What is the source file used ? is that a csv file ?
Please check if u have given the right delimiter for reccord and field.
Subhasree wrote:Hi all,
Iam new to IBM Information Server.I just created 1 job containg one source a.d one target sequential file and 1 transformer.
So when i run the job the target file is getting created and i can view the data in Linux.But when i use the view data option in Sequential stage for both source and target im getting the error as runlocally() operation failed.
please let me know the solution for this.
Thanks.
Shivaranjani
Subhasree
Participant
Posts: 11
Joined: Fri Jul 27, 2007 12:12 am

Re: Cannot view data in Sequential stage

Post by Subhasree »

Hi,
I used the sorce file with extn .txt and i have given the record delimiter as end and field delimiter as comma.

This is the error msg im getting...

<main_program> orchgeneral: loaded
<main_program> orchsort: loaded
<main_program> orchstats: loaded
<main_program> Parameter specified but not used in flow: DSProjectMapName
<main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
<TargetFile1,0> Import complete; 3 records imported successfully, 0 rejected.
<_PEEK_IDENT_,0> --.

**VIEWDATA ROW LIMITER HIT**
<_ABORT_IDENT_,0> The runLocally() of the operator failed.
<_ABORT_IDENT_,0> Input 0 consumed 0 records.
<APT_CombinedOperatorController,0> The runLocally() of the operator failed.
<APT_CombinedOperatorController,0> called postFinalRunLocally
<APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
<main_program> Step execution finished with status = FAILED.
<main_program> Startup time, 0:05; production run time, 0:01.

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

Post by ArndW »

Are you sure you are writing to a sequential file stage - the posted log shows a peek stage.
Subhasree
Participant
Posts: 11
Joined: Fri Jul 27, 2007 12:12 am

Re: Cannot view data in Sequential stage

Post by Subhasree »

Yes,Iam writing it in a Sequential stage only.
harshada
Premium Member
Premium Member
Posts: 92
Joined: Tue May 29, 2007 8:40 am

Post by harshada »

try specifying 'Field Delimiter' = end instead of 'Record Delimiter'=end
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Cannot view data in Sequential stage

Post by gateleys »

Subhasree wrote: i can view the data in Linux.But when i use the view data option in Sequential stage for both source and target im getting the error as runlocally() operation failed.
please let me know the solution for this.
Thanks.
Is this any way related to the Win XP client and the patch that is required?
gateleys
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Do you have a peek stage in your job?
Post Reply