BPEL Database Adapter Interaction Spec Problems When Using Microsoft SQL Server Database (Doc ID 1059848.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle(R) BPEL Process Manager - Version 10.1.3.4 and later
Information in this document applies to any platform.

Symptoms

When using a database adapter to insert into a Microsoft SQL Server you get the following error:

file:/some_path/.bpel_Some_BPEL_1.0_50f52f29405f195437874cc2e8336790.tmp/Some_BPEL.wsdl [ InsertDistAddressToPhx_ptt::merge(DisAddressCollection) ] - WSIF JCA Execute of operation 'merge' failed due to: Could not instantiate InteractionSpec oracle.tip.adapter.db.DBWriteInteractionSpec due to: XSD Loading problem.
Unable to load Translation schemas from file:/some_path/.bpel_Some_BPEL_1.0_50f52f29405f195437874cc2e8336790.tmp/Some_BPEL.xsd.__OAUX_GENXSD_.TOP.XSD for http://xmlns.oracle.com/pcbpel/adapter/db/top/InsertDistAddressToPhx due to: Can not build schema 'http://xmlns.oracle.com/pcbpel/adapter/db/top/InsertDistAddressToPhx' located at 'file:/some_path/.bpel_Some_BPEL_1.0_50f52f29405f195437874cc2e8336790.tmp/Some_BPEL.xsd'
Please make sure all used XML schemas are imported/included correctly.

file:/some_path/.bpel_Some_BPEL_1.0_c5520f7223f1fb4a5a2da664ddfc56d6.tmp/Some_BPEL.wsdl [ InsertDistProfileDataToPhx_ptt::merge(DistributorCollection) ] - WSIF JCA Execute of operation 'merge' failed due to: DBWriteInteractionSpec Execute Failed Exception.
merge failed. Descriptor name: [InsertDistProfileDataToPhx.Distributor]. [Caused by: Transaction (Process ID 99) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
; nested exception is:
ORABPEL-11616
DBWriteInteractionSpec Execute Failed Exception.
merge failed. Descriptor name: [InsertDistProfileDataToPhx.Distributor]. [Caused by: Transaction (Process ID 99) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
Caused by Exception [TOPLINK-4002]
...
declare @p1 int
set @p1=NULL
exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 datetime,@P2 nvarchar(4000)',N'UPDATE dbo.Distributor SET Gender = @P0, SyncLastUpdatedOn = @P1 WHERE (HLDisID = @P2) ',N' ','2010-01-13 10:32:18',N'MXSOL0444'
select @p1
SELECT TOP 100 * FROM dbo.Distributor
DECLARE @P2 NVARCHAR(4000), @P3 VARCHAR(30)
SET @P2 = '002327799'
SET @P3 = '002327799'
SELECT * FROM dbo.Distributor WHERE HLDisID = @P2
SELECT * FROM dbo.Distributor WHERE HLDisID = @P3

file:/some_path/.bpel_Some_BPEL_1.0_a0438a71944ff2f7120937088839bb3e.tmp/Some_BPEL.wsdl [ InsertOrderDataToPhx_ptt::merge(ProdOrderCollection) ] - WSIF JCA Execute of operation 'merge' failed due to: Invalid interaction spec - either null or of wrong type.
Invalid interaction spec - either null or of wrong type.
; nested exception is:
ORABPEL-11914
Invalid interaction spec - either null or of wrong type.
Invalid interaction spec - either null or of wrong type.
Please examine the log file to determine the problem.

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