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

job syspolicy_purge_history job fail in sqlserver 2008

Image
hello guys, when installed sqlserver,it automatically created 1 job name job syspolicy_purge_history. but failed @ step 1. the reason is: date                11/6/2010 2:00:00 am log                job history (syspolicy_purge_history) step id                1 server                mxosv-otsdb01 job name                syspolicy_purge_history step name                verify automation enabled. duration                00:00:00 sql severity                16 sql message id                34022 operator emailed                operator net sent                operator paged                retries attempted                0 message executed user: nt authority\system. policy automation turned off. [sqlstate 42000] (error 34022).  the step failed. have run statement: select msdb.dbo.fn_syspolicy_is_automation_enabled the returned valus 0. what can resolve it? or can delete job manually.   thanks in advance. if haven't things want,be
Read more

Trying to register with public marketplace error with 'Get-AzureStackStampInformation'

when trying register against public azure adfs azure stack error below. logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  and  \\azs-ercs01\c$\maslogs error occurred checking stamp information: system.management.automation.remoteexception: term 'get-azurestackstampinformation' not recognized name of cmdlet, function, script file, or operable program. check spelling of name, or if path included, verify path correct , try again. @ c:\azurestack-tools-master\registration\registerwithazure.psm1:1106 char:5 +     throw "logs can found at: $global:azureregistrationlog  and  \ ... +     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : operationstopped: (logs can fou... , try again.:string) [], runtimeexception     + fullyqualifiederrorid : logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  a    nd  \\azs-ercs01\c$\maslogs error occurred chec
Read more