DSXchange

hi ds,
Actually, I am trying to run setup_e job which which loads the data into OWS.
This job having an intermediate IPC stage.

This is the error message I am getting in the log.
IPC_in.IDENT2: ORA-24909: call in progress. Current operation cancelled

I ran the same job in different environment, job ran to success.

Could you plz suggest whether this problem is with database or with the job?

This is an Oracle issue, try searching Google or Oracle using "ORA-24909: call in progress" and you will see numerous explanations.

you can check data types of columns in backend side, if any clob data type
is there or not, if clob is there , convert into varchar

based on your terminologies, it seems you are using peoplesoft jobs. Convert the corresponding field data type to longvarchar in the ETL job, as this is the supported datatype for CLOB fields, when using with DRS stage.

Alternatively , you can try DBMS_LOB.SUBSTR and use varchar also.
You can use DBMS_LOB.SUBSTR in DRS column derivation itself.

It's a pretty low-level OCI code error and from googling around there is a bug in the 10.2.0.1 version of the client that causes this. No mention of CLOBs that I saw.