We are running Biztalk 2004, and we have an orchestration that uses two
"helper" apps (.dll's that are added as references.)

Both of these helpers open OleDb connections.  The problem is that when we
have both references, we cannot load the orchestration, and it ends with
error stating that "System.Data.OleDb.OleDbConnection"..."is not marked as
serializable".

However, if we only reference one of the helper apps we do not get this
error.  This is true for either helper app, but when we try to reference
both, it fails.

I am looking for any insight on this.

Thanks,

Kevin Sundquist

[ Post a follow-up to this message ]

Some additional clarification:

It does not look as though this is occuring at "load" time.

We are able to build and deploy the orchestration, and on the first
instantiation of the orchestration, we were getting the "not serializable"
error, but it was not logging the biztalk events in the debugger(which is
what led us to believe that it was a load issue in the first place).

However, with some more brute force testing we have been able to determine
that it is related to have send ports added to the orchestration.  We
stripped out all of our send ports, and the error disappeared.  When we
added the first send port (to help debug) the error re-occured.  With
testing we have determined that this is consistent.  Remove the port - no
error.  Add the port - error.

Again, any thoughts on this are appreciated.

TIA,

Kevin Sundquist

[ Post a follow-up to this message ]

Try marking the declaration of the OleDbConnection as nonserializable like:
(vb.net)
<NonSerialized()> private myConnection as System.Data.OleDb.OleDbConnection
(c#)
[NonSerialized()] private System.Data.OleDb.OleDbConnection myConnection
;

I ran into this a while back with a .net component used in a rule being
called from orchestration.  Short story is that many of the .Net objects in
the System namespace are marked as nonserializable, but our component we
were using for the rule was marked as serializable.  The solution in this
case is to just mark any declaration that uses these as nonserialized.

Larry Franks

This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| From: "Kevin Sundquist" <kdsundquist@pcl.com>
| Newsgroups: microsoft.public.biztalk.general
| Subject: OleDB Serialization Error
| Lines: 19
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2739.300
| Message-ID: <AKTKc.78233$Rf.34669@edtnps84>
| Date: Mon, 19 Jul 2004 17:42:56 GMT
| NNTP-Posting-Host: 209.5.7.6
| X-Trace: edtnps84 1090258976 209.5.7.6 (Mon, 19 Jul 2004 11:42:56 MDT)
| NNTP-Posting-Date: Mon, 19 Jul 2004 11:42:56 MDT
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!border1.nntp.dca.gi
ganews.com!nntp.giganews.com!news-feed01.roc.ny.frontiernet.net!nntp.frontie
rnet.net!newsfeed2.telusplanet.net!newsfeed.telus.net!edtnps84.POSTED!8e8f0c
9c!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:17457
| X-Tomcat-NG: microsoft.public.biztalk.general
|
| We are running Biztalk 2004, and we have an orchestration that uses two
| "helper" apps (.dll's that are added as references.)
|
| Both of these helpers open OleDb connections.  The problem is that when we
| have both references, we cannot load the orchestration, and it ends with
| error stating that "System.Data.OleDb.OleDbConnection"..."is not marked as
| serializable".
|
| However, if we only reference one of the helper apps we do not get this
| error.  This is true for either helper app, but when we try to reference
| both, it fails.
|
| I am looking for any insight on this.
|
| Thanks,
|
| Kevin Sundquist
|
|
|

[ Post a follow-up to this message ]

Kevin:
does larry's advance solve your problem?
because I has the same sistuation.
and after I add [NonSerialized()] on my OleDbConnection,
it doesnot appear error message.
but the data still can not insert in my DB[Sybase]...
Any thoughts on this are appreciated,

David

[ Post a follow-up to this message ]

OK, I solve it already.
The problem is in my Expression Sharp, I do not create the component
class's instance.

David

[ Post a follow-up to this message ]