My Oracle Support Banner

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

Last updated on SEPTEMBER 27, 2019

Applies to:

Oracle(R) BPEL Process Manager 10g - 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.

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


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