Send a large XML to SQL-Server

Hi,

im trying to send a 35 MB XML file with BT2009 over the WCF-adapter to a stored procedure to a MS SQL 2008 database, but the orchestration runs and runs and runs … without any end.

The XML file consitts of 12000 data sets. Each Element is made of 30 elements.

If i shorten the file to 3000 datasets (8 MB), this runs perfectly.

1 times it worked wit th 35 MB file – but sadly only 1 time … !?!?

What can i do?

I´ve tryed to change the “Large message fragment size to 1000000” and have created the registry key “HKLM\Software\Microsoft\BizTalk Server\3.0\Administration\TransformThreshold: 2097152”.

I have enlarged the receive and the send timeout from the sendport to the sql-server to 1 hour.

But this hasn´t solved my problem.

(In the Group Hub i have 2 instances. An active and a dehydrated instance)

Is there a timeout, i can´t find? Can the SQL-Server be the reason for the problem?

Thanks for your hints!