OracleException

[Mike S.]

When we do remote calls to a component that throws a System.Data.OracleClient.OracleException, we see a SerializationException when the original OracleException is being deserialized on the client

Any ideas

22-Apr-2004 10:05:46---System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.Serialization.SerializationExceptio n: Member message was not found
at System.Runtime.Serialization.SerializationInfo.Get Element(String name, Type& foundType
at System.Runtime.Serialization.SerializationInfo.Get Value(String name, Type type
at System.Data.OracleClient.OracleException..ctor(Ser ializationInfo si, StreamingContext sc
--- End of inner exception stack trace --

Server stack trace:
at System.Reflection.RuntimeConstructorInfo.Serializa tionInvoke(Object target, SerializationInfo info, StreamingContext context
at System.Runtime.Serialization.ObjectManager.Complet eISerializableObject(Object obj, SerializationInfo info, StreamingContext context
at System.Runtime.Serialization.ObjectManager.FixupSp ecialObject(ObjectHolder holder
at System.Runtime.Serialization.ObjectManager.DoFixup s(
at System.Runtime.Serialization.Formatters.Binary.Obj ectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, IMethodCallMessage methodCallMessage
at System.Runtime.Serialization.Formatters.Binary.Bin aryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, IMethodCallMessage methodCallMessage
at System.Runtime.Serialization.Formatters.Binary.Bin aryFormatter.UnsafeDeserializeMethodResponse(Strea m serializationStream, HeaderHandler handler, IMethodCallMessage methodCallMessage
at System.Runtime.Remoting.Channels.CoreChannel.Deser ializeBinaryResponseMessage(Stream inputStream, IMethodCallMessage reqMsg, Boolean bStrictBinding
at System.Runtime.Remoting.Channels.BinaryClientForma tterSink.DeserializeMessage(IMethodCallMessage mcm, ITransportHeaders headers, Stream stream
at System.Runtime.Remoting.Channels.BinaryClientForma tterSink.SyncProcessMessage(IMessage msg

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage reqMsg, IMessage retMsg
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData, Int32 type
at OracleExceptionInterfaces.BaseSimpleData_DA.GetDat a(
at OracleExceptionClient.Form1.Button1_Click(Object sender, EventArgs e) in C:\Starr\EBusiness.Net\Applications\OracleExceptio nClient\Form1.vb:line 65

[Gary Chang]

Hi Mike,

Currently I am looking for somebody who could help you on it. We will reply
here with more information as soon as possible.
If you have any more concerns on it, please feel free to post here.
Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

[Gary Chang]

Hi Mike,

Currently I am looking for somebody who could help you on it. We will reply
here with more information as soon as possible.
If you have any more concerns on it, please feel free to post here.
Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

[Tian Min Huang]

Hello,

Thanks for your post. As I understand, the problem you are facing is that
it fails to deserialize an OracleEception. Please correct me if there is
any misunderstanding. I think more information is needed before moving
forward:

1. What's the version of .NET Framework, 1.0 or 1.1?
2. What's the content of OracleException?
3. Could you please post some code snippet which will demonstrate the
problem?

I look forward to hearing from you.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Tian Min Huang]

Hello,

Thanks for your post. As I understand, the problem you are facing is that
it fails to deserialize an OracleEception. Please correct me if there is
any misunderstanding. I think more information is needed before moving
forward:

1. What's the version of .NET Framework, 1.0 or 1.1?
2. What's the content of OracleException?
3. Could you please post some code snippet which will demonstrate the
problem?

I look forward to hearing from you.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Mike S.]

Tim -

Here are the answers to your question

1. We are using the 1.1 framework

2. When the debuging the "server side", the Server Exception i
? ex.tostrin
"System.Data.OracleClient.OracleException: ORA-00942: table or view does not exis

at System.Data.OracleClient.OracleConnection.CheckErr or(OciHandle errorHandle, Int32 rc
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.ExecuteRead er(CommandBehavior behavior
at System.Data.OracleClient.OracleCommand.System.Data .IDbCommand.ExecuteReader(CommandBehavior behavior
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet
at OracleExceptionTest.SimpleData_DA.GetData() in C:\Starr\EBusiness.Net\Applications\OracleExceptio nTest\SimpleData_DA.vb:line 59

3. Here are the 2 pieces of code involvedâ€

SERVER PROCES
Tr

oDs = New DataSe
'Connecting to a valid Oracle D
oConn = New OracleClient.OracleConnection("Server=DWT.world;Ui d=leguser;Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand("Select * from DWT.bob", oConn
oDA = New OracleDataAdapter(oCommand

oDA.Fill(oDs

oConn.Close(

bContinue = Fals
Catch ex As OracleExceptio
Throw e
Catch ex As Exceptio
Throw e
Finall
If Not (oConn Is Nothing) The
oConn.Dispose(
End I
End Tr

Return oD

CLIENT PROCES
sURI = String.Format("tcp://{0}:{1}/{2}.rem", "localhost", "6742", "SimpleData_DA"
oTest = CType(Activator.GetObject(GetType(OracleExceptionI nterfaces.BaseSimpleData_DA), sURI), OracleExceptionInterfaces.BaseSimpleData_DA
oTest.GetData(

We can provide simple client & server applications which demonstrate the problem

[Mike S.]

Tim -

Here are the answers to your question

1. We are using the 1.1 framework

2. When the debuging the "server side", the Server Exception i
? ex.tostrin
"System.Data.OracleClient.OracleException: ORA-00942: table or view does not exis

at System.Data.OracleClient.OracleConnection.CheckErr or(OciHandle errorHandle, Int32 rc
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.ExecuteRead er(CommandBehavior behavior
at System.Data.OracleClient.OracleCommand.System.Data .IDbCommand.ExecuteReader(CommandBehavior behavior
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet
at OracleExceptionTest.SimpleData_DA.GetData() in C:\Starr\EBusiness.Net\Applications\OracleExceptio nTest\SimpleData_DA.vb:line 59

3. Here are the 2 pieces of code involvedâ€

SERVER PROCES
Tr

oDs = New DataSe
'Connecting to a valid Oracle D
oConn = New OracleClient.OracleConnection("Server=DWT.world;Ui d=leguser;Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand("Select * from DWT.bob", oConn
oDA = New OracleDataAdapter(oCommand

oDA.Fill(oDs

oConn.Close(

bContinue = Fals
Catch ex As OracleExceptio
Throw e
Catch ex As Exceptio
Throw e
Finall
If Not (oConn Is Nothing) The
oConn.Dispose(
End I
End Tr

Return oD

CLIENT PROCES
sURI = String.Format("tcp://{0}:{1}/{2}.rem", "localhost", "6742", "SimpleData_DA"
oTest = CType(Activator.GetObject(GetType(OracleExceptionI nterfaces.BaseSimpleData_DA), sURI), OracleExceptionInterfaces.BaseSimpleData_DA
oTest.GetData(

We can provide simple client & server applications which demonstrate the problem

[Mike S.]

Tim -

Here are the answers to your question

1. We are using the 1.1 framework

2. When the debuging the "server side", the Server Exception i
? ex.tostrin
"System.Data.OracleClient.OracleException: ORA-00942: table or view does not exis

at System.Data.OracleClient.OracleConnection.CheckErr or(OciHandle errorHandle, Int32 rc
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.ExecuteRead er(CommandBehavior behavior
at System.Data.OracleClient.OracleCommand.System.Data .IDbCommand.ExecuteReader(CommandBehavior behavior
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet
at OracleExceptionTest.SimpleData_DA.GetData() in C:\Starr\EBusiness.Net\Applications\OracleExceptio nTest\SimpleData_DA.vb:line 59

3. Here are the 2 pieces of code involvedâ€

SERVER PROCES
Tr

oDs = New DataSe
'Connecting to a valid Oracle D
oConn = New OracleClient.OracleConnection("Server=DWT.world;Ui d=leguser;Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand("Select * from DWT.bob", oConn
oDA = New OracleDataAdapter(oCommand

oDA.Fill(oDs

oConn.Close(

bContinue = Fals
Catch ex As OracleExceptio
Throw e
Catch ex As Exceptio
Throw e
Finall
If Not (oConn Is Nothing) The
oConn.Dispose(
End I
End Tr

Return oD

CLIENT PROCES
sURI = String.Format("tcp://{0}:{1}/{2}.rem", "localhost", "6742", "SimpleData_DA"
oTest = CType(Activator.GetObject(GetType(OracleExceptionI nterfaces.BaseSimpleData_DA), sURI), OracleExceptionInterfaces.BaseSimpleData_DA
oTest.GetData(

We can provide simple client & server applications which demonstrate the problem

[Tian Min Huang]

Hello,

Thanks a lot for your information. After further investigation, I noticed
this is a known issue in deserialization method of the
System.Data.OracleClient.dll.

I will send you another email for detailed information.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Tian Min Huang]

Hello,

Thanks a lot for your information. After further investigation, I noticed
this is a known issue in deserialization method of the
System.Data.OracleClient.dll.

I will send you another email for detailed information.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.