Tuesday, March 27, 2012
Error 845 running backup of one database
waiting for buffer latch type 3 for page (0:0), database ID 15, object ID
569352192, Index ID 0..
This only started happening last week. The database has not changed (other
than normal data entry) in over a year. Does anyone have any ideas of what
should be checked?
Thanks in advanceDid you see the specific recommendations in Books Online for this?
Error 845
Severity Level 17
Message Text
Time-out occurred while waiting for buffer latch type %d for page %S_PGID, d
atabase ID %d.
Explanation
When under a heavy stress load or high I/O conditions, your system may produ
ce this message.
Action
This message can usually be ignored; however, if you receive repeated messag
es where the wait time
increases, it may indicate an internal server problem. Contact your system a
dministrator. The system
administrator should check the waittype, waittime, lastwaittype, and the wai
tresource columns of
sysprocesses to see what activities each SPIDs is performing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Connie" <cfelt@.ga.wa.gov> wrote in message news:OcwIz0TWEHA.1144@.TK2MSFTNGP10.phx.gbl...[vb
col=seagreen]
> I have one database that I keep getting an error 845: Time out ocurred whi
le
> waiting for buffer latch type 3 for page (0:0), database ID 15, object ID
> 569352192, Index ID 0..
> This only started happening last week. The database has not changed (othe
r
> than normal data entry) in over a year. Does anyone have any ideas of wha
t
> should be checked?
> Thanks in advance
>[/vbcol]
Monday, March 26, 2012
Error 845 running backup of one database
waiting for buffer latch type 3 for page (0:0), database ID 15, object ID
569352192, Index ID 0..
This only started happening last week. The database has not changed (other
than normal data entry) in over a year. Does anyone have any ideas of what
should be checked?
Thanks in advance
Did you see the specific recommendations in Books Online for this?
Error 845
Severity Level 17
Message Text
Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.
Explanation
When under a heavy stress load or high I/O conditions, your system may produce this message.
Action
This message can usually be ignored; however, if you receive repeated messages where the wait time
increases, it may indicate an internal server problem. Contact your system administrator. The system
administrator should check the waittype, waittime, lastwaittype, and the waitresource columns of
sysprocesses to see what activities each SPIDs is performing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Connie" <cfelt@.ga.wa.gov> wrote in message news:OcwIz0TWEHA.1144@.TK2MSFTNGP10.phx.gbl...
> I have one database that I keep getting an error 845: Time out ocurred while
> waiting for buffer latch type 3 for page (0:0), database ID 15, object ID
> 569352192, Index ID 0..
> This only started happening last week. The database has not changed (other
> than normal data entry) in over a year. Does anyone have any ideas of what
> should be checked?
> Thanks in advance
>
sql
Error 845 running backup of one database
waiting for buffer latch type 3 for page (0:0), database ID 15, object ID
569352192, Index ID 0..
This only started happening last week. The database has not changed (other
than normal data entry) in over a year. Does anyone have any ideas of what
should be checked?
Thanks in advanceDid you see the specific recommendations in Books Online for this?
Error 845
Severity Level 17
Message Text
Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.
Explanation
When under a heavy stress load or high I/O conditions, your system may produce this message.
Action
This message can usually be ignored; however, if you receive repeated messages where the wait time
increases, it may indicate an internal server problem. Contact your system administrator. The system
administrator should check the waittype, waittime, lastwaittype, and the waitresource columns of
sysprocesses to see what activities each SPIDs is performing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Connie" <cfelt@.ga.wa.gov> wrote in message news:OcwIz0TWEHA.1144@.TK2MSFTNGP10.phx.gbl...
> I have one database that I keep getting an error 845: Time out ocurred while
> waiting for buffer latch type 3 for page (0:0), database ID 15, object ID
> 569352192, Index ID 0..
> This only started happening last week. The database has not changed (other
> than normal data entry) in over a year. Does anyone have any ideas of what
> should be checked?
> Thanks in advance
>
Thursday, March 22, 2012
Error 8144 creating transactional publication
I am trying to upgrade my SQL Server from a NT4+SQL7 to Win2K+SQL2000.
Here are the steps:
Install/Work order on "virgin" double Xeon server:
1) Win2K Server
2) SP3 for Win2K
3) SQL Server 7.0
4) SP3 for SQL Server 7.0
5) Restore full backup of master database.
6) Restore full backups of 10 databases (one named Q5)
7) Installed SQL Server 2000 Upgrade
8) SP3 for SQL Server 2000
At this point I tested my apps with the several databases and all looked good. But now I need to create a transactional publication on the Q5 database named Q5Pub.
First I go with the wizard but when he gets to the point where he is "Creating the Publication" he offers me the following:
SQL Server Enterprise Manager could not create publication 'Q5Pub' from database 'Q5'.
Error 8144: Procedure or function sp_MSadd_publication has too many arguments specified.
I then try using the Query Analyzer with the following statement:
exec sp_addpublication @.publication = N'Q5Pub', @.restricted = N'false', @.sync_method = N'native', @.repl_freq = N'continuous', @.description = N'Transactional publication of Q5 database from Publisher SQLSERVER.', @.status = N'active', @.allow_push = N'true', @.allow_pull = N'true', @.allow_anonymous = N'true', @.enabled_for_internet = N'false', @.independent_agent = N'true', @.immediate_sync = N'true', @.allow_sync_tran = N'false', @.autogen_sync_procs = N'false', @.retention = 72
This gives me:
Server: Msg 8144, Level 16, State 2, Procedure sp_MSadd_publication, Line 0
Procedure or function sp_MSadd_publication has too many arguments specified.
Job 'SQLSERVER-Q5-23' started successfully.
So I look at the sp_addpublication stored procedure in the master database where I find:
...
/*
** Add the publication to the distributor side
*/
SELECT @.distproc = RTRIM(@.distributor) + '.' + @.distribdb +
'.dbo.sp_MSadd_publication'
EXECUTE @.retcode = @.distproc
@.publisher = @.@.SERVERNAME,
@.publisher_db = @.dbname,
@.publication = @.publication,
@.publication_type = @.rfid,
@.independent_agent = @.independent_agent_id,
@.immediate_sync = @.immediate_sync_id,
@.allow_push = @.allow_push_id,
@.allow_pull = @.allow_pull_id,
@.allow_anonymous = @.allow_anonymous_id,
@.snapshot_agent = @.null,
@.logreader_agent = @.agentname,
@.description = @.description,
@.retention = @.retention,
@.sync_method = @.smid,
@.allow_subscription_copy = @.allow_subscription_copy_id,
@.allow_queued_tran = @.allow_queued_tran_id,
@.queue_type = @.queue_type_val
...
But looking at the sp_MSadd_publication stored procedure in the distribution database I see:
CREATE PROCEDURE sp_MSadd_publication
@.publisher sysname,
@.publisher_db sysname,
@.publication sysname,
@.publication_id int = 0, -- BUG REMOVE
@.publication_type int = 1, -- 0 = Transactional 1 = Snapshot 2 = Merge
@.independent_agent bit = 0,
@.immediate_sync bit = 0,
@.allow_push bit = 1,
@.allow_pull bit = 0,
@.allow_anonymous bit = 0,
@.snapshot_agent nvarchar(100) = NULL,
@.logreader_agent nvarchar (100) = NULL,
@.description nvarchar(255) = NULL,
@.retention int =60,
@.vendor_name nvarchar(100) = 'Microsoft SQL Server'
as
...
So indeed the sp_addpublication calls the sp_MSadd_publication with too many arguments.
@.sync_method, @.allow_subscription_copy, @.allow_queued_tran and @.queue_type
What am I doing wrong?
Many thanks for any suggestion or/and help on this matter.Refer to this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328908).sql
Error 8102: Cannot Update Identity Column
I'd set up Transactional Replication btw 2 servers running on MSSQL 2000.
However, from time to time, I encounter Error 8102. I try to reinitialise the subscription but failed. After I delete the current subscription and PUSH a new one, it will works fine again.
I'm curious why this is happening as I'd already set all the tables (articles) in the subscriber to "YES, not_for_replication".
Any idea?
Thanks.Originally posted by da_i256
Hi,
I'd set up Transactional Replication btw 2 servers running on MSSQL 2000.
However, from time to time, I encounter Error 8102. I try to reinitialise the subscription but failed. After I delete the current subscription and PUSH a new one, it will works fine again.
I'm curious why this is happening as I'd already set all the tables (articles) in the subscriber to "YES, not_for_replication".
Any idea?
Thanks.
check this thread:
http://dbforums.com/arch/7/2003/5/779346|||thanks, harshal_in...
then link did provide some insights into the matter.
anyone else got any idea?
thanks.|||Have you gone thru the MSDN link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01d4.asp) referred in the above post, it must have resolved with the workaround mentioned.|||Thanks guys...
the problem solved... :>sql
Sunday, March 11, 2012
Error 53
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection open(CreateFile()).
Connection failed:
SQLState:'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
When a user tries to connect, are they to use my IP address, my computer name, my SQL Server Group name? I think I've tried all ways, but they can't connect (myself included).
</scratching head>
tia,
JMorrell
Could be an error with authentication. Make sure that they are using named
pipes protocol and are authenticated to your PC with an ID that has
permissions for SQL server. Try having them map a drive first with this ID.
"JMorrell" wrote:
> I have SQL Server 8 running locally on my networked XP pc. I would like to have users connect to the database there through the network. Each time they try to connect, the following error occures:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection open(CreateFile()).
> Connection failed:
> SQLState:'08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
> When a user tries to connect, are they to use my IP address, my computer name, my SQL Server Group name? I think I've tried all ways, but they can't connect (myself included).
> </scratching head>
> tia,
> --
> JMorrell
Error 53
have users connect to the database there through the network. Each time the
y try to connect, the following error occures:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection open(
CreateFile()).
Connection failed:
SQLState:'08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server do
es not exist or access denied.
When a user tries to connect, are they to use my IP address, my computer nam
e, my SQL Server Group name? I think I've tried all ways, but they can't co
nnect (myself included).
</scratching head>
tia,
--
JMorrellCould be an error with authentication. Make sure that they are using named
pipes protocol and are authenticated to your PC with an ID that has
permissions for SQL server. Try having them map a drive first with this ID.
"JMorrell" wrote:
> I have SQL Server 8 running locally on my networked XP pc. I would like t
o have users connect to the database there through the network. Each time t
hey try to connect, the following error occures:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection ope
n(CreateFile()).
> Connection failed:
> SQLState:'08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not exist or access denied.
> When a user tries to connect, are they to use my IP address, my computer n
ame, my SQL Server Group name? I think I've tried all ways, but they can't
connect (myself included).
> </scratching head>
> tia,
> --
> JMorrell
Wednesday, March 7, 2012
Error 3724 : cannot drop table ...becuase it is published for ....
I have a database that running on SQL Server 7 and it has been published for
replication for a period of time. After that period i remove the publication
and still the database running correctly without any problem.Then a change in
requirments happend, as a result i need to drop one table form the database.
When i tryed to drop the table an error show up says: "Error 3724: cannot
drop table "..." becuase it is published for replication
Paul,
I try this sp in SQL server 2000 that connect remotely with the database
running in sql server 7. Unfortunately SQLServer2000 could not find this sp
"Paul Ibison" wrote:
> Ayman,
> there is a stored procedure to do this called
> sp_MSunmarkreplinfo which takes a tablename as a
> parameter. Alternatively, setting replinfo to 0 in
> sysobjects for the particular table should do it.
> Finally, running sp_removedbreplication can be used to
> remove all traces of replication in the subscriber
> database.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||OK - I don't have a SQl Server 7.0 box here, but this
sounds feasible. In that case try one of the
alternatives - direct edit of the system table or
sp_removedbreplication with caveats mentioned before.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Error 3716 - security settings
it...
adErrUnsafeOperation 3716 - "Safety settings on this computer prohibit
accessing a data source on another domain."
I'm calling a stored procedure in an enterprise environment, returning a
single recordset, with ADO (not ADO.NET).
I've done a trace, the stored procedure does run, but it only errors in the
customers environment. I can't replicate.
If anyone can tell me what this error is, I can probably find the problem
much sooner.Random (cipherlad@.hotmail.com) writes:
> My first time encountering this error, and I can't find any
> documentation on it...
> adErrUnsafeOperation 3716 - "Safety settings on this computer prohibit
> accessing a data source on another domain."
> I'm calling a stored procedure in an enterprise environment, returning a
> single recordset, with ADO (not ADO.NET).
> I've done a trace, the stored procedure does run, but it only errors in
> the customers environment. I can't replicate.
> If anyone can tell me what this error is, I can probably find the problem
> much sooner.
You are probably better off asking about this in a forum devoted to ADO
ASP, or maybe Windows networking, as this does not really seem to tbe an SQL
Server issue. I searched for the error message on Google, and I got some
hits. I only pursued the first one, and did seem to give some information.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Error 3627 (Could not create worker thread) - Transaction Log Back
of SQL Server.
We have anout 1500 connections at a time. There are no SQL Error log entries
other than the Transaction Log failing, no Application Events or System
Events.
The server did not go down, the CPUs (8) went to almost zero.
SQL Server Enterprise Manager was getting a network error message when
trying to connect and within 5 minutes everything was OK.
Any help?
Thanks,
ThomasLL
Could it be that you were over your max worker threads?
http://msdn2.microsoft.com/en-us/library/ms187024.aspx
When all worker threads are active with long running queries, SQL Server may
appear unresponsive until a worker thread completes and becomes available.
Though not a defect, this can sometimes be undesirable. If a process appears
to be unresponsive and no new queries can be processed, then connect to SQL
Server using the dedicated administrator connection (DAC), and kill the
process. To prevent this, increase the number of max worker threads.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:759C0C8D-1413-45CB-BE38-743CF952CBF5@.microsoft.com...
> Recieved this error this morning, at the same time are users were kicked
> out
> of SQL Server.
> We have anout 1500 connections at a time. There are no SQL Error log
> entries
> other than the Transaction Log failing, no Application Events or System
> Events.
> The server did not go down, the CPUs (8) went to almost zero.
> SQL Server Enterprise Manager was getting a network error message when
> trying to connect and within 5 minutes everything was OK.
> Any help?
> Thanks,
> ThomasLL
|||Are you using any third party backup software?
You can also get this error if you are running low on system
resources - mostly memory.
You may have too much of a server load at the time you tried
to do the backup. You'd want to get some baselines numbers
using Performance Monitor.
-Sue
On Mon, 9 Oct 2006 09:54:02 -0700, Thomas.LeBlanc@.NoSpam.Com
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote:
>Recieved this error this morning, at the same time are users were kicked out
>of SQL Server.
>We have anout 1500 connections at a time. There are no SQL Error log entries
>other than the Transaction Log failing, no Application Events or System
>Events.
>The server did not go down, the CPUs (8) went to almost zero.
>SQL Server Enterprise Manager was getting a network error message when
>trying to connect and within 5 minutes everything was OK.
>Any help?
>Thanks,
>ThomasLL
|||Thanks everyone!!!
Thanks,
ThomasLL, MCDBA
"Thomas.LeBlanc@.NoSpam.Com" wrote:
> Recieved this error this morning, at the same time are users were kicked out
> of SQL Server.
> We have anout 1500 connections at a time. There are no SQL Error log entries
> other than the Transaction Log failing, no Application Events or System
> Events.
> The server did not go down, the CPUs (8) went to almost zero.
> SQL Server Enterprise Manager was getting a network error message when
> trying to connect and within 5 minutes everything was OK.
> Any help?
> Thanks,
> ThomasLL
Error 3627 (Could not create worker thread) - Transaction Log Back
of SQL Server.
We have anout 1500 connections at a time. There are no SQL Error log entries
other than the Transaction Log failing, no Application Events or System
Events.
The server did not go down, the CPUs (8) went to almost zero.
SQL Server Enterprise Manager was getting a network error message when
trying to connect and within 5 minutes everything was OK.
Any help?
Thanks,
ThomasLLCould it be that you were over your max worker threads?
http://msdn2.microsoft.com/en-us/library/ms187024.aspx
When all worker threads are active with long running queries, SQL Server may
appear unresponsive until a worker thread completes and becomes available.
Though not a defect, this can sometimes be undesirable. If a process appears
to be unresponsive and no new queries can be processed, then connect to SQL
Server using the dedicated administrator connection (DAC), and kill the
process. To prevent this, increase the number of max worker threads.
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:759C0C8D-1413-45CB-BE38-743CF952CBF5@.microsoft.com...
> Recieved this error this morning, at the same time are users were kicked
> out
> of SQL Server.
> We have anout 1500 connections at a time. There are no SQL Error log
> entries
> other than the Transaction Log failing, no Application Events or System
> Events.
> The server did not go down, the CPUs (8) went to almost zero.
> SQL Server Enterprise Manager was getting a network error message when
> trying to connect and within 5 minutes everything was OK.
> Any help?
> Thanks,
> ThomasLL|||Are you using any third party backup software?
You can also get this error if you are running low on system
resources - mostly memory.
You may have too much of a server load at the time you tried
to do the backup. You'd want to get some baselines numbers
using Performance Monitor.
-Sue
On Mon, 9 Oct 2006 09:54:02 -0700, Thomas.LeBlanc@.NoSpam.Com
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote:
>Recieved this error this morning, at the same time are users were kicked out
>of SQL Server.
>We have anout 1500 connections at a time. There are no SQL Error log entries
>other than the Transaction Log failing, no Application Events or System
>Events.
>The server did not go down, the CPUs (8) went to almost zero.
>SQL Server Enterprise Manager was getting a network error message when
>trying to connect and within 5 minutes everything was OK.
>Any help?
>Thanks,
>ThomasLL|||We are on SQL Server 2000, no error message that we have exceeded Work Threads.
We do have 8 processors and 64 Gigs, neither are maxed out.
Thanks for your responce.
Most sites I have read say you should NOT increase worker threads because of
overhead with more threads.
Cache Hit Ratio 101.05824
Cache Flushes 0.0
Free Page Scan (Avg) 0.0
Free Page Scan (Max) 0.0
Min Free Buffers 331.0
Cache Size 4362.0
Free Buffers 2261.0
--
Thanks,
ThomasLL
"Warren Brunk" wrote:
> Could it be that you were over your max worker threads?
> http://msdn2.microsoft.com/en-us/library/ms187024.aspx
> When all worker threads are active with long running queries, SQL Server may
> appear unresponsive until a worker thread completes and becomes available.
> Though not a defect, this can sometimes be undesirable. If a process appears
> to be unresponsive and no new queries can be processed, then connect to SQL
> Server using the dedicated administrator connection (DAC), and kill the
> process. To prevent this, increase the number of max worker threads.
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Thomas.LeBlanc@.NoSpam.Com"
> <ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
> news:759C0C8D-1413-45CB-BE38-743CF952CBF5@.microsoft.com...
> > Recieved this error this morning, at the same time are users were kicked
> > out
> > of SQL Server.
> >
> > We have anout 1500 connections at a time. There are no SQL Error log
> > entries
> > other than the Transaction Log failing, no Application Events or System
> > Events.
> >
> > The server did not go down, the CPUs (8) went to almost zero.
> >
> > SQL Server Enterprise Manager was getting a network error message when
> > trying to connect and within 5 minutes everything was OK.
> >
> > Any help?
> >
> > Thanks,
> > ThomasLL
>
>|||> Are you using any third party backup software?
No
We are on SQL Server 2000, no error message that we have exceeded Work
Threads.
We do have 8 processors and 64 Gigs, neither are maxed out.
Thanks for your responce.
Most sites I have read say you should NOT increase worker threads because of
overhead with more threads.
Cache Hit Ratio 101.05824
Cache Flushes 0.0
Free Page Scan (Avg) 0.0
Free Page Scan (Max) 0.0
Min Free Buffers 331.0
Cache Size 4362.0
Free Buffers 2261.0
--
Thanks,
ThomasLL
--
Thanks,
ThomasLL,
"Sue Hoegemeier" wrote:
> Are you using any third party backup software?
> You can also get this error if you are running low on system
> resources - mostly memory.
> You may have too much of a server load at the time you tried
> to do the backup. You'd want to get some baselines numbers
> using Performance Monitor.
> -Sue
> On Mon, 9 Oct 2006 09:54:02 -0700, Thomas.LeBlanc@.NoSpam.Com
> <ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote:
> >Recieved this error this morning, at the same time are users were kicked out
> >of SQL Server.
> >
> >We have anout 1500 connections at a time. There are no SQL Error log entries
> >other than the Transaction Log failing, no Application Events or System
> >Events.
> >
> >The server did not go down, the CPUs (8) went to almost zero.
> >
> >SQL Server Enterprise Manager was getting a network error message when
> >trying to connect and within 5 minutes everything was OK.
> >
> >Any help?
> >
> >Thanks,
> >ThomasLL
>|||You are correct about the worker threads which is why I
didn't suggest changing that setting. On SQL 2000, you will
almost always have problems if you increase the value from
the default 255. It is not advisable and you would want to
be monitoring UMS stats as well as other indicators before
even considering changing that.
But...most of the time the error you received is really due
to resource constraints. A one time snapshot of a few
performance metrics isn't going to tell you much. The
article on sql-server-performance.com for performance audits
provides some good information on what you want to check:
http://www.sql-server-performance.com/sql_server_performance_audit.asp
-Sue
On Mon, 9 Oct 2006 13:32:01 -0700, Thomas.LeBlanc@.NoSpam.Com
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote:
>> Are you using any third party backup software?
>No
>We are on SQL Server 2000, no error message that we have exceeded Work
>Threads.
>We do have 8 processors and 64 Gigs, neither are maxed out.
>Thanks for your responce.
>Most sites I have read say you should NOT increase worker threads because of
>overhead with more threads.
>Cache Hit Ratio 101.05824
>Cache Flushes 0.0
>Free Page Scan (Avg) 0.0
>Free Page Scan (Max) 0.0
>Min Free Buffers 331.0
>Cache Size 4362.0
>Free Buffers 2261.0
>--
>Thanks,
>ThomasLL|||Thanks everyone!!!
--
Thanks,
ThomasLL, MCDBA
"Thomas.LeBlanc@.NoSpam.Com" wrote:
> Recieved this error this morning, at the same time are users were kicked out
> of SQL Server.
> We have anout 1500 connections at a time. There are no SQL Error log entries
> other than the Transaction Log failing, no Application Events or System
> Events.
> The server did not go down, the CPUs (8) went to almost zero.
> SQL Server Enterprise Manager was getting a network error message when
> trying to connect and within 5 minutes everything was OK.
> Any help?
> Thanks,
> ThomasLL
Error 3627 (Could not create worker thread) - Transaction Log Back
of SQL Server.
We have anout 1500 connections at a time. There are no SQL Error log entries
other than the Transaction Log failing, no Application Events or System
Events.
The server did not go down, the CPUs (8) went to almost zero.
SQL Server Enterprise Manager was getting a network error message when
trying to connect and within 5 minutes everything was OK.
Any help?
Thanks,
ThomasLLCould it be that you were over your max worker threads?
http://msdn2.microsoft.com/en-us/library/ms187024.aspx
When all worker threads are active with long running queries, SQL Server may
appear unresponsive until a worker thread completes and becomes available.
Though not a defect, this can sometimes be undesirable. If a process appears
to be unresponsive and no new queries can be processed, then connect to SQL
Server using the dedicated administrator connection (DAC), and kill the
process. To prevent this, increase the number of max worker threads.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:759C0C8D-1413-45CB-BE38-743CF952CBF5@.microsoft.com...
> Recieved this error this morning, at the same time are users were kicked
> out
> of SQL Server.
> We have anout 1500 connections at a time. There are no SQL Error log
> entries
> other than the Transaction Log failing, no Application Events or System
> Events.
> The server did not go down, the CPUs (8) went to almost zero.
> SQL Server Enterprise Manager was getting a network error message when
> trying to connect and within 5 minutes everything was OK.
> Any help?
> Thanks,
> ThomasLL|||Are you using any third party backup software?
You can also get this error if you are running low on system
resources - mostly memory.
You may have too much of a server load at the time you tried
to do the backup. You'd want to get some baselines numbers
using Performance Monitor.
-Sue
On Mon, 9 Oct 2006 09:54:02 -0700, Thomas.LeBlanc@.NoSpam.Com
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote:
>Recieved this error this morning, at the same time are users were kicked ou
t
>of SQL Server.
>We have anout 1500 connections at a time. There are no SQL Error log entrie
s
>other than the Transaction Log failing, no Application Events or System
>Events.
>The server did not go down, the CPUs (8) went to almost zero.
>SQL Server Enterprise Manager was getting a network error message when
>trying to connect and within 5 minutes everything was OK.
>Any help?
>Thanks,
>ThomasLL|||Thanks everyone!!!
--
Thanks,
ThomasLL, MCDBA
"Thomas.LeBlanc@.NoSpam.Com" wrote:
> Recieved this error this morning, at the same time are users were kicked o
ut
> of SQL Server.
> We have anout 1500 connections at a time. There are no SQL Error log entri
es
> other than the Transaction Log failing, no Application Events or System
> Events.
> The server did not go down, the CPUs (8) went to almost zero.
> SQL Server Enterprise Manager was getting a network error message when
> trying to connect and within 5 minutes everything was OK.
> Any help?
> Thanks,
> ThomasLL
Friday, February 24, 2012
Error 28562 and Error 28037
I have a Merge Replication on SQL2005 SP1 running on a Microsoft
Server 2003 SP1.
My Subscribers are 60 Handhelds.
>From time to time when Handhelds try to Synch, we get Error 28562 on
some of them
and its usually resolved by warm booting the Handheld and then Re-
Synch.
I dont know if this solution is just luck or if the error indicates a
handheld memory issue.
This error usually Occurs when the Subscriber has a lot of deletions
to process.
My first Question is ,why from time to time the subscriber has large
numbers of rows to delete and why
this error appears.
Now from time to time again i get a 28037 Error witch again the
Resolving of it is to Re-Synch.
Can somebody Please explain this Error?
Thanks
Savvas Christodoulou
P.S If I put SQL2005 SP2 and MS2003 SP2 will this issues continue?
I believe these errors indicate problems in establishing connection to the
IIS of your server.
read this :
[url]http://www.kbalertz.com/842907/Server.client.programs.connect.computers.running.W indows.aspx[/url]
maybe it will help you...
r
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1174977871.162264.63080@.p15g2000hsd.googlegro ups.com...
> Hi to All,
> I have a Merge Replication on SQL2005 SP1 running on a Microsoft
> Server 2003 SP1.
> My Subscribers are 60 Handhelds.
> some of them
> and its usually resolved by warm booting the Handheld and then Re-
> Synch.
> I dont know if this solution is just luck or if the error indicates a
> handheld memory issue.
> This error usually Occurs when the Subscriber has a lot of deletions
> to process.
> My first Question is ,why from time to time the subscriber has large
> numbers of rows to delete and why
> this error appears.
> Now from time to time again i get a 28037 Error witch again the
> Resolving of it is to Re-Synch.
> Can somebody Please explain this Error?
> Thanks
> Savvas Christodoulou
> P.S If I put SQL2005 SP2 and MS2003 SP2 will this issues continue?
>
|||If the problem is on Establishing connection with IIS then why all
other Handhelds can establish is via GPRS and only 1 or 2 per day
cannot do it and they have to Re-Synch?
And I also have to mension that in replication monitor I can see the
failure attemp of Synchronization, if there is a problem with the
connection there is no link to the server and the attemp to synch
never reatch the Server.
Any Other ideas?
Error 28055 when creating mirroring endpoint.
However all the time I try to create the endpoint I got the Message:
"The certificta e'MyCert' is not valid fer endpoint authentication. The
certificate must have a privare key encrypted with the database master key
and current UTC date has to be between the certificate start date end
expiration date."
I used the sripts like shown in the example at the help file:
use master
create master key encryption by password ='MyPassword'
go
create certificate 'MyCert' with subject ='Mirroring Certificate',
Expiry_date = '12/31/2020'
go
create Endpoint EPSorry to fast fingers :-)
create Endpoint EP
state=started
as tcp (listener_port=5022, listener_ID=ALL)
for database_mirroring(
Authentication=certificate MyCert,
encryption=required Algorithm AES,
Role=all)
and this create statement will fail all the time
Regards
Michael|||If you live in the eastern hemisphere the newly created cert start date is
not yet valid for a number of hours equal to the difference of hours between
your zone and GMT. So simply specify a start date for the certificate as
well:
create certificate 'MyCert' with subject ='Mirroring Certificate',
Expiry_date = '12/31/2020',
start_date = '02/21/2007';
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Michael W. Schneider" <MichaelWSchneider@.discussions.microsoft.com> wrote
in message news:346EF8CB-35F7-4CEF-8DD0-7A38DBCC87C8@.microsoft.com...
> Sorry to fast fingers :-)
> create Endpoint EP
> state=started
> as tcp (listener_port=5022, listener_ID=ALL)
> for database_mirroring(
> Authentication=certificate MyCert,
> encryption=required Algorithm AES,
> Role=all)
> and this create statement will fail all the time
> Regards
> Michael
>
Friday, February 17, 2012
Error 22002
This is my first time in this fourm!
I've got SQL Server Standrad Edition version 8.00.760 (SP3) on Windows 2K. I'm logged in with my domain account, which is member of sysadmin
I get
"Autostart server agent" but following error appearred:
"Error 22002: Reg Create key ex() returened error 5:Access is denied"
when I check for Autostart MSDTC in SQL Server properties.
Why? Any ideas?
Thanks for all helpWhat accounts (including their permissions) are being used for the mssqlserver, agent and dtc services ?|||Originally posted by rnealejr
What accounts (including their permissions) are being used for the mssqlserver, agent and dtc services ?
Mssqlserver service and agent have the same local admin account.|||What about dtc ? Also, when you say local administrator account, do you mean .\Administrator ? Have you rebooted/restarted all the services ?|||Originally posted by rnealejr
What about dtc ? Also, when you say local administrator account, do you mean .\Administrator ? Have you rebooted/restarted all the services ?
Yes, they are .\Administrator. I don't know which dtc account use. I donot know where to look for this account! I 'm rather new at this job!|||Look for the distributed transaction coordinator service.|||Originally posted by rnealejr
Look for the distributed transaction coordinator service.
Local system account
Allow service to interact with desktop|||Originally posted by rnealejr
Look for the distributed transaction coordinator service.
I succeded starting this servicve automaticlly in Contral Panel, Services.
Thanks for your time and help!
Error -2147024809 An error has occured on the computer running IIS
I am sync. for the first time (Merge Replication using SQL 2005 and Mobile) and this error keeps poping up on the emulator. I am tring out the tutorial. :) boss on my butt.
Does anyone have any ideas or a solution to this...your help is WELL APPRECIATED ...
Error code: -2147024809
zo
1. Can I assume the merge emulator run for merge sync on SQL mobile device?
2. Does the error popup on every sync or from time to time?
Thanks.
|||I have talked with one of the experts and the error number -2147024809 stands for invalid arguments.
Can you check the parameters again on the sync object? Did you see any exception message also?
Thanks.
This posting is provided AS IS with no warranties, and confers no rights
|||Sorry for the late reply...The parameters for the sync object (based on the sample in msdn) are correct. At first I thought it was a permission problem. I went through the debug process and the error comes up on the emulator when the code gets to repl.syncronize, then the exception is thrown giving the error above. Here is the code:
Sub Sync()
Dim repl As New SqlCeReplication()
repl.InternetUrl = "http://localhost/SQLMobile/sqlcesa30.dll"
repl.Publisher = "REALTORBUSINESS\JONES_SQL"
repl.PublisherDatabase = "SQLMobile"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "SQLMobile"
repl.Subscriber = "SQLMobile"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;"
Try
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()
Catch err As SqlCeException
DisplaySQLCEErrors(err)
End Try
End Sub
Public Sub DisplaySQLCEErrors(ByVal ex As SqlCeException)
Dim errorCollection As SqlCeErrorCollection = ex.Errors
Dim bld As New StringBuilder()
Dim inner As Exception = ex.InnerException
Dim err As SqlCeError
For Each err In errorCollection
bld.Append(ControlChars.Lf + " Error Code: " + err.HResult.ToString())
bld.Append(ControlChars.Lf + " Message : " + err.Message)
bld.Append(ControlChars.Lf + " Minor Err.: " + err.NativeError.ToString())
bld.Append(ControlChars.Lf + " Source : " + err.Source)
Dim numPar As Integer
For Each numPar In err.NumericErrorParameters
If (numPar <> 0) Then
bld.Append(ControlChars.Lf + " Num. Par. : " + numPar.ToString())
End If
Next numPar
Dim errPar As String
For Each errPar In err.ErrorParameters
If (errPar <> String.Empty) Then
bld.Append(ControlChars.Lf + " Err. Par. : " + errPar)
End If
Next errPar
MessageBox.Show(bld.ToString(), "SQL Mobile Error")
Next err
I am going to try straight to the device, emulator might be screwed. Let me know what you find out ... got to figure this out one way or another, I have a project depending on it.
Appreciate everything and everyone ... Thank you.
|||See what error message in the runtime you have captured.
Thanks.
|||The error codes from the runtime is as follows:
Error Code: -2147024809
Message: An error has occured on the computer running IIS. Try restarting the IIS Server. (Tried several times)
Minor Error: 28022
Source: Microsoft SQL Server 2005 Mobile Edition
|||Did you run the above code on the CE device? If true then I am wondering repl.InternetUrl = "http://localhost/SQLMobile/sqlcesa30.dll" might be the cause. Can you try to use the IIS machine name instead of "localhost"?
Thanks.
This posting is provided AS IS with no warranties, and confers no rights
|||No, I haven't ran it on the CE device. I am using the emulator first, I figure if it woks there it should work anywhere else...but, I will change the URL and see what happens.
Let you know in a minute.
|||I'm pretty sure you need to use HTTPS as well, HTTP should fail with a graceful error msg.|||I had the same error number in a custom build Powerpoint wizard whenyou failed to enter a filename of a background picture for the front
page.
In general is seems to indicate a wrong or invalid parameter in a system call.
Complete error message was:
"Err. -2147024809-
Description: The specified file wasn't found."
Error 213: Insert Error: Column name or values don't match table definition
I have had the below procedure working and in use for some time now,
and suddently i started getting the below error:
"Eorror 213: Insert Error: Column name or number of supplied values
does not match table definition"
Thank you
CREATE PROCEDURE bat_LogData (
@.ComputerName varchar(50),
@.UserDomain varchar(50),
@.UserName varchar(50),
@.Date_Time datetime,
@.Message varchar(128),
@.SubMessage varchar(128),
@.ErrorText varchar(128),
@.ErrorCode nvarchar(15),
@.smsguid nvarchar(41),
@.locale int,
@.scriptver nvarchar(15),
@.wshver nvarchar(15)
)
AS
INSERT INTO LogonScript_data VALUES (
@.ComputerName,
@.UserName,
@.UserDomain,
GetDate(),
@.Date_Time,
@.Message,
@.SubMessage,
@.ErrorText,
@.ErrorCode,
@.smsguid,
@.locale,
@.scriptver,
@.wshver
)
SELECT @.@.IDENTITY AS 'MessageID'
GOrdixon5652@.hotmail.com wrote:
> Hello,
> I have had the below procedure working and in use for some time now,
> and suddently i started getting the below error:
> "Eorror 213: Insert Error: Column name or number of supplied values
> does not match table definition"
> Thank you
> CREATE PROCEDURE bat_LogData (
> @.ComputerName varchar(50),
> @.UserDomain varchar(50),
> @.UserName varchar(50),
> @.Date_Time datetime,
> @.Message varchar(128),
> @.SubMessage varchar(128),
> @.ErrorText varchar(128),
> @.ErrorCode nvarchar(15),
> @.smsguid nvarchar(41),
> @.locale int,
> @.scriptver nvarchar(15),
> @.wshver nvarchar(15)
> )
> AS
> INSERT INTO LogonScript_data VALUES (
> @.ComputerName,
> @.UserName,
> @.UserDomain,
> GetDate(),
> @.Date_Time,
> @.Message,
> @.SubMessage,
> @.ErrorText,
> @.ErrorCode,
> @.smsguid,
> @.locale,
> @.scriptver,
> @.wshver
> )
> SELECT @.@.IDENTITY AS 'MessageID'
> GO
I expect the table changed. Did you add or drop a column?
Always list the column names in an INSERT statement. Leaving them out
as you have done will inevitably make your code less reliable and
harder to debug. For example:
INSERT INTO LogonScript_data (
computername, username, userdomain, dt, date_time, message,
submessage,
errortext, errorcode, smsguid, locale, scriptver, wshver)
VALUES
(@.computername, @.username, @.userdomain, GETDATE(), @.date_time,
@.message,
@.submessage, @.errortext, @.errorcode, @.smsguid, @.locale, @.scriptver,
@.wshver
)
David Portas
SQL Server MVP
--