Biztalk Adapter Pack - WCF Custom - OracleDB - UDT Assembly Error


hi there :-)

we have problem biztalk adapter pack 2.0 :

two independent biztalk 2010 applications on same biztalk 2010 server each receives flat file xml input. xml-schema directly send wcf-custom two-way request-response port communicates oracle database data retrieval , data returned request-response port in biztalk.

the response xml_schema send flat file send port in biztalk writes xml-data xml-file on disk.

to decode response oracle database, request-response port use udt assembly generated during development. udt assembly has been placed in c:\program files\biztalk server 2010 server\ folder , named.

the udt assembly has been specified in userassemlyloadpath property on binding specification on oracle send/receive port in biztalk.

userassembliesloadpath="c:\program files\microsoft biztalk server 2010\biztalkfredag_udt.dll"

each of applications works fine, when 1 of applications activated incoming xml-file , data nicely received oracle , written output xml-file.

if other application afterwards gets activated, communication oracle database fails following message:

a message sent adapter "wcf-custom" on send port "sendport_fredag_oracle" uri "oracledb://dck_edu1" suspended.

 error details: system.invalidoperationexception: custom type mapping 'datasource='dck_edu1' schemaname='dck_biztalk' typename='test_skematype'' not specified or invalid.

if biztalk host instance restarted, other application works fine, first application fails same error message.

it seems first activated udt assembly gets stuck inside biztalk or wcf, , other udt assembly fails on activation.

the described scenario can recreated 2 biztalk applications each uses different oracle udt assembly decode oracle response. if 2 biztalk applications make use of same udt assembly works fine.

we have experienced same scenario on 3 different servers, 2 of them running biztalk server 2009, , on running biztalk 2010

software

version

version

windows server

2008

2008

biztalk

2010

2009

oracle client

11.2g

11.1g

biztalk adapter pack

2010

2.0

wcf lob adapter sdk

2010

2.0

oracle server

10.2g

10.2g

we happy hear experience re. specifed problem, or if has any knowledge if known bug in adapter pack or in oracle client software.

thanks in advance.

thomas
copenhagen, denmark

thomas elbek

this odp.net limitation. need have udts in single assembly. if odp.net finds 1 assembly udts, not try further. therefore, udts first assembly alone work.
-- please mark answered if answers question.


BizTalk Server  >  BizTalk Server Adapters and Adapter Pack



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

RFC_ERROR_SYSTEM_FAILURE with SAP ECC 6 Unicode

hi all, i using biztalk 2006 r2, microsoft biztalk adapter v2.0 mysap business suite sp1 & sql server 2005 database server. we have developed orchestrations communicating sap version 4.7.   currently sap has been upgraded in ecc 6(unicode) system. i have configured new send port on dev server. orchestration can communicate sap ecc 6.0 (non- unicode) system while trying connect sap ecc 6.0 (unicode) getting error. a message sent adapter "sap" on send port "ecc 6 sendport" uri "sap://as:***.**.***.***/**/***/" suspended.   error details: rfc_error_system_failure   messageid:   {b7dd677e-0ef3-480b-835a-d389f2e24179} is there can configure setting unicode ?   thanks in advance     ajay dabhade problem solved: standard table data types appear not unicode compatible in sap ecc 6.0. make rfcgetfunctiondesc raise error. solution: used other data types scratch in rfcs in sap   ajay dabhad...
Read more

C# System.Data.Common DbCommand and getting Datasets from Oracle

i found no oracle specific forum area, decided post here. getting dataset oracle c# system.data.common library's dbcommand seems tricky task. i using command object in project along dbproviderfactory , dbdataadapter because meant allow use same library multiple database providers, , don't have clutter data access layer of project separate classes accessing each individual database provider. my problem is, stored procedures fetching data oracle require refcursor object added in parameters. however, dbtype library not contain definition object. using "object"-type not work. i have read many places not have add refcursor parameter, endless failed attempts @ running command without refcursor object has brought me conclusion leaving out refcursor object not option when using system.data.common library. here coded example connectionstring purposefully left out.                 dbconnection.ope...
Read more