My Oracle Support Banner

Error While Inserting Data into Database, BPEL Reading Data From CSV File. (Doc ID 421165.1)

Last updated on APRIL 08, 2019

Applies to:

Oracle(R) BPEL Process Manager 10g - Version 10.1.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2009***
***Checked for relevance on 25-May-2011***


Symptoms

Using BPEL, reading a CSV file and inserting the data read from CSV file into any database and you notice errors such as below: 

Caused by: org.collaxa.thirdparty.apache.wsif.WSIFException:
file:/F:/product/10.1.3.1/OracleAS/bpel/domains/default/tmp/.bpel_XXXXXXX_1.2_.tmp/InsertData_To_FXXLEGAL.wsdl
[InsertData-To-F58LEGAL_ptt::insert(F58legalCollection) ] - WSIF JCA Execute of operation 'insert'
failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertDataToFXXLEGAL.F58legal]. [Caused by: [SQL7008] FXXLEGAL in
TNPIDTA not valid for operation.]
; nested exception is:
ORABPEL-11616
DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertDataToFXXLEGAL.FXXlegal]. [Caused by: [SQL7008] FXXLEGAL in
TNPIDTA not valid for operation.]
Caused by Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.1.0) (Build 061004)):
oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: [SQL7008] FXXLEGAL in TNPIDTA not valid for
operation.Error Code: -7008.

at
oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.j
ava:623)
at
oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeInputOnlyOperation(WSIFOperation_JCA.java:72
6)
at com.collaxa.cube.ws.WSIFInvocationHandler.invoke(WSIFInvocationHandler.java:425)

 

-- Steps to confirm that you have the same issue on hand: 

1. Write a simple SQL statement such as:

insert into emp (empno, empname) values(123,'XXXX,YYY')

and try executing the statement with BPEL SQL worksheet.

This should work fine with out any problem provided you have the table setup correctly. At the same time follow the rest of the steps and if you happen to get the error ORABPEL-11616 as stated above then you are reading the right note.

2. Create a simple BPEL process with a receive, invoke, database adapter and reply nodes.

3. In the database adapter wizard choose simple SQL statement as your option and use the above SQL statement.

4. Click OK in the database adapter wizard, compile, deploy and initiate the process.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.