Hi,
the Merge-Agent stops with this error:
Columname 'rowguidcol' is invalid executing this command
{call sp_MSmakearticleprocs (?, ?)}
What is the reason for the error ?
How can I solve the problem ?
Regards
Leandro
do any of the articles you are replicating contain a column called
rowguidcol?
"Leandro Etchezar" <paralea@.ciudad.com.ar> wrote in message
news:%237lRvi3PFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Hi,
> the Merge-Agent stops with this error:
> Columname 'rowguidcol' is invalid executing this command
> {call sp_MSmakearticleprocs (?, ?)}
> What is the reason for the error ?
> How can I solve the problem ?
> Regards
> Leandro
>
Showing posts with label stops. Show all posts
Showing posts with label stops. Show all posts
Wednesday, March 28, 2012
Merge deadlock
Hi, more or less once a day I receive this message from the merge
replication, because is continuous suddenly stops. I try to put an extra step
on the job to restart it but is ignored. Any clues why my step is ignored or
why this problem is happening?
cheers , Error:
The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
------
Transaction (Process ID 87) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.
(Source: SUMSTR (Data source); Error number: 1205)
------
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
------
If you have large numbers of subscribers you might want to limit concurrent
processing or perhaps schedule your merge agents as opposed to running them
simultaneously or continuously.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Salvador" <Salvador@.discussions.microsoft.com> wrote in message
news:BA09357D-8EE6-42A4-97C3-72384153AD02@.microsoft.com...
> Hi, more or less once a day I receive this message from the merge
> replication, because is continuous suddenly stops. I try to put an extra
step
> on the job to restart it but is ignored. Any clues why my step is ignored
or
> why this problem is happening?
> cheers , Error:
> The process could not enumerate changes at the 'Subscriber'.
> (Source: Merge Replication Provider (Agent); Error number: -2147200999)
> ----
--
> Transaction (Process ID 87) was deadlocked on lock resources with another
> process and has been chosen as the deadlock victim. Rerun the transaction.
> (Source: SUMSTR (Data source); Error number: 1205)
> ----
--
> The process was successfully stopped.
> (Source: Merge Replication Provider (Agent); Error number: -2147200999)
> ----
replication, because is continuous suddenly stops. I try to put an extra step
on the job to restart it but is ignored. Any clues why my step is ignored or
why this problem is happening?
cheers , Error:
The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
------
Transaction (Process ID 87) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.
(Source: SUMSTR (Data source); Error number: 1205)
------
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
------
If you have large numbers of subscribers you might want to limit concurrent
processing or perhaps schedule your merge agents as opposed to running them
simultaneously or continuously.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Salvador" <Salvador@.discussions.microsoft.com> wrote in message
news:BA09357D-8EE6-42A4-97C3-72384153AD02@.microsoft.com...
> Hi, more or less once a day I receive this message from the merge
> replication, because is continuous suddenly stops. I try to put an extra
step
> on the job to restart it but is ignored. Any clues why my step is ignored
or
> why this problem is happening?
> cheers , Error:
> The process could not enumerate changes at the 'Subscriber'.
> (Source: Merge Replication Provider (Agent); Error number: -2147200999)
> ----
--
> Transaction (Process ID 87) was deadlocked on lock resources with another
> process and has been chosen as the deadlock victim. Rerun the transaction.
> (Source: SUMSTR (Data source); Error number: 1205)
> ----
--
> The process was successfully stopped.
> (Source: Merge Replication Provider (Agent); Error number: -2147200999)
> ----
Monday, February 20, 2012
Memory Leaks
SQL server is experiencing Memory leaks. So much so that 2gb of ram
dissapears and the server stops.
THe server has 3 instances of SQL and most operations use linked servers
using oledb provider for oracle driver.
I have read some artavles that memory leaks can happen when the data type
long is returned using ref cursor.
The main queries used the syntax select * from openquery(linked
server,'oracle query') and are either select or update. Some cases sp's are
created with an input parameter and this input parameter is used to update a
single row and this sp is called severl times. Some articles i have read als
o
claim that memory leaks also happen when such a statement is repeatedly
executed.
Can anyone elaborate on this or give any suggestions as to the cause.
SQL 2000 SP3 on windows server 2000
MDAC is 2.7 SP1"mat" <mat@.discussions.microsoft.com> wrote in message
news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> SQL server is experiencing Memory leaks. So much so that 2gb of ram
> dissapears and the server stops.
> THe server has 3 instances of SQL and most operations use linked servers
> using oledb provider for oracle driver.
> I have read some artavles that memory leaks can happen when the data type
> long is returned using ref cursor.
> The main queries used the syntax select * from openquery(linked
> server,'oracle query') and are either select or update. Some cases sp's
> are
> created with an input parameter and this input parameter is used to update
> a
> single row and this sp is called severl times. Some articles i have read
> also
> claim that memory leaks also happen when such a statement is repeatedly
> executed.
> Can anyone elaborate on this or give any suggestions as to the cause.
> SQL 2000 SP3 on windows server 2000
> MDAC is 2.7 SP1
Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
provider. I would suggest that you use Oracles OLE-DB provider. It seems
to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
,Oracle 9i. I have not used with Oracle 10g.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Cheers..
i'm using Microsofts Provider.
I'll try it, but do you know what caused these problems
?
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
>
> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
> provider. I would suggest that you use Oracles OLE-DB provider. It seem
s
> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> ,Oracle 9i. I have not used with Oracle 10g.
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"mat" <mat@.discussions.microsoft.com> wrote in message
news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...[vbcol=seagreen]
> Cheers..
> i'm using Microsofts Provider.
> I'll try it, but do you know what caused these problems
> ?
> "Rick Sawtell" wrote:
>
I don't know what causes the problems, but we have had intermittent problems
using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
provider from MS had some issues here and there. Once we switched our .NET
to Oracle's .NET provider, the problems went away.
You may want to check out the Oracle metalink support site.
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks
Are there any conflicts between the Microsoft and aoracle providers.
I could not create a linked server using the oracle provider using
enterprise manger. I was gettint the errormessage
7302 coull not create an instance of ole db provider....
I Managed to create it on the server itself but when i try and view the
tables or execute a query from a remote machine i get the above error
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> I don't know what causes the problems, but we have had intermittent proble
ms
> using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
> provider from MS had some issues here and there. Once we switched our .NE
T
> to Oracle's .NET provider, the problems went away.
> You may want to check out the Oracle metalink support site.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
dissapears and the server stops.
THe server has 3 instances of SQL and most operations use linked servers
using oledb provider for oracle driver.
I have read some artavles that memory leaks can happen when the data type
long is returned using ref cursor.
The main queries used the syntax select * from openquery(linked
server,'oracle query') and are either select or update. Some cases sp's are
created with an input parameter and this input parameter is used to update a
single row and this sp is called severl times. Some articles i have read als
o
claim that memory leaks also happen when such a statement is repeatedly
executed.
Can anyone elaborate on this or give any suggestions as to the cause.
SQL 2000 SP3 on windows server 2000
MDAC is 2.7 SP1"mat" <mat@.discussions.microsoft.com> wrote in message
news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> SQL server is experiencing Memory leaks. So much so that 2gb of ram
> dissapears and the server stops.
> THe server has 3 instances of SQL and most operations use linked servers
> using oledb provider for oracle driver.
> I have read some artavles that memory leaks can happen when the data type
> long is returned using ref cursor.
> The main queries used the syntax select * from openquery(linked
> server,'oracle query') and are either select or update. Some cases sp's
> are
> created with an input parameter and this input parameter is used to update
> a
> single row and this sp is called severl times. Some articles i have read
> also
> claim that memory leaks also happen when such a statement is repeatedly
> executed.
> Can anyone elaborate on this or give any suggestions as to the cause.
> SQL 2000 SP3 on windows server 2000
> MDAC is 2.7 SP1
Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
provider. I would suggest that you use Oracles OLE-DB provider. It seems
to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
,Oracle 9i. I have not used with Oracle 10g.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Cheers..
i'm using Microsofts Provider.
I'll try it, but do you know what caused these problems
?
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
>
> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
> provider. I would suggest that you use Oracles OLE-DB provider. It seem
s
> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> ,Oracle 9i. I have not used with Oracle 10g.
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"mat" <mat@.discussions.microsoft.com> wrote in message
news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...[vbcol=seagreen]
> Cheers..
> i'm using Microsofts Provider.
> I'll try it, but do you know what caused these problems
> ?
> "Rick Sawtell" wrote:
>
I don't know what causes the problems, but we have had intermittent problems
using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
provider from MS had some issues here and there. Once we switched our .NET
to Oracle's .NET provider, the problems went away.
You may want to check out the Oracle metalink support site.
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks
Are there any conflicts between the Microsoft and aoracle providers.
I could not create a linked server using the oracle provider using
enterprise manger. I was gettint the errormessage
7302 coull not create an instance of ole db provider....
I Managed to create it on the server itself but when i try and view the
tables or execute a query from a remote machine i get the above error
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> I don't know what causes the problems, but we have had intermittent proble
ms
> using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
> provider from MS had some issues here and there. Once we switched our .NE
T
> to Oracle's .NET provider, the problems went away.
> You may want to check out the Oracle metalink support site.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Memory Leaks
SQL server is experiencing Memory leaks. So much so that 2gb of ram
dissapears and the server stops.
THe server has 3 instances of SQL and most operations use linked servers
using oledb provider for oracle driver.
I have read some artavles that memory leaks can happen when the data type
long is returned using ref cursor.
The main queries used the syntax select * from openquery(linked
server,'oracle query') and are either select or update. Some cases sp's are
created with an input parameter and this input parameter is used to update a
single row and this sp is called severl times. Some articles i have read also
claim that memory leaks also happen when such a statement is repeatedly
executed.
Can anyone elaborate on this or give any suggestions as to the cause.
SQL 2000 SP3 on windows server 2000
MDAC is 2.7 SP1"mat" <mat@.discussions.microsoft.com> wrote in message
news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> SQL server is experiencing Memory leaks. So much so that 2gb of ram
> dissapears and the server stops.
> THe server has 3 instances of SQL and most operations use linked servers
> using oledb provider for oracle driver.
> I have read some artavles that memory leaks can happen when the data type
> long is returned using ref cursor.
> The main queries used the syntax select * from openquery(linked
> server,'oracle query') and are either select or update. Some cases sp's
> are
> created with an input parameter and this input parameter is used to update
> a
> single row and this sp is called severl times. Some articles i have read
> also
> claim that memory leaks also happen when such a statement is repeatedly
> executed.
> Can anyone elaborate on this or give any suggestions as to the cause.
> SQL 2000 SP3 on windows server 2000
> MDAC is 2.7 SP1
Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
provider. I would suggest that you use Oracles OLE-DB provider. It seems
to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
,Oracle 9i. I have not used with Oracle 10g.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Cheers..
i'm using Microsofts Provider.
I'll try it, but do you know what caused these problems
?
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> > SQL server is experiencing Memory leaks. So much so that 2gb of ram
> > dissapears and the server stops.
> >
> > THe server has 3 instances of SQL and most operations use linked servers
> > using oledb provider for oracle driver.
> > I have read some artavles that memory leaks can happen when the data type
> > long is returned using ref cursor.
> > The main queries used the syntax select * from openquery(linked
> > server,'oracle query') and are either select or update. Some cases sp's
> > are
> > created with an input parameter and this input parameter is used to update
> > a
> > single row and this sp is called severl times. Some articles i have read
> > also
> > claim that memory leaks also happen when such a statement is repeatedly
> > executed.
> >
> > Can anyone elaborate on this or give any suggestions as to the cause.
> >
> > SQL 2000 SP3 on windows server 2000
> > MDAC is 2.7 SP1
>
> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
> provider. I would suggest that you use Oracles OLE-DB provider. It seems
> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> ,Oracle 9i. I have not used with Oracle 10g.
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"mat" <mat@.discussions.microsoft.com> wrote in message
news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> Cheers..
> i'm using Microsofts Provider.
> I'll try it, but do you know what caused these problems
> ?
> "Rick Sawtell" wrote:
>> "mat" <mat@.discussions.microsoft.com> wrote in message
>> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
>> > SQL server is experiencing Memory leaks. So much so that 2gb of ram
>> > dissapears and the server stops.
>> >
>> > THe server has 3 instances of SQL and most operations use linked
>> > servers
>> > using oledb provider for oracle driver.
>> > I have read some artavles that memory leaks can happen when the data
>> > type
>> > long is returned using ref cursor.
>> > The main queries used the syntax select * from openquery(linked
>> > server,'oracle query') and are either select or update. Some cases sp's
>> > are
>> > created with an input parameter and this input parameter is used to
>> > update
>> > a
>> > single row and this sp is called severl times. Some articles i have
>> > read
>> > also
>> > claim that memory leaks also happen when such a statement is repeatedly
>> > executed.
>> >
>> > Can anyone elaborate on this or give any suggestions as to the cause.
>> >
>> > SQL 2000 SP3 on windows server 2000
>> > MDAC is 2.7 SP1
>>
>> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's
>> OLE-DB
>> provider. I would suggest that you use Oracles OLE-DB provider. It
>> seems
>> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
>> ,Oracle 9i. I have not used with Oracle 10g.
>>
>> HTH
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
I don't know what causes the problems, but we have had intermittent problems
using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
provider from MS had some issues here and there. Once we switched our .NET
to Oracle's .NET provider, the problems went away.
You may want to check out the Oracle metalink support site.
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks
Are there any conflicts between the Microsoft and aoracle providers.
I could not create a linked server using the oracle provider using
enterprise manger. I was gettint the errormessage
7302 coull not create an instance of ole db provider....
I Managed to create it on the server itself but when i try and view the
tables or execute a query from a remote machine i get the above error
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> > Cheers..
> >
> > i'm using Microsofts Provider.
> >
> > I'll try it, but do you know what caused these problems
> > ?
> >
> > "Rick Sawtell" wrote:
> >
> >>
> >> "mat" <mat@.discussions.microsoft.com> wrote in message
> >> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> >> > SQL server is experiencing Memory leaks. So much so that 2gb of ram
> >> > dissapears and the server stops.
> >> >
> >> > THe server has 3 instances of SQL and most operations use linked
> >> > servers
> >> > using oledb provider for oracle driver.
> >> > I have read some artavles that memory leaks can happen when the data
> >> > type
> >> > long is returned using ref cursor.
> >> > The main queries used the syntax select * from openquery(linked
> >> > server,'oracle query') and are either select or update. Some cases sp's
> >> > are
> >> > created with an input parameter and this input parameter is used to
> >> > update
> >> > a
> >> > single row and this sp is called severl times. Some articles i have
> >> > read
> >> > also
> >> > claim that memory leaks also happen when such a statement is repeatedly
> >> > executed.
> >> >
> >> > Can anyone elaborate on this or give any suggestions as to the cause.
> >> >
> >> > SQL 2000 SP3 on windows server 2000
> >> > MDAC is 2.7 SP1
> >>
> >>
> >> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's
> >> OLE-DB
> >> provider. I would suggest that you use Oracles OLE-DB provider. It
> >> seems
> >> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> >> ,Oracle 9i. I have not used with Oracle 10g.
> >>
> >>
> >> HTH
> >>
> >> Rick Sawtell
> >> MCT, MCSD, MCDBA
> >>
> >>
> >>
> >>
> I don't know what causes the problems, but we have had intermittent problems
> using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
> provider from MS had some issues here and there. Once we switched our .NET
> to Oracle's .NET provider, the problems went away.
> You may want to check out the Oracle metalink support site.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
dissapears and the server stops.
THe server has 3 instances of SQL and most operations use linked servers
using oledb provider for oracle driver.
I have read some artavles that memory leaks can happen when the data type
long is returned using ref cursor.
The main queries used the syntax select * from openquery(linked
server,'oracle query') and are either select or update. Some cases sp's are
created with an input parameter and this input parameter is used to update a
single row and this sp is called severl times. Some articles i have read also
claim that memory leaks also happen when such a statement is repeatedly
executed.
Can anyone elaborate on this or give any suggestions as to the cause.
SQL 2000 SP3 on windows server 2000
MDAC is 2.7 SP1"mat" <mat@.discussions.microsoft.com> wrote in message
news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> SQL server is experiencing Memory leaks. So much so that 2gb of ram
> dissapears and the server stops.
> THe server has 3 instances of SQL and most operations use linked servers
> using oledb provider for oracle driver.
> I have read some artavles that memory leaks can happen when the data type
> long is returned using ref cursor.
> The main queries used the syntax select * from openquery(linked
> server,'oracle query') and are either select or update. Some cases sp's
> are
> created with an input parameter and this input parameter is used to update
> a
> single row and this sp is called severl times. Some articles i have read
> also
> claim that memory leaks also happen when such a statement is repeatedly
> executed.
> Can anyone elaborate on this or give any suggestions as to the cause.
> SQL 2000 SP3 on windows server 2000
> MDAC is 2.7 SP1
Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
provider. I would suggest that you use Oracles OLE-DB provider. It seems
to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
,Oracle 9i. I have not used with Oracle 10g.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Cheers..
i'm using Microsofts Provider.
I'll try it, but do you know what caused these problems
?
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> > SQL server is experiencing Memory leaks. So much so that 2gb of ram
> > dissapears and the server stops.
> >
> > THe server has 3 instances of SQL and most operations use linked servers
> > using oledb provider for oracle driver.
> > I have read some artavles that memory leaks can happen when the data type
> > long is returned using ref cursor.
> > The main queries used the syntax select * from openquery(linked
> > server,'oracle query') and are either select or update. Some cases sp's
> > are
> > created with an input parameter and this input parameter is used to update
> > a
> > single row and this sp is called severl times. Some articles i have read
> > also
> > claim that memory leaks also happen when such a statement is repeatedly
> > executed.
> >
> > Can anyone elaborate on this or give any suggestions as to the cause.
> >
> > SQL 2000 SP3 on windows server 2000
> > MDAC is 2.7 SP1
>
> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
> provider. I would suggest that you use Oracles OLE-DB provider. It seems
> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> ,Oracle 9i. I have not used with Oracle 10g.
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"mat" <mat@.discussions.microsoft.com> wrote in message
news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> Cheers..
> i'm using Microsofts Provider.
> I'll try it, but do you know what caused these problems
> ?
> "Rick Sawtell" wrote:
>> "mat" <mat@.discussions.microsoft.com> wrote in message
>> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
>> > SQL server is experiencing Memory leaks. So much so that 2gb of ram
>> > dissapears and the server stops.
>> >
>> > THe server has 3 instances of SQL and most operations use linked
>> > servers
>> > using oledb provider for oracle driver.
>> > I have read some artavles that memory leaks can happen when the data
>> > type
>> > long is returned using ref cursor.
>> > The main queries used the syntax select * from openquery(linked
>> > server,'oracle query') and are either select or update. Some cases sp's
>> > are
>> > created with an input parameter and this input parameter is used to
>> > update
>> > a
>> > single row and this sp is called severl times. Some articles i have
>> > read
>> > also
>> > claim that memory leaks also happen when such a statement is repeatedly
>> > executed.
>> >
>> > Can anyone elaborate on this or give any suggestions as to the cause.
>> >
>> > SQL 2000 SP3 on windows server 2000
>> > MDAC is 2.7 SP1
>>
>> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's
>> OLE-DB
>> provider. I would suggest that you use Oracles OLE-DB provider. It
>> seems
>> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
>> ,Oracle 9i. I have not used with Oracle 10g.
>>
>> HTH
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
I don't know what causes the problems, but we have had intermittent problems
using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
provider from MS had some issues here and there. Once we switched our .NET
to Oracle's .NET provider, the problems went away.
You may want to check out the Oracle metalink support site.
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks
Are there any conflicts between the Microsoft and aoracle providers.
I could not create a linked server using the oracle provider using
enterprise manger. I was gettint the errormessage
7302 coull not create an instance of ole db provider....
I Managed to create it on the server itself but when i try and view the
tables or execute a query from a remote machine i get the above error
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> > Cheers..
> >
> > i'm using Microsofts Provider.
> >
> > I'll try it, but do you know what caused these problems
> > ?
> >
> > "Rick Sawtell" wrote:
> >
> >>
> >> "mat" <mat@.discussions.microsoft.com> wrote in message
> >> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> >> > SQL server is experiencing Memory leaks. So much so that 2gb of ram
> >> > dissapears and the server stops.
> >> >
> >> > THe server has 3 instances of SQL and most operations use linked
> >> > servers
> >> > using oledb provider for oracle driver.
> >> > I have read some artavles that memory leaks can happen when the data
> >> > type
> >> > long is returned using ref cursor.
> >> > The main queries used the syntax select * from openquery(linked
> >> > server,'oracle query') and are either select or update. Some cases sp's
> >> > are
> >> > created with an input parameter and this input parameter is used to
> >> > update
> >> > a
> >> > single row and this sp is called severl times. Some articles i have
> >> > read
> >> > also
> >> > claim that memory leaks also happen when such a statement is repeatedly
> >> > executed.
> >> >
> >> > Can anyone elaborate on this or give any suggestions as to the cause.
> >> >
> >> > SQL 2000 SP3 on windows server 2000
> >> > MDAC is 2.7 SP1
> >>
> >>
> >> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's
> >> OLE-DB
> >> provider. I would suggest that you use Oracles OLE-DB provider. It
> >> seems
> >> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> >> ,Oracle 9i. I have not used with Oracle 10g.
> >>
> >>
> >> HTH
> >>
> >> Rick Sawtell
> >> MCT, MCSD, MCDBA
> >>
> >>
> >>
> >>
> I don't know what causes the problems, but we have had intermittent problems
> using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
> provider from MS had some issues here and there. Once we switched our .NET
> to Oracle's .NET provider, the problems went away.
> You may want to check out the Oracle metalink support site.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Memory Leaks
SQL server is experiencing Memory leaks. So much so that 2gb of ram
dissapears and the server stops.
THe server has 3 instances of SQL and most operations use linked servers
using oledb provider for oracle driver.
I have read some artavles that memory leaks can happen when the data type
long is returned using ref cursor.
The main queries used the syntax select * from openquery(linked
server,'oracle query') and are either select or update. Some cases sp's are
created with an input parameter and this input parameter is used to update a
single row and this sp is called severl times. Some articles i have read also
claim that memory leaks also happen when such a statement is repeatedly
executed.
Can anyone elaborate on this or give any suggestions as to the cause.
SQL 2000 SP3 on windows server 2000
MDAC is 2.7 SP1
"mat" <mat@.discussions.microsoft.com> wrote in message
news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> SQL server is experiencing Memory leaks. So much so that 2gb of ram
> dissapears and the server stops.
> THe server has 3 instances of SQL and most operations use linked servers
> using oledb provider for oracle driver.
> I have read some artavles that memory leaks can happen when the data type
> long is returned using ref cursor.
> The main queries used the syntax select * from openquery(linked
> server,'oracle query') and are either select or update. Some cases sp's
> are
> created with an input parameter and this input parameter is used to update
> a
> single row and this sp is called severl times. Some articles i have read
> also
> claim that memory leaks also happen when such a statement is repeatedly
> executed.
> Can anyone elaborate on this or give any suggestions as to the cause.
> SQL 2000 SP3 on windows server 2000
> MDAC is 2.7 SP1
Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
provider. I would suggest that you use Oracles OLE-DB provider. It seems
to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
,Oracle 9i. I have not used with Oracle 10g.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||Cheers..
i'm using Microsofts Provider.
I'll try it, but do you know what caused these problems
?
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
>
> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
> provider. I would suggest that you use Oracles OLE-DB provider. It seems
> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> ,Oracle 9i. I have not used with Oracle 10g.
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||"mat" <mat@.discussions.microsoft.com> wrote in message
news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...[vbcol=seagreen]
> Cheers..
> i'm using Microsofts Provider.
> I'll try it, but do you know what caused these problems
> ?
> "Rick Sawtell" wrote:
I don't know what causes the problems, but we have had intermittent problems
using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
provider from MS had some issues here and there. Once we switched our .NET
to Oracle's .NET provider, the problems went away.
You may want to check out the Oracle metalink support site.
Rick Sawtell
MCT, MCSD, MCDBA
|||Thanks
Are there any conflicts between the Microsoft and aoracle providers.
I could not create a linked server using the oracle provider using
enterprise manger. I was gettint the errormessage
7302 coull not create an instance of ole db provider....
I Managed to create it on the server itself but when i try and view the
tables or execute a query from a remote machine i get the above error
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> I don't know what causes the problems, but we have had intermittent problems
> using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
> provider from MS had some issues here and there. Once we switched our .NET
> to Oracle's .NET provider, the problems went away.
> You may want to check out the Oracle metalink support site.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
dissapears and the server stops.
THe server has 3 instances of SQL and most operations use linked servers
using oledb provider for oracle driver.
I have read some artavles that memory leaks can happen when the data type
long is returned using ref cursor.
The main queries used the syntax select * from openquery(linked
server,'oracle query') and are either select or update. Some cases sp's are
created with an input parameter and this input parameter is used to update a
single row and this sp is called severl times. Some articles i have read also
claim that memory leaks also happen when such a statement is repeatedly
executed.
Can anyone elaborate on this or give any suggestions as to the cause.
SQL 2000 SP3 on windows server 2000
MDAC is 2.7 SP1
"mat" <mat@.discussions.microsoft.com> wrote in message
news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
> SQL server is experiencing Memory leaks. So much so that 2gb of ram
> dissapears and the server stops.
> THe server has 3 instances of SQL and most operations use linked servers
> using oledb provider for oracle driver.
> I have read some artavles that memory leaks can happen when the data type
> long is returned using ref cursor.
> The main queries used the syntax select * from openquery(linked
> server,'oracle query') and are either select or update. Some cases sp's
> are
> created with an input parameter and this input parameter is used to update
> a
> single row and this sp is called severl times. Some articles i have read
> also
> claim that memory leaks also happen when such a statement is repeatedly
> executed.
> Can anyone elaborate on this or give any suggestions as to the cause.
> SQL 2000 SP3 on windows server 2000
> MDAC is 2.7 SP1
Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
provider. I would suggest that you use Oracles OLE-DB provider. It seems
to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
,Oracle 9i. I have not used with Oracle 10g.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||Cheers..
i'm using Microsofts Provider.
I'll try it, but do you know what caused these problems
?
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:6601DAC1-672B-4B9B-B32D-F2EC4BEA4A18@.microsoft.com...
>
> Are you using the Microsoft OLE-DB provider for Oracle, or Oracle's OLE-DB
> provider. I would suggest that you use Oracles OLE-DB provider. It seems
> to work better for me. Notes: This was SQL 2k, Oracle 8i and SQL2k
> ,Oracle 9i. I have not used with Oracle 10g.
>
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||"mat" <mat@.discussions.microsoft.com> wrote in message
news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...[vbcol=seagreen]
> Cheers..
> i'm using Microsofts Provider.
> I'll try it, but do you know what caused these problems
> ?
> "Rick Sawtell" wrote:
I don't know what causes the problems, but we have had intermittent problems
using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
provider from MS had some issues here and there. Once we switched our .NET
to Oracle's .NET provider, the problems went away.
You may want to check out the Oracle metalink support site.
Rick Sawtell
MCT, MCSD, MCDBA
|||Thanks
Are there any conflicts between the Microsoft and aoracle providers.
I could not create a linked server using the oracle provider using
enterprise manger. I was gettint the errormessage
7302 coull not create an instance of ole db provider....
I Managed to create it on the server itself but when i try and view the
tables or execute a query from a remote machine i get the above error
"Rick Sawtell" wrote:
> "mat" <mat@.discussions.microsoft.com> wrote in message
> news:B3D168E8-0B3E-427C-9E8F-5580B56A39AE@.microsoft.com...
> I don't know what causes the problems, but we have had intermittent problems
> using the Microsoft drivers for Oracle in the past. Even the new ADO.NET
> provider from MS had some issues here and there. Once we switched our .NET
> to Oracle's .NET provider, the problems went away.
> You may want to check out the Oracle metalink support site.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Subscribe to:
Comments (Atom)