able to view data but job is aborting

kirankota79 · Post by **kirankota79** » Thu May 10, 2007 8:25 am

iam able to view data from oracle stage, but when i run the job, it is getting aborted. I am writing the ouput to a sequential file.

reddy12 · Post by **reddy12** » Thu May 10, 2007 8:33 am

Which error you are getting?

kirankota79 wrote:iam able to view data from oracle stage, but when i run the job, it is getting aborted. I am writing the ouput to a sequential file.

diamondabhi · Post by **diamondabhi** » Thu May 10, 2007 10:12 am

Please post the exact error message one of the things you can check is how are the parameters being passed if any?

DSguru2B · Post by **DSguru2B** » Thu May 10, 2007 10:59 am

Are you using user defined query? Make sure you have no new line after the last line in your sql. Also check there is nothing (not even a space) in the before/after sql tab or OPEN/CLOSE options.

kirankota79 · Post by **kirankota79** » Thu May 10, 2007 11:53 am

i am using auto generated sql. when i validate the job, it is saying OK. but when i run the job it is aborting with segementation fault error

mctny · Post by **mctny** » Thu May 10, 2007 12:00 pm

ok you need to post the error log in order for the people to help you. another thing is just being able to view data and being able to validate the job does not guarantee that the job will not abort.

One last thing, how do we/you know that the error is related with the oracle stage?

kirankota79 · Post by **kirankota79** » Thu May 10, 2007 12:09 pm

when i run the job i get the

An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
segmentation fault.
and failure code 139.

Somebody has already replied to this error, but i couldn't see it since it is only for premium membership. i couldn't figureout what this segmentation falt is.

diamondabhi · Post by **diamondabhi** » Thu May 10, 2007 12:25 pm

You need to set the environment var. NLS_LANG to whatever is in your database.

kirankota79 · Post by **kirankota79** » Thu May 10, 2007 12:37 pm

do we need to set this variable in userdefined environment variables in datastage adminstrator for that project. I have tried it, then iam getting ora-12705 errors. the database to access has US7ASCII character set , but for datastage parallel jobs only one character set is there and it is the default one. it is ISO-8859-1. Can you please tell me where i can set this variable

phanee_k · Post by **phanee_k** » Thu May 10, 2007 12:46 pm

Check if you have any NCHAR / NVARCHAR as datatypes for any of the columns.
The NCHAR and NVARCHAR datatypes expects that the NLS_LANG is installed.

Thanks

kirankota79 · Post by **kirankota79** » Thu May 10, 2007 1:15 pm

i have 8 columns in the table with sqltypes decimal, varchar and double. Does this causes any problem? Do we have other than ISO-8859-1 for parallel jobs. In my server i dont have any other NLS for parallel jobs, but there are many for the server jobs to select from.

kirankota79 · Post by **kirankota79** » Thu May 10, 2007 1:44 pm

when i see on the oracle side, the data type are:

NUMBER,FLOAT,VARCHAR2

ray.wurlod · Post by **ray.wurlod** » Thu May 10, 2007 6:31 pm

DataStage has NLS set, and therefore requires that NLS_LANG be set for Oracle.

DSXchange

able to view data but job is aborting

able to view data but job is aborting

Re: able to view data but job is aborting