DSXchange

are you using any function inside the routine?and whether are you passing null values without nullhandling options to that routine?
this type of error i got for the above reason...

if the file is ordinaty txt file, data format should be Text.
Byte order set it as native-endian...
character set is also EBCDIC if data is in mainframe format..
please correct if m wrong...

BAPI is nothing, but type of stored procedure.. it is called as function in SAP...in that procedure there might be any constraints...so have check in the BAPI

sure... i will correct myself

in Oracle stage i cant find the options?

Friends,
i m loading records into oracle through oci stage..
few records got rejected due to some constraints..
whether there is any way to collect the reject in a file?
transformer is the stage, before oci stage...
thanks

are you using the userdefined query or using inbuilt procedures.?

can u able to excute the same query through SQL plus?

i m using the same function in my jobs it is running fine...

once i got the same problem ...but issue is, target field is not nullable..

u dont have not found option in PX so u have to use lookup+transformer stage. in lookup stage have lookup failure constrints in properties tab to continue .. take the both key column of primary and reference link to output.. And in the transformer have two o/p link applying constrints isnotnull (ref...

please can u explain ur job clearly?

how many lookup file are you using?

do you have the options set inthe ODBC stage like fetch array size =1?

what is query you are using to fetch the data?

problem resolved..
we increased the max processes per user_id and it got resolved now.
thanks :D