DSXchange

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.

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?

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.

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.

Are you sure you are writing to a sequential file stage - the posted log shows a peek stage.

Yes,Iam writing it in a Sequential stage only.

try specifying 'Field Delimiter' = end instead of 'Record Delimiter'=end

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?

Do you have a peek stage in your job?