Page 1 of 1

Complex Flat File Issue

Posted: Sun Feb 15, 2009 1:53 am
by snt_ds
Hi,

Iam Getting an issue with complex flat file,
Job is Aborting,because of SIGBUS Error.How to resolve it.


Error:Operator Terminated Abnormally:received signal SIGBUS.

Thanks,
sirisha.

Posted: Sun Feb 15, 2009 9:10 am
by chulett
That's a bus error and no-one can help without you providing more information. What's your job design? What have you tried to fix it? Also, please post the complete, unedited errors that get logged.

SIGBUS ISSUE

Posted: Tue Sep 29, 2009 12:09 am
by hellboy
i am getting [b]SIGBUS[/b] error in simple insert update jobs, in this jobs i am using a sequential file for capturing the error records a lookup stage to seggreagte the records for update and insert.

Please Provide me the solution .

[quote="chulett"]That's a bus error and no-one can help without you providing more information. What's your job design? What have you tried to fix it? Also, please post the [b]complete, unedited[/b] errors that get lo ...[/quote]

Posted: Tue Sep 29, 2009 12:30 am
by ArndW
Please post the complete error message. Also, try doing a reset of your job and posting the "from previous run" titled log entry, if present.

Posted: Tue Sep 29, 2009 12:45 am
by ray.wurlod
This error can indicate, for example, a faulty memory chip. Or quite a number of things outside your, or DataStage's, control. Learn somewhere about the various signals that the operating system can raise.

Posted: Tue Sep 29, 2009 1:09 am
by hellboy
Hi ,

Please see that i am getting these many error messages in log

node_node1_1: Player 4 terminated unexpectedly.
main_program: Unexpected termination by Unix signal 10(SIGBUS)
main_program: Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
main_program: Step execution finished with status = FAILED.


Please if can clarify why all these things comes in DS run and expected solution to my problem.

Posted: Tue Sep 29, 2009 1:12 am
by ArndW
What stages do you have in your job? Make a copy of the job and replace output stages (one by one) with PEEK stages to see if the error goes away. Try running with just one node in your configuration file and disable operator combination.

Posted: Tue Sep 29, 2009 1:16 am
by hellboy
i am using only one node in my job,
i have used 3 stages only

1_lookup
2_oracle stage
3_seq file stage

not every time i am getting this error, it is coming on different intervals of time.

Posted: Tue Sep 29, 2009 1:46 am
by ArndW
Which stage is output? With a lookup stage, you would need one source stage, one reference stage and an output stage - that makes at least 4 stages for the job - or is it a sequential stage in addition to your CFF stage? No matter, still do the same, replace candidates with peek or dummy copy stages to see if it affects the error. Even sporadic errors need to be checked this way if no other method presents itself. Is the machine heavily loaded (CPU/IO)? Is the database local or remote?

Posted: Tue Sep 29, 2009 1:59 am
by ray.wurlod
hellboy wrote:Hi ,

Please see that i am getting these many error messages in log

node_node1_1: Player 4 terminated unexpectedly.
main_program: Unexpected termination by Unix signal 10(SIGBUS)
main_program: Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
main_program: Step execution finished with status = FAILED.


Please if can clarify why all these things comes in DS run and expected solution to my problem.
Maybe nothing.

As I observed earlier, SIGBUS can be - usually is - a hardware problem.

Posted: Tue Sep 29, 2009 2:19 am
by hellboy
its remote database