Error while inserting data into SQL server 2014 table through BPEL service using DB adapter.
(Doc ID 2304435.1)
Last updated on NOVEMBER 15, 2023
Applies to:
Oracle SOA Suite - Version 12.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.1.0.0 version, Technology Adapters
Error while inserting data in SOA, while inserting data into SQL server 2014 table through BPEL service using DB adapter you are receiving the mentioned error.
ERROR
-----------------------
Exception occurred when binding was invoked.
Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertInvoiceRecordsDBService.Stage].
Caused by java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'STAGE'..
Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-208" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.
Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertInvoiceRecordsDBService.Stage].
Caused by java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'STAGE'..
Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-208" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Test the SOA composite with DB Adapter used for connecting to 2014 SQL Server DB
2. Find the mentioned error in the logs
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 |