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 9 4932
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.
--------------------
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.
--------------------
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.
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.
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
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
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
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Matthew Houseman |
last post by:
All,
I've created a synonym that points to a package over a database link
like so:
CREATE SYNONYM API_MYLINK FOR USER.CSAPI_V2@INSTANCE.DOMAIN.COM
I've granted execute like so:
grant execute...
|
by: J.Bijleveld |
last post by:
Hello colleagues,
At this moment we have a real big problem using a .NET application with an
Oracle database (v8.1.6).
I hope someone has encountered this problem before and is able to help me...
|
by: J.Bijleveld |
last post by:
Hello colleagues,
At this moment we have a real big problem using a .NET application
with an Oracle database (v8.1.6). I hope someone has encountered this
problem before and is able to help me...
|
by: Mike S. |
last post by:
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
...
|
by: dave v |
last post by:
I thought I read in an earlier post that there are known issues with
deserialization in the System.Data.OracleClient.dll. Can anyone expand on
that or give a workaround?
I'm calling a custom...
|
by: Nathan Sokalski |
last post by:
I want to create a procedure in ASP.NET to run the "SET DEFINE OFF" command
in an Oracle database. I tried the following:
Public Shared Sub SetDefineOff()
Dim myconnection As New...
|
by: Diffident |
last post by:
Hello All,
How can I throw an OracleException programmatically? What are the different
constructors for this class?
Thanks!!!
|
by: Chris |
last post by:
I am getting the following exception when I try and connection to a remote
oracle database. The same code works fine when I run it as an application.
For the life of me I can't figure out why it...
|
by: jstmehr4u3 |
last post by:
I just installed ODP.net 10.2.02 on my local machine (Windows XP Pro)
running IIS.
I have created a sample webservice in VS2003, connecting to localhost.
I am getting:...
|
by: |
last post by:
Hi All,
I have a client connection problem with Oracle.
The exe which i did with C# (vs.net 2005) and Oracle XE , works well on my
developer machine but i am getting a connection string error on...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shćllîpôpď 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |