BizTalk 2004 :: need help with atomic scope and batching




Hello, I am getting the following error:

Event Type: Warning Event Source: BizTalk Server 2004 Event Category: (1) Event ID: 5410 Computer: BizTalkServer
Description: An error has occurred that requires the BizTalk service to terminate. The most common causes are an unexpected out of memory error and an inability to connect or a loss of connectivity to one of the BizTalk databases. The service will shutdown and auto-restart in 1 minute. If the problematic database remains unavailable, this cycle will repeat.


This link describes the problem I am having and gives a solution which seems like my problem:

http://support.microsoft.com/?scid=kb;en-us;899599&spid=1444&sid=126

No luck.

I have a message splitting orchestration which receives a large message, then batches (using an atomic scope) the split messages into blocks of 100 (in a loop). The objective is to reduce persistence points since I will have up to 8000 messages in a batch.

The split messages are sent to a seperate orchestration for further processing using a direct port binding.

............

I tried the following (In all scenarios memory usage and processor are both within normal limits):

A smaller size xml message, same behavior

A smaller batch of 10 messages triggers the "Exception occurred when persisting state to the database." error
A smaller batch of 5 messages also triggers the "Exception occurred when persisting state to the database." error
An even smaller batch of 2 messages also triggers the "Exception occurred when persisting state to the database." error


That error message is described here:

Exception occurred when persisting state to the database.
Exception type: PublishMessageException
Source: Target Site: Help Link: Additional error information:


Failed to publish (send) a message in the batch. This is usually because there is no one expecting to receive this message. The error was Error in accessing the part data or one of its fragments. The part or fragment may not exist in the database. with status -1061151960.
This happens if you're calling other orchestrations which are not running but that is not the case for me.



Removing the atomic scope (thus no batch or batch of 1) makes everything work fine.



If you made it down this far, I would appreciate a hand!

Cheers,
BA
http://biztalkia.blogspot.com/



.



Relevant Pages

  • Re: Migration from native Btrieve calls to SQL with ZEOS components
    ... The rubber compound is made by the supplier batch by batch of about 200 ... optimize quality an cycletime of the machines. ... Most users know nearly nothing about database, Btrieve, Pervasive and so ... At our Customers we have nearly every version from 6.15 to 9.5. ...
    (comp.databases.btrieve)
  • Re: batch update is sporadically incomplete
    ... the last few entries of a batch are not written. ... > writing to a mysql database using JDBC. ... connection will cause it to use a snapshot that is more current and can ...
    (comp.lang.java.databases)
  • VBA question
    ... sheet and dump it into an Access 2007 database. ... ' exports data from the active batch log to ... Logs\PUR Batch Raw Log.accdb") ...
    (microsoft.public.access.modulesdaovba)
  • BTS2004 MQSeries Adapter and transactions
    ... I'm using BizTalk Server 2004 SP1 and the MQSeries adapter and I'm ... Maximum Messages in batch = 100 ...
    (microsoft.public.biztalk.general)
  • Re: Cobol .DAT backup solution
    ... Online databases and transaction logs on a mirrored filesystem. ... figure out is how to integrate "batch" updates into a database that also has ... the batch processing deadline into our "beginning of day" batch data. ...
    (comp.lang.cobol)