When we do remote calls to a component that throws a System.Data.Ora cleClient.Oracl eException, we see a SerializationEx ception when the original OracleException is being deserialized on the client
Any ideas
22-Apr-2004 10:05:46---System.Reflecti on.TargetInvoca tionException: Exception has been thrown by the target of an invocation. ---> System.Runtime. Serialization.S erializationExc eption: Member message was not found
at System.Runtime. Serialization.S erializationInf o.GetElement(St ring name, Type& foundType
at System.Runtime. Serialization.S erializationInf o.GetValue(Stri ng name, Type type
at System.Data.Ora cleClient.Oracl eException..cto r(Serialization Info si, StreamingContex t sc
--- End of inner exception stack trace --
Server stack trace:
at System.Reflecti on.RuntimeConst ructorInfo.Seri alizationInvoke (Object target, SerializationIn fo info, StreamingContex t context
at System.Runtime. Serialization.O bjectManager.Co mpleteISerializ ableObject(Obje ct obj, SerializationIn fo info, StreamingContex t context
at System.Runtime. Serialization.O bjectManager.Fi xupSpecialObjec t(ObjectHolder holder
at System.Runtime. Serialization.O bjectManager.Do Fixups(
at System.Runtime. Serialization.F ormatters.Binar y.ObjectReader. Deserialize(Hea derHandler handler, __BinaryParser serParser, Boolean fCheck, IMethodCallMess age methodCallMessa ge
at System.Runtime. Serialization.F ormatters.Binar y.BinaryFormatt er.Deserialize( Stream serializationSt ream, HeaderHandler handler, Boolean fCheck, IMethodCallMess age methodCallMessa ge
at System.Runtime. Serialization.F ormatters.Binar y.BinaryFormatt er.UnsafeDeseri alizeMethodResp onse(Stream serializationSt ream, HeaderHandler handler, IMethodCallMess age methodCallMessa ge
at System.Runtime. Remoting.Channe ls.CoreChannel. DeserializeBina ryResponseMessa ge(Stream inputStream, IMethodCallMess age reqMsg, Boolean bStrictBinding
at System.Runtime. Remoting.Channe ls.BinaryClient FormatterSink.D eserializeMessa ge(IMethodCallM essage mcm, ITransportHeade rs headers, Stream stream
at System.Runtime. Remoting.Channe ls.BinaryClient FormatterSink.S yncProcessMessa ge(IMessage msg
Exception rethrown at [0]:
at System.Runtime. Remoting.Proxie s.RealProxy.Han dleReturnMessag e(IMessage reqMsg, IMessage retMsg
at System.Runtime. Remoting.Proxie s.RealProxy.Pri vateInvoke(Mess ageData& msgData, Int32 type
at OracleException Interfaces.Base SimpleData_DA.G etData(
at OracleException Client.Form1.Bu tton1_Click(Obj ect sender, EventArgs e) in C:\Starr\EBusin ess.Net\Applica tions\OracleExc eptionClient\Fo rm1.vb:line 65
9  4957 
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 misunderstandin g. 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 misunderstandin g. 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.Or acleClient.Orac leException: ORA-00942: table or view does not exis
at System.Data.Ora cleClient.Oracl eConnection.Che ckError(OciHand le errorHandle, Int32 rc
at System.Data.Ora cleClient.Oracl eCommand.Execut e(OciHandle statementHandle , CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor , ArrayList& refCursorParame terOrdinals
at System.Data.Ora cleClient.Oracl eCommand.Execut e(OciHandle statementHandle , CommandBehavior behavior, ArrayList& refCursorParame terOrdinals
at System.Data.Ora cleClient.Oracl eCommand.Execut eReader(Command Behavior behavior
at System.Data.Ora cleClient.Oracl eCommand.System .Data.IDbComman d.ExecuteReader (CommandBehavio r behavior
at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet
at OracleException Test.SimpleData _DA.GetData() in C:\Starr\EBusin ess.Net\Applica tions\OracleExc eptionTest\Simp leData_DA.vb:li ne 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.Or acleConnection( "Server=DWT.wor ld;Uid=leguser; Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand(" Select * from DWT.bob", oConn
oDA = New OracleDataAdapt er(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(GetT ype(OracleExcep tionInterfaces. BaseSimpleData_ DA), sURI), OracleException Interfaces.Base SimpleData_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.Or acleClient.Orac leException: ORA-00942: table or view does not exis
at System.Data.Ora cleClient.Oracl eConnection.Che ckError(OciHand le errorHandle, Int32 rc
at System.Data.Ora cleClient.Oracl eCommand.Execut e(OciHandle statementHandle , CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor , ArrayList& refCursorParame terOrdinals
at System.Data.Ora cleClient.Oracl eCommand.Execut e(OciHandle statementHandle , CommandBehavior behavior, ArrayList& refCursorParame terOrdinals
at System.Data.Ora cleClient.Oracl eCommand.Execut eReader(Command Behavior behavior
at System.Data.Ora cleClient.Oracl eCommand.System .Data.IDbComman d.ExecuteReader (CommandBehavio r behavior
at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet
at OracleException Test.SimpleData _DA.GetData() in C:\Starr\EBusin ess.Net\Applica tions\OracleExc eptionTest\Simp leData_DA.vb:li ne 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.Or acleConnection( "Server=DWT.wor ld;Uid=leguser; Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand(" Select * from DWT.bob", oConn
oDA = New OracleDataAdapt er(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(GetT ype(OracleExcep tionInterfaces. BaseSimpleData_ DA), sURI), OracleException Interfaces.Base SimpleData_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.Or acleClient.Orac leException: ORA-00942: table or view does not exis
at System.Data.Ora cleClient.Oracl eConnection.Che ckError(OciHand le errorHandle, Int32 rc
at System.Data.Ora cleClient.Oracl eCommand.Execut e(OciHandle statementHandle , CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor , ArrayList& refCursorParame terOrdinals
at System.Data.Ora cleClient.Oracl eCommand.Execut e(OciHandle statementHandle , CommandBehavior behavior, ArrayList& refCursorParame terOrdinals
at System.Data.Ora cleClient.Oracl eCommand.Execut eReader(Command Behavior behavior
at System.Data.Ora cleClient.Oracl eCommand.System .Data.IDbComman d.ExecuteReader (CommandBehavio r behavior
at System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet
at OracleException Test.SimpleData _DA.GetData() in C:\Starr\EBusin ess.Net\Applica tions\OracleExc eptionTest\Simp leData_DA.vb:li ne 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.Or acleConnection( "Server=DWT.wor ld;Uid=leguser; Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand(" Select * from DWT.bob", oConn
oDA = New OracleDataAdapt er(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(GetT ype(OracleExcep tionInterfaces. BaseSimpleData_ DA), sURI), OracleException Interfaces.Base SimpleData_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.Ora cleClient.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.Ora cleClient.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 on CSAPI_V2 to scott;
When I attach to the database in C# using ODP.NET and attempt to
|
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
with it.
The problem is that we *Sometimes* get the ORA-24338 error when executing a
query.
This problem occurs random, sometimes twice a day, sometimes not at all. In
|
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 with it.
The problem is that we *Sometimes* get the ORA-24338 error when
executing a query. This problem occurs random, sometimes twice a day,
sometimes not at all. In the eventlog we get an exception like this
one (stacktrace):
|
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
Any ideas
22-Apr-2004 10:05:46---System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.Serialization.SerializationException: Member message was not found
at...
|
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 database component that uses ODP.NET from a BizTalk
2004 map. When this component throws a
System.Data.OracleClient.OracleException, I get this in the EventLog:
Failed while creating a NUSTestHarness.NUSTest service.
| | |
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
OracleConnection(ConfigurationSettings.AppSettings("connectionstring"))
Dim cmdsetdefineoff As New OracleCommand("SET DEFINE OFF", myconnection)
|
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 works as an app but not a
service. It actually finds the TSN listener but after that it breaks.
Please help, I'm going nuts here...
Chris
{System.Data.OracleClient.OracleException}
:
|
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:
Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not
resolve the connect identifier specified at
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32
errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx*
pOpoSqlValCtx, Object src,...
|
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 the client
side. The error comes from System.Exception class not from OracleException.
The properties of the Oracle.DataAccess reference are ;
Description: Oracle.DataAccess.dll
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
