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

Last updated on MAY 25, 2011

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.3.1 and later   [Release: AS10gR3 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_LegalBInbound_1.2_a9794a68a9df7003
9198a32c72b8581c.tmp/InsertData_To_F58LEGAL.wsdl
[InsertData-To-F58LEGAL_ptt::insert(F58legalCollection) ] - WSIF JCA Execute of operation 'insert'
failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertDataToF58LEGAL.F58legal]. [Caused by: [SQL7008] F58LEGAL in
TNPIDTA not valid for operation.]
; nested exception is:
ORABPEL-11616
DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertDataToF58LEGAL.F58legal]. [Caused by: [SQL7008] F58LEGAL 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] F58LEGAL 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,'arun,kum')

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms