DSXchange

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.

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.

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

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.

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

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?

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.

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

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

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

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.

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

NUMBER,FLOAT,VARCHAR2

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