BizTalk Server 2006 R2 SP1

0
Filed under BPI
Tagged as

Microsoft published SP1 for BizTalk Server 2006 R2. You can find it here.

From the Microsoft site:

Better reliability, performance, and scale for the following key features:

  • Throttling and dehydration of orchestrations.
  • Archiving and purging operations.
  • BAM alerts and archiving.
  • HIPAA.
  • Reduced memory consumption in scenarios using scripting functoids.
  • Improvement in the bts_FindSubscription stored proc, resulting in faster execution and lower CPU utilization.

Better management and deployment experiences:

  • Performance and user experience improvements of key scenarios.
  • WCF configuration management.
  • Significant improvement in deployment time for send ports using a map.

Improved support:

  • X12 and EDIFACT updates.
  • Increased footprint of supported FTP servers and locale.
  • XMLDocument message types in orchestrations.
  • Configurable timeout for Basic HTTP.
  • WCF adaptor now suspends messages instead of terminating when the host instance is stopped.
  • Configurable transaction timeout for WCF Adaptors.
  • Mapping of inline schema for SQL Adaptor now allows for using $ characters as part of the updategram.
  • The SQL Adaptor now supports calling from a BizTalk Server dynamic send port. The following properties can be set on the call to the dynamic port:
          Connection string (all the SQL connection properties)
          Document Target Namespace
          Response Document Root Element
  • Ability to disable generation of Routing Failure Report.
  • Fixes to some issues that used to cause high CPU usage by BizTalk Server hosts due to certain .NET updates.
  • Ability to use multiple certificates for signing outbound messages.
  • Message Pack 2009.
  • Message property tracking with BAM for all messages in the interchange, irrespective of the usage of pipeline or mapping.
  • Integrated tracing to help in debugging EDI specific issues. This improvement is aimed at reducing the time taken for diagnosing and isolating an EDI problem.

New Features:

  • For WCF-Custom and WCF-CustomIsolated Adapters, the ability to look up custom bindings from locations other than machine.config.
  • Support for using multiple certificates to sign outgoing AS2 messages.
  • Share/Bookmark

“The type System.Xml.XmlDocument may not be used in this context”

0
Filed under BPI
Tagged as , ,

We received this message. It was clear it had to do something with the SOAP call and the message type was not set. This can have several reasons: schemas not deployed correctly, target namespace wrong, root name wrong, etc. The SOAP adapter must be able to find the corresponding schema for serializing. In our case we forgot to enter the proxy assembly, type name and the method to use (created a new two-way send port instead of a one-way send port). This proxy assembly holds knowledge on the schema to use.

Error message:

General exception soap Microsoft.XLANGs.Core.XlangSoapException: An error occurred while processing the message, refer to the details section for more information
Message ID: {8E2E044D-EA52-4006-9F1C-32A25DC2A2AC}
Instance ID: {5FCED1F3-8D45-430C-B45F-A77E7D0E46CE}
Error Description: SoapException: Server was unable to process request. —> There was an error generating the XML document. —> The type System.Xml.XmlDocument may not be used in this context.
   at Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.VerifyTransport(Envelope env, Int32 operationId, Context ctx)
   at Microsoft.XLANGs.Core.Subscription.Receive(Segment s, Context ctx, Envelope& env, Boolean topOnly)
   at Microsoft.XLANGs.Core.PortBase.GetMessageId(Subscription subscription, Segment currentSegment, Context cxt, Envelope& env, CachedObject location)
   at DTAOrderMessaging.ProcessOrder.segment2(StopConditions stopOn)
   at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)

Proxy configuration:

clip_image002

 

Question raised on my site: does BizTalk hold history/information on changed configuration items with a timestamp and user?

Or must we dive in the SQL logs, or must we capture it our self? (didn’t do any investigation on this part)

  • Share/Bookmark

Extending a BizTalk ESB Toolkit On-Ramp into the Cloud: a demo by Brian Loesgen

0
Filed under BPI
Tagged as , , ,

Brian Loesgen created a great demo on the Azure platform AppFabric Service Bus. This demo showed also some features (combinations) of Business Rule Engine, ESB Toolkit, InfoPath and SharePoint.

You can find the video here.

  • Share/Bookmark

Installing BizTalk Server 2009 on Windows 7

0
Filed under BPI
Tagged as

Normally I’m developing on a Windows Server system. But within our company we are moving as developers to Windows 7, because we segregate our duties to some other disciplines (like testing and building packages). I still like working on a server machine, because I will run into problems which also can occur in a production environment. On a Windows 7 machine I have to trust my colleagues that they will test everything (sorry guys :D ). Note: I wouldn’t have a problem when our integration test server machine was part of the daily build (so automated integration tests). Nice discussion. Leave some comments on how you feel about this.

Back to installing BizTalk Server 2009 on Windows 7. The setup runs smoothly, BUT if you want to use the BAM portal then it is possible that you receive the next screen:

image

In my case it had to do with my 64-bit system. The BAM portal runs in 32 bit mode. To make this work do the following:

image

Enable IIS 6 compatibility mode via Windows features (Control Panel –> Programs and Features).

Start a command prompt as an Administrator:

image

Execute the next command: cscript.exe c:\Inetpub\AdminScripts\adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 1

Continue the BizTalk Server 2009 Configuration tool. Now you can select the BAM Portal Web Site (default or another one).

 

Best wishes for 2010 and happy BizTalk-ing!!!

  • Share/Bookmark

BTUG Netherlands: 19th of January

0
Filed under BPI

The next BTUG is on the 19th of January in Amstelveen. They have made an interesting agenda:

Wouter Krooy – BizTalk 2009 + ESBT 2.0 in an event driven architecture
Martin Rienstra – Making orchestrations robust
Dick Dijkstra – live SAP-demo
Patrick Wellink – Best practices in the BizTalk Software Factory from Logica

  • Share/Bookmark

Presentation about Healthcare and BizTalk Accelerator for HL7 (EN)

0
Filed under BPI
Tagged as , ,

I placed an English version of this presentation on this site. Don’t hesitate to contact me if you have questions or remarks. Click here.

Cheers Gerben

  • Share/Bookmark

“The itinerary header could not be found”

1
Filed under Uncategorized
Tagged as ,

I still receive this message. I also dropped it in the Microsoft BizTalk ESB Toolkit forum. I got response and it pointed me to the tracing possibilities. I’m using the ESB Toolkit for a while now, but didn’t use this feature. If you really get stuck with problem solving, then this is a nice feature to use. Dwight Goins blogged about this. (note: it didn’t gave me the information I needed, but I think it still will help me in the near future).

  • Share/Bookmark

Presentation about Healthcare and BizTalk Accelerator for HL7

2
Filed under BPI
Tagged as ,

Last week I gave a presentation at the BTUG (NL), and I really enjoyed it. The presentation can be found here (note: it is Dutch). If you need more information or in English then please contact me.

  • Share/Bookmark

SOA Manifesto

0
Filed under BPI
Tagged as ,

Last week some clever people set up the SOA Manifesto. The people involved in this are international known speakers / evangelists from different companies and are in one way or another competitors to each other when it comes to products and licenses (sales). Therefore it is good to see that there is a manifesto where the whole community can work with, but more important to create business value to our customers. I would encourage you to watch the presentation, or read the manifesto (clear and easy to understand).

  • Share/Bookmark

Error while deploying to BAM

0
Filed under BPI
Tagged as ,

On my new virtual machine BizTalk Server and all features are installed, including Business Activity Monitoring. But somehow some security settings are not set correctly. To solve this problem I made the service account DBO on the BAMPrimaryImport database, that did the job.

So, what was happening. While deploying it is using some service and it is not using my own account. I receive the next message in the EventLog (MSSQLServerOLAPService):

OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object ‘bam_RegNonHL7MsgVw_ChangeToHL7Progress_RTATable’, database ‘BAMPrimaryImport’, schema ‘dbo’.; 42000.

and (BamManagementUtility):

Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. —> Microsoft.AnalysisServices.OperationException: OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object ‘bam_RegNonHL7MsgVw_ChangeToHL7Progress_RTATable’, database ‘BAMPrimaryImport’, schema ‘dbo’.; 42000.
Server: The operation has been cancelled.

   at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
   at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact)
   at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
   at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
   at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)
   at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType)
   at Microsoft.BizTalk.Bam.Management.Olap2008Helper.CreateRtaCubes(Database db, XmlNode cubeNode)
   at Microsoft.BizTalk.Bam.Management.Olap2008Helper.CreateOlapInfrastructure(Boolean realTimeOnly)
   at Microsoft.BizTalk.Bam.Management.Olap2008Helper.CreateOlapInfrastructure()
   at Microsoft.BizTalk.Bam.Management.ViewModule.Create(XmlDocument defXmlDoc)
   at Microsoft.BizTalk.Bam.Management.WorkerModule.DispatchOperation(OperationType operation, XmlDocument defXmlDoc)
   at Microsoft.BizTalk.Bam.Management.BamManager.ProcessOneBamArtifactType(BamArtifactType bamArtifact, OperationType operation)
   at Microsoft.BizTalk.Bam.Management.BamManager.ManageInfrastructure(OperationType operation)
   at Microsoft.BizTalk.Bam.Management.BamManager.Deploy()
   — End of inner exception stack trace —
   at Microsoft.BizTalk.Bam.Management.BamManager.Deploy()
   at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.HandleDeployAll()
   at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.DispatchCommand()
   at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Run()
   at Microsoft.BizTalk.Bam.Management.BamManagementUtility.BamManagementUtility.Main(String[] args)

Did I gave too much access to this service account? Or what access level should I set for the Service Account in SQL Server on the BAMPrimaryImport?

  • Share/Bookmark