Hello,
If I have my receive location type as FILE, and put 100 of my incoming xml files in the associated directory – Biztalk processes everything perfectly.
If I change my receive location type to be FTP, and put 100 of the incoming xml files in the FTP receive drectory – more then 3/4 of the files get suspended and i receive the following error in my event log:
The following stored procedure call failed: \” { call [dbo].[bts_UpdateMsgbox_BizTalkServerApplication]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}\”. SQL Server returned error string: \”Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.\”.
Unfortunately I need to use an FTP receive location type. does anyone know what is happening? or some link to help me out,
Thanks,
–Steven