Cannot view data in Sequential stage
Moderators: chulett, rschirm, roy
Cannot view data in Sequential stage
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.
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.
-
- Participant
- Posts: 137
- Joined: Sun Jan 07, 2007 11:17 pm
- Location: VISAKHAPATNAM
Re: Cannot view data in Sequential stage
What is the source file used ? is that a csv file ?
Please check if u have given the right delimiter for reccord and field.
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
Re: Cannot view data in Sequential stage
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.
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.
Re: Cannot view data in Sequential stage
Yes,Iam writing it in a Sequential stage only.
Re: Cannot view data in Sequential stage
Is this any way related to the Win XP client and the patch that is required?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.
gateleys