BizTalk Server Orchestration

Author

FTP port audits

mnet123

2005-06-06, 5:56 pm

I had a situation where i am picking up file from a file location.
This file is mapped and then send to a FTP location.
Now i have to audit this. I have to send a row to a SQL table, only
when the FTP is successfull. Now if the ftp failed after Biztalk
attempts multiple times, then the SQL row should not be inserted.

I am not getting what i wanted. I used orchestration. If FTP service
is stopped, Biztalk gives a warning that it will try again, and then
proceeds to the next step (which inserts the SQL row)

--
Any idea how to achieve this.

WenJun Zhang[msft]

2005-06-07, 7:52 am

Hi,

For FTP server down or network error causing the FTP sending failure,
we should be able to catch that via an orchestration scope sharp and
exception handling block.

Catch Exception Block
http://msdn.microsoft.com/library/d...ary/en-us/sdk/h
tm/ebiz_prog_orch_rouy.asp

You can add your SQL operation into the block to audit the exception.

Hope this helps. Let me know if you have any further question.
Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

mnet123

2005-06-07, 5:57 pm

Does not seem to work.

I have a simple orchestration. - Receive Port; A scope with long-running
type and exception handler. Inside scope there is a send port and call to SQL
insert .net serializable assembly.
The exception block has a port to send smtp message.

The SQL insert always get executed, even when FTP service is down forever.
Also i dont think the exception is getting called, since i dont get any
message.

any ideas?
--
Regards

""WenJun Zhang[msft]"" wrote:

> Hi,
>
> For FTP server down or network error causing the FTP sending failure,
> we should be able to catch that via an orchestration scope sharp and
> exception handling block.
>
> Catch Exception Block
> http://msdn.microsoft.com/library/d...ary/en-us/sdk/h
> tm/ebiz_prog_orch_rouy.asp
>
> You can add your SQL operation into the block to audit the exception.
>
> Hope this helps. Let me know if you have any further question.
> Thanks.
>
> Best regards,
>
> WenJun Zhang
> Microsoft Online Partner Support
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

WenJun Zhang[msft]

2005-06-08, 7:47 am

That's ok. I'll research into this and update the results here.
Please wait for my message

Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

WenJun Zhang[msft]

2005-06-09, 7:48 am

Hi,

The problem may be that you haven't set Delivery Notification on the
port. Please make sure "Delivery Notification" is set to
"Transmitted" in the orchestration designer and test again.

Let me know how the thing is going.
Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

WenJun Zhang[msft]

2005-06-13, 7:52 am

Hi,

Any update on this issue? Has enable Delivery Notification helped on
resolving the problem?

Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

mnet123

2005-06-13, 5:51 pm

yes, i got that part working using Delivery notification and
DeliveryFailureException.

I still have a problem.
After FTP, i was wanting to insert a SQL row into a table. For this i had a
assembly which was calling a stored proc. Orchestration gives Xlang error.
------------------------------
Uncaught exception terminated service
VISRFulfilmentBiz.SendFiletoFulfill(167f4f2a-ba63-caae-8101-ba8ae6de4d5f),
instance 22f1d5a3-bbde-44c9-ba00-6995380787b0

The type System.Data.SqlClient.SqlConnection in Assembly System.Data,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 is not
marked as serializable.

Exception type: SerializationException
Source: mscorlib
Target Site: System.Reflection.MemberInfo[]
InternalGetSerializableMembers(System.RuntimeType, Boolean)
----------------------------------------------------------
I have made my assembly serializable. But cannot change SqlConnection class.
SO how to proceed. I didnot want to use the SQL adapter or Updategrams.
--
Regards

""WenJun Zhang[msft]"" wrote:

> Hi,
>
> Any update on this issue? Has enable Delivery Notification helped on
> resolving the problem?
>
> Thanks.
>
> Best regards,
>
> WenJun Zhang
> Microsoft Online Partner Support
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

WenJun Zhang[msft]

2005-06-14, 7:47 am

Hi,

If a class is not Serializable and you need to use it, you'll need to
limit its scope to an atomic scope for being used directly in an
expression shape. If the class is getting used in another user class
that is marked [Serializable], please make sure to mark the member
with the attribute [NonSerialized].

Thanks.

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

mnet123

2005-06-14, 5:55 pm

That works perfect.
I had not made the SQLClient class <NonSerialized>.
Now i am able to call the assembly and call the SQL SP also.
Your feedback helped.
--
Regards

""WenJun Zhang[msft]"" wrote:

> Hi,
>
> If a class is not Serializable and you need to use it, you'll need to
> limit its scope to an atomic scope for being used directly in an
> expression shape. If the class is getting used in another user class
> that is marked [Serializable], please make sure to mark the member
> with the attribute [NonSerialized].
>
> Thanks.
>
> Best regards,
>
> WenJun Zhang
> Microsoft Online Partner Support
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

WenJun Zhang[msft]

2005-06-15, 7:47 am

You are welcome. :-)

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no
rights.