Environment:
SQL SERVER 2000 sp3 with security patch 818
Cluster environment: active-passive
HP running Windows 2003 with patches
Situation:
A stored procedure is running along with several other BCP
running.
I truned on DBCC TRACEON (818 -1)
I would like help with this error:
ERROR:
DATE/TIME: 10/1/2003 10:16:52 AM
DESCRIPTION: Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:3360903) in
database 'WaveAggDetach' belongs to
object 'aggTradePlanVolume', not to
object 'aggTradePlanVolumeInvoiced'.
COMMENT: (None)
JOB RUN: (None)Does the database come out clean from a DBCC CHECKDB?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Katherine" <kphelps@.oceanspray.com> wrote in message news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>|||Does the stored procedure contain a cursor..?
If so try changing the cursor type to INSESNSITIVE.
Have a look at :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q156662
--
HTH
Ryan Waight, MCDBA, MCSE
"Katherine" <kphelps@.oceanspray.com> wrote in message
news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>
Showing posts with label sp3. Show all posts
Showing posts with label sp3. Show all posts
Monday, March 26, 2012
Thursday, March 22, 2012
Error: 3624 and event ID: 17055
We have a problem with our SQL Server.
the server is a windows 2K server SP3, running SQL Server
2K SP2. the problem we have is when we try to view JOBS
under Management. I get the following error.
Error: 3624
Location: rebcase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 54
Process ID: 1268
in the Event logs under application we get the following
Errors:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/12/2003
Time: 9:09:44:AM
User: MARCRIST\AdamB
Computer: ANIMAL
Description:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
---
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/12/2003
Time: 9:15:20:AM
User: MARCRIST\AdamB
Computer: ANIMAL
Description:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
both these refere to the MSDB, the only change we have
made recently is to install the Veratis SQL Server Agent.
I would be grateful for any help or advice.| We have a problem with our SQL Server.
| the server is a windows 2K server SP3, running SQL Server
| 2K SP2. the problem we have is when we try to view JOBS
| under Management. I get the following error.
|
| Error: 3624
| Location: rebcase.cpp:1378
| Expression: m_offBeginVar < m_SizeRec
| SPID: 54
| Process ID: 1268
|
| in the Event logs under application we get the following
| Errors:
|
| Event Type: Error
| Event Source: MSSQLSERVER
| Event Category: (2)
| Event ID: 17055
| Date: 01/12/2003
| Time: 9:09:44:AM
| User: MARCRIST\AdamB
| Computer: ANIMAL
| Description:
| 17066 :
| SQL Server Assertion: File: <recbase.cpp>, line=1378
| Failed Assertion = 'm_offBeginVar < m_SizeRec'.
|
| ---
|
| Event Type: Error
| Event Source: MSSQLSERVER
| Event Category: (2)
| Event ID: 17055
| Date: 01/12/2003
| Time: 9:15:20:AM
| User: MARCRIST\AdamB
| Computer: ANIMAL
| Description:
| 17066 :
| SQL Server Assertion: File: <recbase.cpp>, line=1378
| Failed Assertion = 'm_offBeginVar < m_SizeRec'.
|
|
| both these refere to the MSDB, the only change we have
| made recently is to install the Veratis SQL Server Agent.
|
| I would be grateful for any help or advice.
--
Hi Adam,
This might help:
FIX: An INSERT May Fail with a 3624 Error Message After a Failed Attempt to
Add New Table Column
http://support.microsoft.com/?id=317852
--
Eric Cárdenas
SQL Server support
the server is a windows 2K server SP3, running SQL Server
2K SP2. the problem we have is when we try to view JOBS
under Management. I get the following error.
Error: 3624
Location: rebcase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 54
Process ID: 1268
in the Event logs under application we get the following
Errors:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/12/2003
Time: 9:09:44:AM
User: MARCRIST\AdamB
Computer: ANIMAL
Description:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
---
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/12/2003
Time: 9:15:20:AM
User: MARCRIST\AdamB
Computer: ANIMAL
Description:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
both these refere to the MSDB, the only change we have
made recently is to install the Veratis SQL Server Agent.
I would be grateful for any help or advice.| We have a problem with our SQL Server.
| the server is a windows 2K server SP3, running SQL Server
| 2K SP2. the problem we have is when we try to view JOBS
| under Management. I get the following error.
|
| Error: 3624
| Location: rebcase.cpp:1378
| Expression: m_offBeginVar < m_SizeRec
| SPID: 54
| Process ID: 1268
|
| in the Event logs under application we get the following
| Errors:
|
| Event Type: Error
| Event Source: MSSQLSERVER
| Event Category: (2)
| Event ID: 17055
| Date: 01/12/2003
| Time: 9:09:44:AM
| User: MARCRIST\AdamB
| Computer: ANIMAL
| Description:
| 17066 :
| SQL Server Assertion: File: <recbase.cpp>, line=1378
| Failed Assertion = 'm_offBeginVar < m_SizeRec'.
|
| ---
|
| Event Type: Error
| Event Source: MSSQLSERVER
| Event Category: (2)
| Event ID: 17055
| Date: 01/12/2003
| Time: 9:15:20:AM
| User: MARCRIST\AdamB
| Computer: ANIMAL
| Description:
| 17066 :
| SQL Server Assertion: File: <recbase.cpp>, line=1378
| Failed Assertion = 'm_offBeginVar < m_SizeRec'.
|
|
| both these refere to the MSDB, the only change we have
| made recently is to install the Veratis SQL Server Agent.
|
| I would be grateful for any help or advice.
--
Hi Adam,
This might help:
FIX: An INSERT May Fail with a 3624 Error Message After a Failed Attempt to
Add New Table Column
http://support.microsoft.com/?id=317852
--
Eric Cárdenas
SQL Server support
Monday, March 19, 2012
Error: 17883
8.00.818, SP3, Standard Edition
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.
Error: 17883
8.00.818, SP3, Standard Edition
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.
Error: 17883
8.00.818, SP3, Standard Edition
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?
Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>
|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.
After installing SP3, the server hangs with Error: 17883, Severity: 0,
State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
non-yielding on Scheduler 0.
MS03-031 does not resolve this problem.
Any suggestions?
Correction: Severity: 1, State 0.
"TLW" <tlw@.oceanlighthouse.com> wrote in message
news:eSomf6FKEHA.1760@.TK2MSFTNGP10.phx.gbl...
> 8.00.818, SP3, Standard Edition
> After installing SP3, the server hangs with Error: 17883, Severity: 0,
> State: 1. Process 0:0 (a04) UMS Context 0x105BB428 appears to be
> non-yielding on Scheduler 0.
> MS03-031 does not resolve this problem.
> Any suggestions?
>
|||I'm having the same issue. I was able to discuss it with a MS
instructor at Sql Connections last week. He said the error is too
internal for troubleshooting other than by MS.
I have setup a black box trace and an alert. The alert will fire on
17883 stopping the black box trace and doing a dbcc stackdump. When
it happens again I'll open a ticket with Microsoft and send off the
files.
Error: 17805, Severity: 20, State: 3
1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?
Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?
|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes away
> (In EM, Server Properties. Network Configuration, Restart the server)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>
>
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?
Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?
|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes away
> (In EM, Server Properties. Network Configuration, Restart the server)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>
>
Error: 17805, Severity: 20, State: 3
1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed u
p
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes awa
y
> (In EM, Server Properties. Network Configuration, Restart the server)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>
>
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed u
p
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes awa
y
> (In EM, Server Properties. Network Configuration, Restart the server)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>
>
Error: 17805, Severity: 20, State: 3
1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes away
> (In EM, Server Properties. Network Configuration, Restart the server)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
> >1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> > SP4,SQL2k SP4), the system can not run and got the error message in log
> >
> > Error: 17805, Severity: 20, State: 3
> > Invalid buffer received from client.
> >
> > Is this SQL2k SP4 new bug?
>
>
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes away
> (In EM, Server Properties. Network Configuration, Restart the server)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
> >1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> > SP4,SQL2k SP4), the system can not run and got the error message in log
> >
> > Error: 17805, Severity: 20, State: 3
> > Invalid buffer received from client.
> >
> > Is this SQL2k SP4 new bug?
>
>
Error: 16954, Severity: 10, State: 1 and Timeout problem
Hi to all,
I have a problem I can not trace.
Andgeneraly this is my problem probably.
I have a SQL Server 2000 SP3 with one database.
On this DB are runing lot of threads from different applications. So
the access is multiple.
The problem is, on one of the applications (C++ programmed) I get from
time to time, problem, that the calls in database are sometimes
performed very very long.
If usualy it takes like 50ms, sometimes it takes up to over one minute!
I can not trace, why the application need so long time, to perform this
statement.
I've checked the code, but it seams to be ok.
Probably, other aplication are locking resources, so the first one need
to wait so long.
Question is, how to find out, which one is locking the resources, or
maybe which resources for so long?
I was trying to analyze SQL Profiler, but the only error I found was
this one:
Error: 16954, Severity: 10, State: 1
Help me, how to diagnose the problem. How can I trace, which processes
are blocking eachother.
Any advise will be helpful..
Thanks - MatikMatik (marzec@.sauron.xo.pl) writes:
> I have a SQL Server 2000 SP3 with one database.
> On this DB are runing lot of threads from different applications. So
> the access is multiple.
> The problem is, on one of the applications (C++ programmed) I get from
> time to time, problem, that the calls in database are sometimes
> performed very very long.
> If usualy it takes like 50ms, sometimes it takes up to over one minute!
> I can not trace, why the application need so long time, to perform this
> statement.
> I've checked the code, but it seams to be ok.
> Probably, other aplication are locking resources, so the first one need
> to wait so long.
> Question is, how to find out, which one is locking the resources, or
> maybe which resources for so long?
> I was trying to analyze SQL Profiler, but the only error I found was
> this one:
> Error: 16954, Severity: 10, State: 1
The text for this message is "Executing SQL directly; no cursor."
> Help me, how to diagnose the problem. How can I trace, which processes
> are blocking eachother.
You could try my aba_lockinfo. This stored procedure gives you a
snapshot of what is going on. Which processes that are active,
which are blocking and which are block. You get what they lock,
what they are waiting for, and their current statement. You find it on
http://www.sommarskog.se/sqlutil/aba_lockinfo.html.
--
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|||Thank's Erland!
Matik
Erland Sommarskog napisal(a):
> Matik (marzec@.sauron.xo.pl) writes:
> > I have a SQL Server 2000 SP3 with one database.
> > On this DB are runing lot of threads from different applications. So
> > the access is multiple.
> > The problem is, on one of the applications (C++ programmed) I get from
> > time to time, problem, that the calls in database are sometimes
> > performed very very long.
> > If usualy it takes like 50ms, sometimes it takes up to over one minute!
> > I can not trace, why the application need so long time, to perform this
> > statement.
> > I've checked the code, but it seams to be ok.
> > Probably, other aplication are locking resources, so the first one need
> > to wait so long.
> > Question is, how to find out, which one is locking the resources, or
> > maybe which resources for so long?
> > I was trying to analyze SQL Profiler, but the only error I found was
> > this one:
> > Error: 16954, Severity: 10, State: 1
> The text for this message is "Executing SQL directly; no cursor."
> > Help me, how to diagnose the problem. How can I trace, which processes
> > are blocking eachother.
> You could try my aba_lockinfo. This stored procedure gives you a
> snapshot of what is going on. Which processes that are active,
> which are blocking and which are block. You get what they lock,
> what they are waiting for, and their current statement. You find it on
> http://www.sommarskog.se/sqlutil/aba_lockinfo.html.
>
> --
> 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
Sunday, March 11, 2012
Error: "Invalid buffer received from client"
Hi,
We have a Java application with SQL 2000 db. Our
application was tested on MS SQL Server 2000 with SP3
installed (security patch MS03-031 was not installed). But
once the security patch(MS03-031) was installed, it
started giving the following error.
"2003-10-03 09:16:44.19 spid61 Error: 17805,
Severity: 20, State: 3
2003-10-03 09:35:04.46 spid68 Invalid buffer received
from client.."
on the SQL Server environment. This error is not
consistent. Now and then it is happening.
DB Server : SQL Server 2000 SP3 + MS03-031OS : :
Windows 2000 (Build 2195: Service Pack 2)We are using
JRUN/Tomcat as application server and using Microsoft JDBC
Driver Type 4 for connecting to the SQL Server. Our whole
application is on J2EE Architecture.
Please let me know if any of you have any solution for
this.
Thanks in advance.
Regards,
JPI had a quick search on Microsoft and found this :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q236447
not sure it will help as it was written for SQL 6.5. Worth a read though.
HTH
Ryan Waight, MCDBA, MCSE
"JP" <jobtechie@.yahoo.com> wrote in message
news:0faf01c38cd5$3282a010$a301280a@.phx.gbl...
> Hi,
> We have a Java application with SQL 2000 db. Our
> application was tested on MS SQL Server 2000 with SP3
> installed (security patch MS03-031 was not installed). But
> once the security patch(MS03-031) was installed, it
> started giving the following error.
> "2003-10-03 09:16:44.19 spid61 Error: 17805,
> Severity: 20, State: 3
> 2003-10-03 09:35:04.46 spid68 Invalid buffer received
> from client.."
> on the SQL Server environment. This error is not
> consistent. Now and then it is happening.
> DB Server : SQL Server 2000 SP3 + MS03-031OS : :
> Windows 2000 (Build 2195: Service Pack 2)We are using
> JRUN/Tomcat as application server and using Microsoft JDBC
> Driver Type 4 for connecting to the SQL Server. Our whole
> application is on J2EE Architecture.
> Please let me know if any of you have any solution for
> this.
> Thanks in advance.
> Regards,
> JP
We have a Java application with SQL 2000 db. Our
application was tested on MS SQL Server 2000 with SP3
installed (security patch MS03-031 was not installed). But
once the security patch(MS03-031) was installed, it
started giving the following error.
"2003-10-03 09:16:44.19 spid61 Error: 17805,
Severity: 20, State: 3
2003-10-03 09:35:04.46 spid68 Invalid buffer received
from client.."
on the SQL Server environment. This error is not
consistent. Now and then it is happening.
DB Server : SQL Server 2000 SP3 + MS03-031OS : :
Windows 2000 (Build 2195: Service Pack 2)We are using
JRUN/Tomcat as application server and using Microsoft JDBC
Driver Type 4 for connecting to the SQL Server. Our whole
application is on J2EE Architecture.
Please let me know if any of you have any solution for
this.
Thanks in advance.
Regards,
JPI had a quick search on Microsoft and found this :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q236447
not sure it will help as it was written for SQL 6.5. Worth a read though.
HTH
Ryan Waight, MCDBA, MCSE
"JP" <jobtechie@.yahoo.com> wrote in message
news:0faf01c38cd5$3282a010$a301280a@.phx.gbl...
> Hi,
> We have a Java application with SQL 2000 db. Our
> application was tested on MS SQL Server 2000 with SP3
> installed (security patch MS03-031 was not installed). But
> once the security patch(MS03-031) was installed, it
> started giving the following error.
> "2003-10-03 09:16:44.19 spid61 Error: 17805,
> Severity: 20, State: 3
> 2003-10-03 09:35:04.46 spid68 Invalid buffer received
> from client.."
> on the SQL Server environment. This error is not
> consistent. Now and then it is happening.
> DB Server : SQL Server 2000 SP3 + MS03-031OS : :
> Windows 2000 (Build 2195: Service Pack 2)We are using
> JRUN/Tomcat as application server and using Microsoft JDBC
> Driver Type 4 for connecting to the SQL Server. Our whole
> application is on J2EE Architecture.
> Please let me know if any of you have any solution for
> this.
> Thanks in advance.
> Regards,
> JP
Friday, February 24, 2012
Error while trying to open/create a DTS - urgent
Hi,
I have MSDE SP3 installed and the only thing that I have changed
recently is my Windows login Password.
In the Enterprise Manager the SQL server is registered using mixed
authentication.
When I try to open any DTS in Design mode, I get an error dialog with
the title 'DTS Design error' and saying that:
"Error occured during creation of a DTS package"
and then when I click on the OKAY button I get the 2nd error dialog
saying:
"The selected package cannot be opened. The DTS designer has been
closed."
I am getting the same message when I try to create a new package
Can someone PLEASE help me out here.
Thanks.
Re-register the DTS dlls.
You can find them listed here
Redistributing DTS with your program
(http://www.sqldts.com/Default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Learner" <wantnospam@.email.com> wrote in message
news:MPG.1bc14741c6d2435e989747@.msnews.microsoft.c om...
> Hi,
> I have MSDE SP3 installed and the only thing that I have changed
> recently is my Windows login Password.
> In the Enterprise Manager the SQL server is registered using mixed
> authentication.
> When I try to open any DTS in Design mode, I get an error dialog with
> the title 'DTS Design error' and saying that:
> "Error occured during creation of a DTS package"
>
> and then when I click on the OKAY button I get the 2nd error dialog
> saying:
> "The selected package cannot be opened. The DTS designer has been
> closed."
>
> I am getting the same message when I try to create a new package
> Can someone PLEASE help me out here.
> --
> Thanks.
|||Many thanks Allan. Appreciate your help.
Regards.
> | Re-register the DTS dlls.
> |
> | You can find them listed here
> |
> | Redistributing DTS with your program
> | (http://www.sqldts.com/Default.aspx?225)
> |
> |
I have MSDE SP3 installed and the only thing that I have changed
recently is my Windows login Password.
In the Enterprise Manager the SQL server is registered using mixed
authentication.
When I try to open any DTS in Design mode, I get an error dialog with
the title 'DTS Design error' and saying that:
"Error occured during creation of a DTS package"
and then when I click on the OKAY button I get the 2nd error dialog
saying:
"The selected package cannot be opened. The DTS designer has been
closed."
I am getting the same message when I try to create a new package
Can someone PLEASE help me out here.
Thanks.
Re-register the DTS dlls.
You can find them listed here
Redistributing DTS with your program
(http://www.sqldts.com/Default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Learner" <wantnospam@.email.com> wrote in message
news:MPG.1bc14741c6d2435e989747@.msnews.microsoft.c om...
> Hi,
> I have MSDE SP3 installed and the only thing that I have changed
> recently is my Windows login Password.
> In the Enterprise Manager the SQL server is registered using mixed
> authentication.
> When I try to open any DTS in Design mode, I get an error dialog with
> the title 'DTS Design error' and saying that:
> "Error occured during creation of a DTS package"
>
> and then when I click on the OKAY button I get the 2nd error dialog
> saying:
> "The selected package cannot be opened. The DTS designer has been
> closed."
>
> I am getting the same message when I try to create a new package
> Can someone PLEASE help me out here.
> --
> Thanks.
|||Many thanks Allan. Appreciate your help.
Regards.
> | Re-register the DTS dlls.
> |
> | You can find them listed here
> |
> | Redistributing DTS with your program
> | (http://www.sqldts.com/Default.aspx?225)
> |
> |
Friday, February 17, 2012
Error while installing SQL2k sp3 (on Win2k Server) - First Post
Hi all... I'm new here and maybe u guys/gals can help me out with a little (actually it's pretty big) problem.
I've searched through this forum, but could not find anything like my problem in here...
Here's the problem:
I'm running Win2000 (SP3) server with SQL Server 2000 (Developer Edition).
I installed all recent hotfixes for Win2K and SQL2K but I didn't make it to install SP3 for SQL Server 2000. This morning I had time to install it and so i tried to.
The first things of the installing procedure went fine... But when it started to execute the scripts something went horrible wrong... When it was executing script nr. 4 (don't know the name of the script, sorry) it told me it had problem executing this script.
I then clicked OK and the installation procedure was aborted by the machine, without any messages that could help me get further.
I then rebooted the machine and tried to install again. When I started to install procedure it checked my authentication (both times I was logged in as administrator) and told me it could not start the procedure because I do not have persmission. Also when I try start the install procedure by using the SA account, it fails.
Does anybody have any suggestions for me
THX in advance...
GRTNGS TovenaarCheck for SQLSTP.LOG for more information and step details during the process.|||THX for the info, although I just found the solution @. m'soft's website.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;814844 method 2, with the Envir. Var's)
THX for replying though...
GRTNGS Tovenaar
I've searched through this forum, but could not find anything like my problem in here...
Here's the problem:
I'm running Win2000 (SP3) server with SQL Server 2000 (Developer Edition).
I installed all recent hotfixes for Win2K and SQL2K but I didn't make it to install SP3 for SQL Server 2000. This morning I had time to install it and so i tried to.
The first things of the installing procedure went fine... But when it started to execute the scripts something went horrible wrong... When it was executing script nr. 4 (don't know the name of the script, sorry) it told me it had problem executing this script.
I then clicked OK and the installation procedure was aborted by the machine, without any messages that could help me get further.
I then rebooted the machine and tried to install again. When I started to install procedure it checked my authentication (both times I was logged in as administrator) and told me it could not start the procedure because I do not have persmission. Also when I try start the install procedure by using the SA account, it fails.
Does anybody have any suggestions for me
THX in advance...
GRTNGS TovenaarCheck for SQLSTP.LOG for more information and step details during the process.|||THX for the info, although I just found the solution @. m'soft's website.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;814844 method 2, with the Envir. Var's)
THX for replying though...
GRTNGS Tovenaar
Subscribe to:
Posts (Atom)