ORA-24909: call in progress. Current operation cancelled

tirumal_nit · Post by **tirumal_nit** » Mon May 26, 2008 1:52 am

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?

ArndW · Post by **ArndW** » Mon May 26, 2008 2:05 am

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

vijay.barani · Post by **vijay.barani** » Mon Mar 02, 2009 2:31 am

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

DS_SUPPORT · Post by **DS_SUPPORT** » Mon Mar 02, 2009 2:48 am

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.

chulett · Post by **chulett** » Mon Mar 02, 2009 7:59 am

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.