ERROR Reading source file

pkll · Post by **pkll** » Wed Apr 10, 2013 9:52 pm

Hi,

When i am reading file from source i am getting bellow error..

My souce file has 13KB(32,000 records) only,delimiter is '|'.
For testing purpose i have taken 10 rows it is working fine,when i have given total file the bellow error is coming.

Let me know why i am getting this error?

##E IIS-DSEE-TOIX-00158 09:12:50(000) <CALL_HIST_DETAILS_6868081,1> Error reading on import.
##E IIS-DSEE-TFRS-00061 09:12:50(001) <CALL_HIST_DETAILS_6868081,1> Consumed more than 100000 bytes looking for record delimiter; aborting
##E IIS-DSEE-TOIX-00179 09:12:50(002) <CALL_HIST_DETAILS_6868081,1> Import error at record 0.
##E IIS-DSEE-TFOR-00089 09:12:50(003) <CALL_HIST_DETAILS_6868081,1> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 09:12:50(005) <CALL_HIST_DETAILS_6868081,1> Operator terminated abnormally: runLocally() did not return APT_StatusOk
##E IIS-DSEE-TOIX-00158 09:12:50(000) <CALL_HIST_DETAILS_6868081,0> Error reading on import.
##E IIS-DSEE-TFRS-00061 09:12:50(001) <CALL_HIST_DETAILS_6868081,0> Consumed more than 100000 bytes looking for record delimiter; aborting
##E IIS-DSEE-TOIX-00179 09:12:50(002) <CALL_HIST_DETAILS_6868081,0> Import error at record 0.
##E IIS-DSEE-TFOR-00089 09:12:50(003) <CALL_HIST_DETAILS_6868081,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 09:12:50(005) <CALL_HIST_DETAILS_6868081,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
##E IIS-DSEE-TFOR-00089 09:12:50(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 09:12:50(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
##E IIS-DSEE-TFPM-00192 09:12:56(000) <node_node1> Player 2 terminated unexpectedly.
##E IIS-DSEE-TFPM-00339 09:12:56(000) <main_program> APT_PMsectionLeader(1, node1), player 2 - Unexpected termination by Unix signal 6(SIGABRT).
##E IIS-DSEE-TFPM-00192 09:12:56(001) <node_node1> Player 1 terminated unexpectedly.
##E IIS-DSEE-TFPM-00339 09:12:56(001) <main_program> APT_PMsectionLeader(1, node1), player 1 - Unexpected termination by Unix signal 6(SIGABRT).
##E IIS-DSEE-TFPM-00192 09:12:56(000) <node_node2> Player 3 terminated unexpectedly.
##E IIS-DSEE-TFSC-00011 09:13:01(000) <main_program> Step execution finished with status = FAILED.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 10, 2013 9:54 pm

Check the file. It appears that "|" is not the delimiter or, if it is, that you have not specified this as the field delimiter property in the format properties of your Sequential File stage.

Ten rows were not enough to hit the 100000 byte barrier.

pkll · Post by **pkll** » Wed Apr 10, 2013 10:03 pm

Hi Ray,

My delimeter is '|'. I specified field delimeter as '|' in sequential file format tab.

I am getting same error...

chulett · Post by **chulett** » Wed Apr 10, 2013 10:39 pm

It's looking for the record delimiter, not a field delimiter. How is that defined in your stage? It would seem your ten row sample is structured differently from the full file.

pkll · Post by **pkll** » Wed Apr 10, 2013 10:54 pm

Thanks chulett...

It is working 5n...

BI-RMA · Post by **BI-RMA** » Thu Apr 11, 2013 3:31 am

Hi pkll,

Could you please add some details on the changes you made that actually caused your job to work? This would be helpful for others searching for solutions in this forum.

Please mark the topic as resolved after that.