Complex Flat File Issue

snt_ds · Post by **snt_ds** » Sun Feb 15, 2009 1:53 am

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.

chulett · Post by **chulett** » Sun Feb 15, 2009 9:10 am

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.

hellboy · Post by **hellboy** » Tue Sep 29, 2009 12:09 am

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]

ArndW · Post by **ArndW** » Tue Sep 29, 2009 12:30 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 29, 2009 12:45 am

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.

hellboy · Post by **hellboy** » Tue Sep 29, 2009 1:09 am

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.

ArndW · Post by **ArndW** » Tue Sep 29, 2009 1:12 am

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.

hellboy · Post by **hellboy** » Tue Sep 29, 2009 1:16 am

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.

ArndW · Post by **ArndW** » Tue Sep 29, 2009 1:46 am

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?

ray.wurlod · Post by **ray.wurlod** » Tue Sep 29, 2009 1:59 am

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.

hellboy · Post by **hellboy** » Tue Sep 29, 2009 2:19 am

its remote database

DSXchange

Complex Flat File Issue

Complex Flat File Issue

SIGBUS ISSUE