BizTalk Server Adapters and Adapter Pack Forum

BizTalk WCF issue

Tue, 01 Dec 2009 22:54:52 Z

I have a request and response WCF Service and associated request-response receive port created from BizTalk 2006 R2 Orchestration. This port will receive a request message and send it to Orchestration. Orchestration inserts in SQL Table, and simply returns same message to request-response receive port. Everything works fine, but I see WCF service returns null when I access it and send message from a windows application. I see that BizTalk successfully receives, process and sends this message to request-response receive port in HAT. BizTalk side, it is 100% working. But WCF Service returns null to the client. Any idea, what could be the issue? Any configuration changes?

This WCF service hosted in IIS and Windows client, WCF Service and BizTalk all running local.

gopal

Issue with WCF adapter when calling WCF service

Tue, 01 Dec 2009 21:47:45 Z

I am seeing following error in eventlog when calling WCF service thru WCF WSHTTP adapter. I created two way send port and i am calling WCF service thru WCF adapter. I am calling WCF service with out orchestration
Everything works fine but i am seeing the following error in eventlog. How can i get rid of this error? Did i miss any settings?

The transport proxy method MoveTo NextTransport() failed for adapter WCF-Custom: Reason: "Messaging engine has no record of delivering the message to the adapter. This could happen if MoveToNextTransport() is called multiple times for the same message by the adapter or if it is called for a message which was never delivered to the adapter by the messaging engine". Contact the adapter vendor.

SQL request

Sun, 29 Nov 2009 22:04:24 Z

Hello.
I have a question about biztalk and sql.
I have a xml message i send to my sql. In this sql server i have a database called projekt. In this database i have a tabel called order.
In this tabel a have Column named "Ordernumber" an this is a primarykey.

My question is: In my xml message i have a field called "Ordernumber", i want to check the tabel in the sql tabel for this number.
If the number is not in the tabel, i want to read this message into this tabel. But if the number is in the tabel, i want to read this message into another tabel.

Is this possible?

Regards Nitro

Biztalk Adapter and Windows identity Foundation integration

Tue, 01 Dec 2009 10:45:07 Z

Hello,

Are there plans to integrate the Windows Identity Foundation into the WCF adapters for biztalk 2009?

More specifically, to allow the use of an STS as SSO.

Kind regards,
Sven

Context property for my custom adapter

Tue, 01 Dec 2009 14:25:38 Z

I'm building a custom adapter based on the LOB adapter SDK.

My adapter requires the use of one or more context properties to control per-message behaviour

In my output handler I can use message.properties to access these, so that aspect is ok.

For BizTalk I assume I have to deploy the relevant property schema as part of my adapter deployment.

Is there any way to add this property to the metadata so that it's easier for .net consumers to provide it?

Yossi Dahan http://www.sabratech.co.uk/blogs/yossidahan [To help others please mark replies as answers if you found them helpful]

Connecting to VSAM/CICS on VSE

Mon, 30 Nov 2009 19:57:19 Z

We have Biztalk 2009 but are having difficulty configuring our mainframe to connect to Host Integration Server. The original intent was to access vsam directly but because we are running VSE we need to use CICS. No problem. However, we cannot find the documentation to do so.

Is it via TCP/IP or SNA? Anyone do this already and have advice?

Thanks!

David

Biz Talk nsoftware SAP Adapter problem!!!

Wed, 25 Nov 2009 10:34:54 Z

Hi,

I am getting an error while sending file to FTP location.But the same is working fine on another machine.I have check the configuration and cetificates and pwds also.But still unable to figure out the problem.Help needed.
Please check the below error

Adapter: "nsoftware FTP Send Adapter" (FTP:2.4.3331.0)

URI: "FTP://Dummy/%SourceFileName%"

Trace Mode: ERROR

Current thread: 36

System.Exception: Transmission failed for message "3540c270-5d64-4447-a7e2-980681311751". ---> nsoftware.core.ipb24ca: Timeout. ---> nsoftware.core.ipb24ca: Timeout.

at nsoftware.core.ipb24dl.v(Int32 A_0)

at nsoftware.core.ipb24bc.d(Int32 A_0)

at nsoftware.core.ipb24aa.d(Int32 A_0)

at nsoftware.core.ipb24dl.cm()

at nsoftware.core.ipb24ac.au()

at nsoftware.core.ipb24aa.a(Boolean A_0)

at nsoftware.core.ipb24aa.a(String A_0, String A_1, Boolean A_2, Boolean A_3)

at nsoftware.core.ipb24aa.h(Int32 A_0)

--- End of inner exception stack trace ---

at nsoftware.core.ipb24df.c2()

at nsoftware.core.ipb24aa.h(Int32 A_0)

at nsoftware.BizTalk.FTP.FTPMessageTransmitter.Transmit(Stream s, BaseProperties config, IBaseMessage msg)

at nsoftware.BizTalk.Adapters.BaseAdapter.MessageTransmitter.TransmitMessage(Stream s, BaseProperties config, IBaseMessage msg)

at nsoftware.BizTalk.Adapters.BaseAdapter.BaseAsyncTransmitterBatch.ProcessWorkItem()

--- End of inner exception stack trace ---

Regards,
Zizy

Problem with BizTalk and DynamicsAX adapter

Thu, 26 Nov 2009 10:03:18 Z

Dear collegs ,

I have one question and hope that you maybe can help me.

Namely, I have installed Axapta and BizTalk at the same thest machine and everything worked good some time, than I need to reinstall my BizTalk and than my problems started.

After that installation I always get this error message (in Event Viewer) :

Source : BizTalk Server 2006

Category : BizTalk Server 2006

Event ID : 5740

Description :

The adapter "Microsoft Dynamics AX 2009" raised an error message. Details "Logon failure: unknown user name or bad password".

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Can somebody help me to find solution for this problem.

Thanks in advance.

Establish connection for IDOC Destribution

Mon, 30 Nov 2009 15:14:51 Z

Hi BizTalker!

I'm new in the topic to handle the BizTalk Server 2009 with SAP ECC 6.0 and I can not activate any connection through these two systems.
I tried to follow all relevant steps in transaction: SALE like "Define Logical System" and create a RFC-Destination... But unfortunately I failed all the time.

Have you a good step-by-step walkthrough to establish a SAP to BizTalk connection, which I can use???

Thanks for your reply!

With kind regards,
Thomas

CRM schema issue

Tue, 13 Oct 2009 12:07:04 Z

I'm having below issue when i try to generate CRM schema from BizTalk 2006 R2.
The list of actions and entities cannot be loaded. Server was unable to process request.

Thanks, Raja

Biztalk 2009 Oracle Adapter two Package Procedures with same schema/package name/function name in two different databases

Fri, 27 Nov 2009 21:03:33 Z

(This question was first post under General Biztalk Discussion)
thread: http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/9391eff2-e1c7-4a07-95d8-93372debda70/

------

Hi,

I have the same Schema.Package.Procedure on two different Oracle Database PDO.PO_CE_WS.PROCCESS_MESSAGE

Let's say one is Spain database and other Italy one.

When I generate an assembly for Italy and deploy everything goes well, when I deploy spain that uses the same procedure (but in his own database), even if they are in separate applications, as schema should be unique on Management Database I run into a problem that both schema namespace+rootnode generated from Oracle Adapter has the same matching type, so Italy assembly is load.

I tried to use Prefix and Generate Unique Schema names options on Oracle WCF Adapter generator with no luck....

Is there a configuration option or workaround I can apply to solve this, (final scenario handles up to six database with same use case)

Thank you so much

Biztalk 2009 Oracle Adapter two Package Procedures with same schema/package name/function name in two different databases

Thu, 26 Nov 2009 14:42:16 Z

Hi,

I have the same Schema.Package.Procedure on two different Oracle Database PDO.PO_CE_WS.PROCCESS_MESSAGE

Let's say one is Spain database and other Italy one.

When I generate an assembly for Italy and deploy everything goes well, when I deploy spain that uses the same procedure (but in his own database), even if they are in separate applications, as schema should be unique on Management Database I run into a problem that both schema namespace+rootnode generated from Oracle Adapter has the same matching type, so Italy assembly is load.

I tried to use Prefix and Generate Unique Schema names options on Oracle WCF Adapter generator with no luck....

Is there a configuration option or workaround I can apply to solve this, (final scenario handles up to six database with same use case)

Thank you so much

Adapter Registration Failing

Mon, 30 Nov 2009 19:59:21 Z

I have created a simple Biztalk Send Adapter, works super on my local dev m/c Win2003R2. If I try registering on an AMD x64 Server its throwing exception. I tried launching the Adapater Reg Wizard on the AMD Server and if I point to the path to the .Net assembly for adapater implementation
"Could not load assembly myAdapater.dll or of its dependecies. An attempt was made to load a program with an incorrect format".
I have ensured all the dependency DLL are in the folder still no luck.
I have also created an x86 build of the adapter especially for the AMD Servers, still no luck

Whats missing?

TIA

BizTalk vNext and ODBC

Tue, 24 Nov 2009 08:37:20 Z

Is there anybody out there who knows when and if MS is going to build a good ODBC adapter ?

I think for a product like BizTalk you should have at least a nice ODBC so you can connect to every system that supports ODBC.

Well0549

SMTP send problem

Fri, 13 Nov 2009 08:06:10 Z

Hi,

I'm having a SMTP send problem ocassionally in Biztalk 2006. The issue is with the SMTP adapter connecting to the server: "The transport failed to connect to the server".
Each time when this error occurs, I tested the connectivity to the SMTP server with telnet and the connection between Biztalk and the server is fine. However, the SMTP adapter doesn't seem to respond even when I changed to other SMTP server or restarted the host instance. And it's strange that approximately after few hours, resuming the suspended instance the SMTP send port is working again. I really don't know what is causing this.

Biztalk wse adapter

Wed, 25 Nov 2009 14:43:12 Z

Hi,

I have created a webservice and enabled the WSE settings.Now in my biztalk application I have created a send port and tried to configure the send port with the WSE adapter.When I tried this I have option only to mention the webservice URI to which I am sending the xmldocument.I am not able to determine which method has to be called like in "SOAP adapter".This always results in a "Method Name null exception" inmy event viewer.Please let me know what I have to do. Thanks in advance

wcf adapters. operation contract attributes

Tue, 24 Nov 2009 21:27:35 Z

Hi. I want to expose wcf service via biztalk. And I need to provide some attributes like

[

OperationContract, WebGet(UriTemplate="GetPrediction/{stationCode}",ResponseFormat=WebMessageFormat.Json)]

for operation contract. Is there any way to do this? As I understand, it's not possible since all operation contracts are predefined by biztalk, but may be...
If not, is it possible to create own adapter?
If possible, is there any SDK or toolkit which can be useful for creating new wcf adapter?

Thanks.

BizTalk Adapter Pack 2.0 / SAP - always get empty results from SAP

Wed, 20 May 2009 15:39:48 Z

Hello,

I've been trying out the 2.0 adapter pack to access a SAP installation, namely to call a BAPI. I'm using BizTalk 2006 R2 to do it. I did a simple request-response scenario:

File based Rec Loc reads XML file
Solicit Response WCF Send Port calls SAP
File send port drops the result

I've tried this with 2 BAPI's already: BAPI_PERSDATA_GETDETAILEDLIST and BAPI_DATESPECS_GETDETAILEDLIST. In both cases (and passing parameters for which I know there is data in SAP), I get a structure with a result indicating 0 (ie: no error), but I don't get the BAPI's result. Example:

<?xml version="1.0" encoding="utf-8"?>
<BAPI_PERSDATA_GETDETAILEDLISTResponse xmlns="http://Microsoft.LobServices.Sap/2007/03/Rfc/">
<RETURN>
<TYPE xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></TYPE>
<ID xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></ID>
<NUMBER xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">0</NUMBER>
<MESSAGE xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></MESSAGE>
<LOG_NO xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></LOG_NO>
<LOG_MSG_NO xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/">0</LOG_MSG_NO>
<MESSAGE_V1 xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></MESSAGE_V1>
<MESSAGE_V2 xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></MESSAGE_V2>
<MESSAGE_V3 xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></MESSAGE_V3>
<MESSAGE_V4 xmlns="http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/"></MESSAGE_V4>
</RETURN>
</BAPI_PERSDATA_GETDETAILEDLISTResponse>

There should be a PERSONALDATA structure after the </RETURN>, in this case.

Any ideas?

Thanks in advance.

Biz Talk 2006 R2 HL7 Accelarator

Thu, 01 Oct 2009 09:48:10 Z

I tried a sample application at Biz talk 2006 R2 to consume ADT message and send acknowledgement. I followed steps specifed at MSDN HL7 Developer Guide document. I could not find out the HL7 receive pipe line at Biz talk server administration console (receive location). I added receive pipeline with HL7 receive pipeline in my project and deploy. Now I configure that port using that pipe line as specified in doucment. (Transport type as FILE). My application do not accept the ADT sample message given by MSDN. I tried it for version 2.3.1 and 2.4 message. The message are suspended.

Can any help me ?

My question is :

1. HL7 receive and send pipeline are available at Biz talk server receive location after installed HL7 accelarator?
2. OR Should we need to add this pipeline in our project?
3. Is here any installation problem?

Sample project given by MSDN also do not contain

Error Message 1:

Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'BZ_HL7.BZ_Orchestration(eedd17b1-1a49-f570-9543-b2cfccba7bae)'.

The service instance will remain suspended until administratively resumed or terminated.

If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.

InstanceId: 7ce28ea2-2ba7-4c11-87e0-67447d9b2334

Shape name: Receive_1

ShapeId: d2463cbe-2d97-465c-ad3e-0d8d9ea28259

Exception thrown from: segment 1, progress 3

Inner exception: Multi-part message 'Message_1' has body part 'BodySegments', expected body part 'MSHSegment'.

Exception type: WrongBodyPartException

Source: Microsoft.XLANGs.BizTalk.Engine

Target Site: Void ReadMessageState(Microsoft.XLANGs.Core.Envelope, Microsoft.XLANGs.BaseTypes.XLANGMessage)

The following is a stack trace that identifies the location where the exception occured

at Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.ReadMessageState(Envelope env, XLANG

Error Message 2:

The Messaging Engine failed while executing the inbound map for the message coming from source URL:"C:\BiztalkDemo\HL7-09292009\Messages\In\*.hl7" with the Message Type "http://microsoft.com/HealthCare/HL7/2X#ADT_A03_231_GLO_DEF". Details:"Data at the root level is invalid. Line 1, position 1."

Developer

What happened in SDK 2009 to the classes from SDK Adapter 2004?

Fri, 27 Nov 2009 08:27:05 Z

I have been assigned the task to debugg a Biztalk 2009 project. This solution is using code callling objects and methods from the adapters 2004 SDK. My problem is that we want to remove the 2004 SDK and use only the 2009 SDK adapters.
Some classes are now longer available in the 2009 version of the SDK, for exemple:
standardReceiveBatchHandler, Task scheduler, IManageEndPoints,TransmitterMessage or Batch.
Have those classes been replaced? Is there a relatively easy way to make old code work with new code?

Biztalk Adapter for Host system on multiple server - BizTalk Server 2006 R2

Sat, 21 Nov 2009 03:35:27 Z

We have a BizTalk group with 2 Biztalk(2006 R2) server nodes . We are in the process of installing the Biztalk adapters for Host systems for integration with AS/400 systems
We want to use both Biztalk nodes ..
I know we need to install the Biztalk adapters for Host systems on both the server nodes

1 . After installing we configured the Biztalk adapters for Host systems on Node A . We installed the Biztalk adapters for Host systems on node B also but do we need to configure it also on node B ?
2 . If so how do we set the Primary server , Sub Domain etc in the NetWork Integration tab of the config tool ?

3. Our's is 64 Bit BizTalk running under Windows 64 bit windows server ? Does Biztalk adapters for Host systems support 64 bit ?

HL7 2.x multipart schema for BTAHL72X Send Pipeline without orchestration

Wed, 11 Nov 2009 14:18:02 Z

Hi,

In our current biztalk2006 R2 application we are sending HL7 2.1 message to a third party. We are using an orchestration to construct HL7 message which is a multipart type message, having MSHSegment, ORM schema and ZSegment as message parts.

In new application we want to elemenate all orchestrations. So my question is how to achieve the same HL7 with three message parts without an orchestration. I created a schema which imports the required HL7 segments(MSH etc), but the BTAHL72X Send Pipeline throughs following error :
There was a failure executing the send pipeline: "BTAHL72XPipelines.BTAHL72XSendPipeline, BTAHL72XPipelines, Version=1.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "BTAHL7 2.X Assembler" Send Port: "Send.ToTransmittedHL7.FILE" URI: "C:\Out\%MessageID%.xml" Reason: Message does not contain a part with name MSHSegment

Configure URI for SAP Adapter from BizTalk Adapter Pack 2.0 in ReceiveLocation or SendPort does not work with sap router string

Thu, 15 Oct 2009 12:04:17 Z

When using the WCF-SAP Adapter of the BizTalk Adapter Pack V.2.0 we can not use the “Configure…” button in the ReceiveLocation or SendPort of “BizTalk Server Administration Console” for configuring the SAP connection parameters when we use a SapRouterString for Connection to SAP, because it generates a wrong URI.
It generates e.g.
sap://CLIENT=800;LANG=DE;@A//H/saprouter/H/sapserver/00?RfcSdkTrace=False&AbapDebug=False
but it should generate:
sap://CLIENT=800;LANG=DE;@A/%2FH%2Fsaprouter%2FH%2Fsapverver/00?RfcSdkTrace=False&AbapDebug=False
Reason: Slashes / are reserved characters and should be replaces by %2F when used in a connection property.

A similar dialog works correct, when creating schemas for SAP in Visual Studio 2005 with this adapter. On a BizTalk Project you can “Add Generated Items…” then choose “Consume Adapter Service” and select the “sapBinding” afterwards. The “configure…” button in this dialog generates a valid URI.

Is there a workaround and when will this be fixed?

WSS 64-bit + Oracle 32-bit on the same machine

Wed, 18 Nov 2009 23:55:42 Z

Hi guys,

I have a 64-bit Win2008 server box, with WSS 64-bit adapter. Later I installed 32-bit Oracle, which broke WSS.
The issue is that Oracle adds a bunch of providers to both 64-bit and 32-bit machine config:
For example this one:

 <healthMonitoring>
      <providers>
        <add name="OracleWebEventProvider" type="Oracle.Web.Management.OracleWebEventProvider, Oracle.Web, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" buffer="true" bufferMode="OracleNotification" />
      </providers>
    </healthMonitoring>

When I try to run WSS web service, it complains that it can't load Oracle.Web assembly, that is obviouse why - it tries to load 64-bit version which simply doesn't exist at all, since Oracle is 32-bit.

My question is:
Why 32-bit Oracle upon installation modified both 32-bit and 64-bit machine config? - that's the biggest question. Is it safe to dump all Oracle stuff from 64-bit machine.config file?

Is there any workaround for this ?

Thanks a lot,
Sergei

Checking Performance using Perfmon for adapters that are part of BAHS

Thu, 19 Nov 2009 04:47:29 Z

Hi guys

We installed BAHS 2.0 and BizTalk Server 2006 R2 and could not see any Performance objects/counters in Perfmon.exe... Is there some special setting to be done so that the counters get enabled?

Thanks in advance,
Sulochana

WCF -Oracle Adaptor

Sat, 25 Jul 2009 19:55:13 Z

Hi All,

I have WCF-LOB Oracle adapter installed E:
I have Oracle 11. Installed on E:

I can generate schemas but when deploy started to Test it says

"TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters."

I did the following checks:

1. Checked the Sqlnet.ora filen TnsNames.ora files both exist under E:\Oracle\Product\11.1.0\Client_1\network\admin
2. Sqlnet.Ora --->SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

3.TNSNAMES.ora
ABCDE1 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ABC11111)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SID = ABCDE1)
    )
)
4. From Command Promt(C:\)I checked using SQLPLUS xyz/abc@ABCDE1 (gave dummy userid)
   It gives me ERROR: ORA-01017 invalid username/password; login denied.
5. Checked with right Credentials :
   It gives me ERROR : ORA-12560: TNS: Protocol Adapter error.

6. From Start--All Programs-Oracle Client 11-Application Development --SQLPLUS
    Cheked with both bad and good credentials
    This it gave me ORA-12560- TNS:Protocol Adapter Error both times.
7. I Tried to chek with System DSN in the TNS drodownlist i dont see ABCDE1.
8. The Schema generation form WCF Consume adaptor works when I keep URIProperties: ServiceType : DEDICATED
8. If i change Service Type : Shared it gives me ORA-12520 : TNS:listener could not find available handler for requested type of server.

Can you please guide me What I am missing. What Additional things do i consider to make it to work.
I am my delivery dates .

Thanks,

Project renaming

Thu, 12 Nov 2009 15:07:16 Z

Has anyone else seen the WCF LOB Adapters renaming their BizTalk 2009 projects in Visual Studio 2008? If I have a project named "MyProject", after consuming the SAP or SQL adapters the project has been renamed to "MyProject.btproj" and the project file name has been renamed to "MyProject.btproj.csproj".

BizTalk Accelerator for RosettaNet 3.5 scheme error-'http://www.w3.org/XML/1998/namespace:lang' attribute is not declared

Fri, 20 Nov 2009 14:46:25 Z

I have added the scheme files that came with Microsoft BizTalk Accelerator for RosettaNet 3.5 to visual studio 2006 (C:\Program Files\Microsoft BizTalk Accelerator for RosettaNet 3.5\SDK\Schemas)

I get the following error; can somebody explain how I can resolve this error?

The 'http://www.w3.org/XML/1998/namespace:lang' attribute is not declared.

The Files

0A1_MS_V02_00_FailureNotification.xsd

3A4_MS_V02_02_PurchaseOrderConfirmation.xsd

3A4_MS_V02_02_PurchaseOrderRequest.xsd

When I load my own xsd schema I get the following error.

Failed to load schema.

Reason :

The root element of a W3C XML Schema should be <schema> and its namespace should be 'http://www.w3.org/2001/XMLSchema'.

Can someone, also please help me resolve this error.

Thank you,

Dave

FTP -- > MAINFRAME

Thu, 19 Nov 2009 19:15:50 Z

Hi ,

Can any one walk me through FTPing the .txt file to MIANFRAME

What command do i need to set up bor BeforePut.
I was reading in few articles about this but was little confusing for me.

Few thing can some one help

AFterput: what should be given any sample
Allocated storage :
BeforePut: what should given
Log : is this file log file path on main frame or Biztalk client machine
Representation : ASCII
TargetFileName : what would be the file if for example they give xxx.yy.zz as dataset do we need to include (1)
TempFolder : do i need to include any temp folder

Thanks in advance..

Availability of the adapter pack for download

Wed, 18 Nov 2009 12:08:23 Z

The adapter pack isn't included in the MSDN welcome pack (Part No. X15-80852) and isn't available for download with the professional subscription. I understood this product to be covered by the license for BizTalk Server. Can you please let me know where I can download the full release of the adapter pack or whether it's Ok to use the evaluation version for development purposes indefinitely? We intend to purchase enterprise licences for BizTalk once we've finished development work.

Regards Mike

BizTalk 2009 - Not recovering from SAP Backup

Mon, 16 Nov 2009 18:26:18 Z

Environment: Multi-node BizTalk 2009 group, Windows Server 2008 64 Bit, Microsoft BizTalk Adapter v2.0 for mySAP Business Suite (NOT BizTalk Adapter Pack adapter)

Every Saturday night at 9pm, SAP goes down for a backup. All interfaces, users are locked out of the system. This backup takes around 30 minutes to complete. Our on call person received a call aroun 11pm indicating that SAP IDOCs were not being sent to BizTalk. He logged onto the BizTalk Servers, verified that all applications(and receive locations) were online/enabled. He was also able to validate that BizTalk was sending IDOCs( from within this same application/host instance) to SAP without any issues.

Upon restarting the Host Instances responsible for receiving SAP IDocs, the messages flowed through without issue.

What is interesting is that we have been running Biztalk 2006 R1 for several years with this version of the SAP Adapter and have never had issues with recovering from SAP backups.

We could schedule a restart of these host instances for every Saturday night after the backup but that is not an ideal situation.

In the event viewer, we did notice a few of these errors. But, like I said, there were no receive locations offline when our on-call guy logged onto the servers. He did not enable or start any applications - only restarted host instances.

Event Type:        Error
Event Source:    BizTalk Server 2009
Event Category:                (1)
Event ID:              5741
Date:                     11/14/2009
Time:                     9:02:30 PM
User:                     N/A
Computer:          *BizTalkServer*
Description:
The receive location "SAP://*BizTalkServer*:*SAPServer*/*ParterProfile*/*SAPGateway*/" is shutting down. The adapter did not provide any error description.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

On the SAP side, in transaction SM58, we received some errors indicating "Target system/gateway not active" Message no. SY358

So it is almost as if BizTalk could not re-connect to SAP or was trying to use the old connection that it had established before the outage.

Has anyone experienced any similar behaviour?

Thanks,

Kent

http://kentweare.blogspot.com

MQ Adapter for BizTalk Server 2009 - odd problem

Mon, 09 Nov 2009 20:49:09 Z

I am running 32bit Windows Server Enterprise 2008 with BizTalk Server 2009 and IBM MQSeries 7.0.1.

I have BizTalk set to talk to MQSeries via the non-client adapter - so it uses MSDTC.
Single server self-contained environment.

Everything works for a while, but then BizTalk slows to a crawl, only outputting messages occasionally.
The symptoms are similar to what is noted in this hotfix from BizTalk 2006.
http://support.microsoft.com/kb/941494

Is there a possibility that this problem still exists in BizTalk 2009 -- and will this hotfix help?

Adapters of BizTalk Server

Wed, 18 Nov 2009 04:44:35 Z

Hi All,

I have a general question what is Adapters ,and on which tecnology it is binded with BizTalk Server. Is it using WSDl and WebServices.

Pls Advise

Sandeep

WCF to HIS 2009 Transaction Integrator - Receiving error -_(1508) The input buffer has been exhausted while attempting to convert ...

Fri, 06 Nov 2009 19:38:17 Z

We have an application that is working correctly with HIS 2000 using COM+ with a security callback. I'm trying to convert to HIS 2009 and call using WCF. I use the same import, converting the recordsets to structs, and/or an array of structs. I receive the following error. "- (1508) The input buffer has been exhausted while attempting to convert ABEND_DATA in Execute. The end of the input buffer has been reached and Transaction Integrator is expecting to perform data conversions on one or more parameters. Check the server program. If it is correct verify, that the correct Transaction Integrator-created component library is deployed.}    System.Exception {System.ServiceModel.FaultException<System.ServiceModel.ExceptionDetail>}"

I've tried initializing all data items, filling with spaces where no values are needed. In C#, the method call.

        private void btnWCF_Click(object sender, EventArgs e)
        {
            try
            {
                using (WCF.ChargeListClient client = new HIS2009WinTestApp.WCF.ChargeListClient())
                {
                    WCF.CASE_DATA c = HISStructInit.NewCaseData();
                    WCF.COUNT_DATA[] count = HISStructInit.NewCountData();
                    WCF.ABEND_DATA abend = HISStructInit.NewAbendData();
                    WCF.ClientContext context = new HIS2009WinTestApp.WCF.ClientContext();
                    context.User = "XXXXXXXX";
                    context.Password = "XXXXXXXX";
                    c.CASE_NO = "0123456";
                    c.HIS_TYPE = "E";
                    client.Execute(ref c, ref count, out abend,ref context);
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.Print(ex.Message);
            }
        }

Here is the initialization class, which will give you an idea of structures.

    public static class HISStructInit
    {
        public static WCF.ABEND_DATA NewAbendData()
        {
            WCF.ABEND_DATA abendData = new WCF.ABEND_DATA();
            Pad(ref abendData);
            return abendData;
        }
        public static WCF.CASE_DATA NewCaseData()
        {

            WCF.CASE_DATA caseData = new WCF.CASE_DATA();
            Pad(ref caseData);

            return caseData;
        }
        public static WCF.COUNT_DATA[] NewCountData()
        {
            WCF.COUNT_DATA[] countData = new WCF.COUNT_DATA[25];

            for (int i = 0; i < 25; i++)
            {
                Pad(ref countData[i]);
            }

            return countData;
        }

        public static void Pad(ref WCF.ABEND_DATA abendData)
        {
            abendData.ABEND_NUMBER= Pad(4);
            abendData.ABEND_PROGRAM= Pad(8);
            abendData.ABEND_CODE= Pad(4);
            abendData.ABEND_MESSAGE= Pad(80);
            abendData.ABEND_DFHEIBLK= Pad(189);
            abendData.ABEND_PCB= Pad(100);
            abendData.ABEND_SQLCA= Pad(187);
        }
        public static void Pad(ref WCF.COUNT_DATA[] countData)
        {
            if (countData == null)
            {
                throw new ArgumentNullException("ref WCF.COUNT_DATA[] countData");
            }
            else
            {
                for (int i=0; i < countData.Length;i++ )
                {
                    Pad(ref countData[i]);
                    //countData[i].COUNT = Pad(2);
                    //countData[i].TRS = Pad(4);
                    //countData[i].DA_OFFENSE_CODE = Pad(6);
                    //countData[i].AON = Pad(8);
                    //countData[i].CIT = Pad(18);
                    //countData[i].AOL = Pad(25);
                    //countData[i].LDA = Pad(2);
                    //countData[i].GOCA = Pad(1);
                    //countData[i].DOA = Pad(10);
                }
            }
        }

        public static void Pad(ref WCF.COUNT_DATA count)
        {
            //char pad = Convert.ToChar(" ");
            count.COUNT= Pad(2);
            count.TRS= Pad(4);
            count.DA_OFFENSE_CODE= Pad(6);
            count.AON= Pad(8);
            count.CIT= Pad(18);
            count.AOL= Pad(25);
            count.LDA= Pad(2);
            count.GOCA= Pad(1);
            count.DOA= Pad(10);
        }

        public static void Pad(ref WCF.CASE_DATA caseData)
        {
            //char pad = Convert.ToChar(" ");
            caseData.CASE_NO= Pad(7);
            caseData.TRN= Pad(10);
            caseData.DOO= Pad(10);
            caseData.HIS_TYPE= Pad(1);
            caseData.NUMBER_OF_COUNTS= Pad(2);
        }
        public static string Pad(int number)
        {
            string value = "";
            for (int i = 1; i <= number; i++)
                value += " ";
            return value;
        }
    }

I can provide any more code, etc., as necessary.

Thanks in advance,
Martin

WCF SAP Adapter throws InvalidOperationException due to XMLReaderParsingException during BAPI call to SAP

Mon, 09 Nov 2009 21:29:23 Z

I use WCF SAP adapter [Microsoft BizTalk Adapter Pack 2.0] to send request to SAP for BAPI transactions.

I get XMLReaderParsingException for the empty field in the XML request to SAP. Here is the actual error message:

“Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The length of the value for the field exceeds the allowed value. Value: 5 Field: “<Field Name>” Allowed value: 3”

The actual field contains no values and its blank "<FieldName />".

Due to the above exception, SAP Adapter terminates all the other running (in-process) transactions during BAPI_TRANSACTION_COMMIT call and throws below mentioned exception:

System.InvalidOperationException: The Inner Channel to use was not found for the key {54E914C8-1FDF-4CA0-8FFA-D40B106EAB3A}_{0D06C358-1068-4460-ABDD-DB7DEC0D249A};URI= "<connection URI> ". Specify a valid key.”

I can re-produce this scenario by adding blank spaces in the XML during initial BAPI call to SAP for one of the transactions.

I would really appreciate if someone can help me out on this issue.

Thanks

Oracle WCF-LOB, pollingInterval

Wed, 11 Nov 2009 00:45:56 Z

Hi guys,

I am using Oracle WCF-LOB adapter for polling Oracle database, pollingInterval is set to 1800 secs (30 mins). The issue is that the adapter kicks in not every 30 mins as I expect, but at random intervals - 1 hour, 5 bours, 1 hour 30 mins, then there may be a couple of 30 mins intervals and so on...
Did anyone experience such a behavior?

Thanks a lot!

Problem with SQLEXECUTE

Thu, 29 Oct 2009 22:13:59 Z

I am getting this error.

"It will be retransmitted after the retry interval specified for this Send Port. Details:"System.Xml.XmlException: Start element 'SQLSTATEMENT' expected. Found element 'ns0:SQLSTATEMENT' from namespace 'http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE'."

I am trying to use SQLEXECUTE. No problem with the sample on BT 2009. When I create my own project and map a simple schema to the SQLEXECUTE schema if fails. Any help would be appreciated.

<?xml version="1.0" encoding="utf-16" ?>

- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns="http://WorkOrderService.InputForSQLEXECUTE" targetNamespace="http://WorkOrderService.InputForSQLEXECUTE" xmlns:xs="http://www.w3.org/2001/XMLSchema">

- <xs:element name="SqlInput">

- <xs:complexType>

- <xs:sequence>

<xs:element name="WONumber" type="xs:string" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

Details ....

Event Type: Warning
Event Source: BizTalk Server 2009
Event Category: (1)
Event ID: 5743
Date:  10/29/2009
Time:  3:44:09 PM
User:  N/A
Computer: lmsbizd03.til.csu.org
Description:
The adapter failed to transmit message going to send port "WcfSendPort_OracleDBBinding_SQLEXECUTE_OperationGroup_Custom" with URL "oracledb://gisdev". It will be retransmitted after the retry interval specified for this Send Port. Details:"System.Xml.XmlException: Start element 'SQLSTATEMENT' expected. Found element 'ns0:SQLSTATEMENT' from namespace 'http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE'.

Server stack trace:
   at System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult result)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult result)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.RequestCallback(IAsyncResult result)".

Martin Honnen from a previous post says you can apply this style sheet to a to the map. Does anyone know how to do this

<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="*">
    <xsl:element name="{local-name()}" namespace="{namespace-uri()}">
      <xsl:apply-templates select="@* | node()"/>
    </xsl:element>
</xsl:template>

<xsl:template match="@* | text() | processing-instruction() | comment()">
    <xsl:copy/>
</xsl:template>
</xsl:stylesheet>

Thanks!

After doing some more research it appears that you have to do another map prior to this applying this stylesheet
from basic schema --> basic schema(stripped of ns:0)

BizTalk 2009 x64: SQL and MQSeries Adapters

Mon, 16 Nov 2009 15:18:41 Z

Hi all

I have no BizTalk experience here, so bear with me.

We're looking at setting up a BizTalk 2009 platform and we're looking at the build for the servers. Performance will not be a particularly pressing consideration for now, but we want to implement a scalable solution. To that end, we're looking at installing on Windows x64 to leverage the extra memory capacity. I just want to know if this precludes any future implementations. Initially we will need to cater for a SQL Adapter and maybe a MQSeries adapter, but looking at this page

http://msdn.microsoft.com/en-us/library/aa560166%28BTS.10%29.aspx

and a few others, I'm a little unsure of the support position of the adapters if we go x64.

Can anyone confirm that the SQL Adapter and the MQSeries adapter are supported on x64? Can I take it that it's just the host-instance that must be 32-bit for these (not the host), and does anyone have any experience or advice for this configuration?

Thanks

Ewan

If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.

Biztalk server 2005 - How do I Send an XML File to a https://soap-??????/rosettanet/default.aspx address

Fri, 13 Nov 2009 17:34:16 Z

I have followed the Biztalk server 2005 tutorials and it has given me a little insight/knowledge into Biztalk.

I need to send an XML file to a URL. I have the XML file and I just want to be able to send it to the URL.

Do I need some Secure FTP software to do this or can I do this through Biztalk?

Can someone please advice the easiest/simplest way to be able to send the file to the URL via Biztalk.

I would greatly appreciate any help.

Thank You,

Dave

The adapter "MSMQ" raised an error message. Details "Message Queuing has not been installed on this computer.".

Thu, 12 Nov 2009 18:29:01 Z

In my application The MSMQ Receive location is configured to receive the message from Remote computer MSMQ.

On the System on which biztalk is installed MSMQ is not installed.

When i submit the message in receive location (Remote computer MSMQ) i got the following error
"The adapter "MSMQ" raised an error message. Details "Message Queuing has not been installed on this computer.".

Is it require to install Message Queuing on the Biztalk server.?