Error : Illegal instruction

ThilSe · Post by **ThilSe** » Mon Mar 27, 2006 9:34 am

Hi,

I have a job that reads data from a table and updates one table, dataset.

I get the folowing error on Validating it

Contents of phantom output file =>
RT_SC367/OshExecuter.sh[20]: 3874844 Illegal instruction
Parallel job reports failure (code 132)

Do any one have ideas on this?

Thanks/Regards
Senthil

ray.wurlod · Post by **ray.wurlod** » Mon Mar 27, 2006 2:34 pm

You can take a look at the RT_SC367/OshExecuter.sh script and see what is happening that might raise a SIGILL signal. Otherwise report it to your support provider. Let us know the outcome.

ThilSe · Post by **ThilSe** » Mon Mar 27, 2006 8:57 pm

ray.wurlod wrote:You can take a look at the RT_SC367/OshExecuter.sh script

Ray,

I don't know where to know look for that script.
Can you pls guid me ?

Thanks
Senthil

rasi · Post by **rasi** » Mon Mar 27, 2006 9:55 pm

Senthil

These files are created under Datastage Project folder in your OS.
(ie ..//Ascential/DataStage/Projects/ProjectName/RT_SC367/OshExecuter.sh )

Thanks

ThilSe · Post by **ThilSe** » Mon Mar 27, 2006 10:29 pm

Rasi,

I could see the file there. Thanks

But the error was diffferent. I was using a filter stage to seperate the records to output a db2 and dataset. there was using "col1>col2-1". So got this error.

Thanks
Senthil

rasi · Post by **rasi** » Mon Mar 27, 2006 11:13 pm

Senthil

using "col1>col2-1".

What is your where clause in filter stage. What is the datatype for Col1 and Col2?

ThilSe · Post by **ThilSe** » Tue Mar 28, 2006 12:13 am

rasi wrote:Senthil

using "col1>col2-1".
What is your where clause in filter stage. What is the datatype for Col1 and Col2?

The previous where clause was "CUR_DLVR_CT > MAX_DLVR_CT-1"
Where CUR_DLVR_CT, MAX_DLVR_CT are small integers.

Now i get MAX_DLVR_CT-1 from the database and use "CUR_DLVR_CT > MAX_DLVR_CT_NEW" in where clause

It seems we cannot give arithmetic expressions in where clause.

Thanks
Senthil

rasi · Post by **rasi** » Tue Mar 28, 2006 12:21 am

Senthil

In developer guide it says

"The Where property supports standard SQL expressions, except when comparing strings."

There should be something else which makes it not to work....

ThilSe · Post by **ThilSe** » Tue Mar 28, 2006 12:30 am

The expression i gave initially is CUR_DLVR_CT > MAX_DLVR_CT-1

So datastage might first calculate "CUR_DLVR_CT > MAX_DLVR_CT" which evaluates to false and then try to subtract 1 from false. This might be a reason for error.

I got parsing error when i enclosed the contraints within brackets like "CUR_DLVR_CT > (MAX_DLVR_CT-1)".

Thanks
Senthil