Showing posts with label page. Show all posts
Showing posts with label page. Show all posts

Monday, March 26, 2012

error 17052

Error: 644, Severity: 21, State: 3
Could not find the index entry for
RID '36100101406d0610730740650720' in index page (1:257),
index ID 0, database 'master'.
Any help or direction would be greatly appreciated.
ThanksHave you run a dbcc checkdb on the master database?
You can run this with the repair option and see if it
fixes your problem.
>--Original Message--
>Error: 644, Severity: 21, State: 3
>Could not find the index entry for
>RID '36100101406d0610730740650720' in index page (1:257),
>index ID 0, database 'master'.
>Any help or direction would be greatly appreciated.
>Thanks
>.
>|||I have not. I can not get the sql server service to start.
This might help:
2003-11-19 09:30:58.55 server Microsoft SQL Server
2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195:
Service Pack 4)
2003-11-19 09:30:58.55 server Copyright (C) 1988-2002
Microsoft Corporation.
2003-11-19 09:30:58.55 server All rights reserved.
2003-11-19 09:30:58.55 server Server Process ID is
2416.
2003-11-19 09:30:58.55 server Logging SQL Server
messages in file 'd:\sqlroot\MSSQL\log\ERRORLOG'.
2003-11-19 09:30:58.57 server SQL Server is starting
at priority class 'normal'(4 CPUs detected).
2003-11-19 09:30:58.66 server SQL Server configured
for thread mode processing.
2003-11-19 09:30:58.66 server Using dynamic lock
allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2003-11-19 09:30:58.74 server Attempting to initialize
Distributed Transaction Coordinator.
2003-11-19 09:31:00.79 spid3 Starting up
database 'master'.
2003-11-19 09:31:00.93 spid3 0 transactions rolled
back in database 'master' (1).
2003-11-19 09:31:00.93 spid3 Recovery is
checkpointing database 'master' (1)
2003-11-19 09:31:00.94 spid3 Error: 644, Severity:
21, State: 3
2003-11-19 09:31:00.94 spid3 Could not find the index
entry for RID '36100101406d0610730740650720' in index
page (1:257), index ID 0, database 'master'..
2003-11-19 09:31:00.94 spid3 Cannot recover the
master database. Exiting.
>--Original Message--
>Error: 644, Severity: 21, State: 3
>Could not find the index entry for
>RID '36100101406d0610730740650720' in index page
(1:257),
>index ID 0, database 'master'.
>Any help or direction would be greatly appreciated.
>Thanks
>.
>|||Read about rebuilding the master database (rebuildm.exe). That will clear out all system databases,
so after that you need to restore master and msdb in order to get that stuff back.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"eric" <anonymous@.discussions.microsoft.com> wrote in message
news:021201c3aed1$375103c0$a401280a@.phx.gbl...
> I have not. I can not get the sql server service to start.
>
> This might help:
> 2003-11-19 09:30:58.55 server Microsoft SQL Server
> 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195:
> Service Pack 4)
> 2003-11-19 09:30:58.55 server Copyright (C) 1988-2002
> Microsoft Corporation.
> 2003-11-19 09:30:58.55 server All rights reserved.
> 2003-11-19 09:30:58.55 server Server Process ID is
> 2416.
> 2003-11-19 09:30:58.55 server Logging SQL Server
> messages in file 'd:\sqlroot\MSSQL\log\ERRORLOG'.
> 2003-11-19 09:30:58.57 server SQL Server is starting
> at priority class 'normal'(4 CPUs detected).
> 2003-11-19 09:30:58.66 server SQL Server configured
> for thread mode processing.
> 2003-11-19 09:30:58.66 server Using dynamic lock
> allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> 2003-11-19 09:30:58.74 server Attempting to initialize
> Distributed Transaction Coordinator.
> 2003-11-19 09:31:00.79 spid3 Starting up
> database 'master'.
> 2003-11-19 09:31:00.93 spid3 0 transactions rolled
> back in database 'master' (1).
> 2003-11-19 09:31:00.93 spid3 Recovery is
> checkpointing database 'master' (1)
> 2003-11-19 09:31:00.94 spid3 Error: 644, Severity:
> 21, State: 3
> 2003-11-19 09:31:00.94 spid3 Could not find the index
> entry for RID '36100101406d0610730740650720' in index
> page (1:257), index ID 0, database 'master'..
> 2003-11-19 09:31:00.94 spid3 Cannot recover the
> master database. Exiting.
> >--Original Message--
> >Error: 644, Severity: 21, State: 3
> >Could not find the index entry for
> >RID '36100101406d0610730740650720' in index page
> (1:257),
> >index ID 0, database 'master'.
> >
> >Any help or direction would be greatly appreciated.
> >
> >Thanks
> >.
> >|||On Wed, 19 Nov 2003 08:21:35 -0800, "eric"
<anonymous@.discussions.microsoft.com> wrote:
>Error: 644, Severity: 21, State: 3
>Could not find the index entry for
>RID '36100101406d0610730740650720' in index page (1:257),
>index ID 0, database 'master'.
hi Eric,
we encountered the same issue on a freshly install of an
active/passive cluster Windows 2000 AS SP4 with SQLServer 2000 SP3.
the issue comes out when we try to move related cluster services from
node A to node B.
apart of fixing the master table, I'd be interested on knowing the
cause of such index curruption.
have you got any ideas?
thank you.
--
Francesco "Matro" Martire
available at www.realpopup.it:
RealPopup, the freeware winpopup replacer
RealAccount, freeware plugin for MS Outlook XP
MaTreo, freeware frontscreen for your Treo and PalmOS devices

Wednesday, March 7, 2012

Error 0x80040E31

Hi.

Somebody can tell how to deal with this error. When I try to connect from an
asp page to update a record wich has a ntext field it give me this error...

I tried with sp_configure 'remote query timeout',0 but no works...

What can I do ??
thanksDaviso (dhernande7@.alumno.uned.es) writes:

Quote:

Originally Posted by

Somebody can tell how to deal with this error. When I try to connect
from an asp page to update a record wich has a ntext field it give me
this error...
>
I tried with sp_configure 'remote query timeout',0 but no works...


Do you get any text with the error message, or just the error code?

If I am to guess from your fiddling with "remote query timeout", the
error is "Timeout Expired". "remote query timeout" is not going to help
you on that one, since that that is the time SQL Server uses when connecting
to linked servers.

Timeouts are always defined on client level, and from an ASP page, you would
set the CommandTimeout on the Connection object. Set it to 0 to wait
indefintely. By default the timeout is 30 seconds.

Another issue why your update takes more than 30 seconds. It could be a
blocking issue, and in that case it does not help if you change the timeout.
But with no information about your code and your system it's impossible to
tell.

--
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 [I/O error (bad page ID) detected during read at offset 0x000001ad65a000

When we try to run aggregation or purge queries on some tables
we are getting following message:

" error [I/O error (bad page ID) detected during read at offset 0x000001ad65a000 in file 'E:MSSQL2KDataGenesys_DataMartGenesys_Datamart.mdf '. Severity 24, State 2, Procedure 'PWMGENESYSDB1 n u! ll', Line 1]"

After this we executed DBCC CHECKDB. Attaching the output obtained after executing this command, to fix these errors we executed DBCC repair_allow_data_loss. I am attaching output for this also. Pls go thru the logs and pls let me know what could be the problem and how it can be addressed.

Thnx & Rgds
MallaIf this is a production system where uptime is important, you are probably looking at a restoration from backup. If you have time on your hands, you can try DBCC with repair_allow_data_loss a second time, as the first seems to have repaired one error. Microsoft support will probably advise the restore as well, since you can not really be sure what or how much data is going to be lost with repair_allow_data_loss.

Be sure to check in the Windows System Event Log for disk errors, as you may have a bad controller or bad disk on this server. If the hardware is not fixed, you may see this come up again and again.|||You should not have run with repair_allow_data_loss clause! All you had to do was to drop constraints on the offending tables (you had ONLY 2, and they were spelled out both with names and object IDs!!!), drop indexes on them, BCP data out of those tables, truncate the offending tables, re-create indexes, BULK INSERT data back in, and re-create constraints.
If this is a production system where uptime is important, you are probably looking at a restoration from backup...That's a drag, isn't it?! ;)

Sunday, February 19, 2012

Error - procedure expects parameter, which was not supplied

Hi,

I created a stored procedure in the sql server. I try to insert a record from the aspx page. But I keep getting this error,
"procedure expects parameter <@.firstname>, which was not supplied". This is what I am doing.

cmd.CommandText = "proc_insertuser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@.firstname", SqlDbType.VarChar, 50);
cmd.Parameters["@.firstname"].Value = txtFirstName.Text
...other parameters

I checked the parameter names, it matches correctly. The parameter does get added to the collection. I checked it using cmd.Parameters.Contains("@.firstname") and the value is also correct. Using query analyzer I executed the procedure, I am able to insert a record.

Can anyone tell me what could be the problem.
TAICan you use SQL Profiler? Perhaps that will help diagnose the problem. Is there some other parameter that is missing and being mis-reported?|||if you are using VB.NET I would try replacing your brackets surrounding your parameter name w/ parenthesis instead.

 cmd.Parameters("@.firstname").Value = txtFirstName.Text

HTH

Sandy

Friday, February 17, 2012

Error

Hey,
Has anyone seen / gotten this error before?
"Could not read and latch page (1:226688) with latch type
SH. Latch failed."
I get this error when i try to run a dbcc showcontig.
Any help is welcome
Thanxs
Did you read in Books Online about this error (8966). The most recent update
of books online has specific
suggestions for most of these error codes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"" <anonymous@.discussions.microsoft.com> wrote in message news:1a3b401c44dfe$60fa12d0$a001
280a@.phx.gbl...
> Hey,
> Has anyone seen / gotten this error before?
> "Could not read and latch page (1:226688) with latch type
> SH. Latch failed."
> I get this error when i try to run a dbcc showcontig.
> Any help is welcome
> Thanxs
> |||I dont find anything about this + when i look online on
error 8966 i get something completly different...
>--Original Message--
>Did you read in Books Online about this error (8966).
The most recent update of books online has specific
>suggestions for most of these error codes.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"" <anonymous@.discussions.microsoft.com> wrote in
message news:1a3b401c44dfe$60fa12d0$a001280a@.phx
.gbl...
type[vbcol=seagreen]
>
>.
>|||Do you have the updated books online? Where do you look?
serr_2_54ky.asp" target="_blank">http://msdn.microsoft.com/library/d...serr_2_54ky.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message news:1a4d201c44e15$943cd170$a001280a@.
phx.gbl...[vbcol=seagreen]
> I dont find anything about this + when i look online on
> error 8966 i get something completly different...
> The most recent update of books online has specific
> message news:1a3b401c44dfe$60fa12d0$a001280a@.phx
.gbl...
> type

Error

Hey,
Has anyone seen / gotten this error before?
"Could not read and latch page (1:226688) with latch type
SH. Latch failed."
I get this error when i try to run a dbcc showcontig.
Any help is welcome
Thanxs
:)Did you read in Books Online about this error (8966). The most recent update of books online has specific
suggestions for most of these error codes.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
":)" <anonymous@.discussions.microsoft.com> wrote in message news:1a3b401c44dfe$60fa12d0$a001280a@.phx.gbl...
> Hey,
> Has anyone seen / gotten this error before?
> "Could not read and latch page (1:226688) with latch type
> SH. Latch failed."
> I get this error when i try to run a dbcc showcontig.
> Any help is welcome
> Thanxs
> :)|||I dont find anything about this + when i look online on
error 8966 i get something completly different...
>--Original Message--
>Did you read in Books Online about this error (8966).
The most recent update of books online has specific
>suggestions for most of these error codes.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>":)" <anonymous@.discussions.microsoft.com> wrote in
message news:1a3b401c44dfe$60fa12d0$a001280a@.phx.gbl...
>> Hey,
>> Has anyone seen / gotten this error before?
>> "Could not read and latch page (1:226688) with latch
type
>> SH. Latch failed."
>> I get this error when i try to run a dbcc showcontig.
>> Any help is welcome
>> Thanxs
>> :)
>
>.
>|||Do you have the updated books online? Where do you look?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_2_54ky.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message news:1a4d201c44e15$943cd170$a001280a@.phx.gbl...
> I dont find anything about this + when i look online on
> error 8966 i get something completly different...
> >--Original Message--
> >Did you read in Books Online about this error (8966).
> The most recent update of books online has specific
> >suggestions for most of these error codes.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> >
> >
> >":)" <anonymous@.discussions.microsoft.com> wrote in
> message news:1a3b401c44dfe$60fa12d0$a001280a@.phx.gbl...
> >> Hey,
> >> Has anyone seen / gotten this error before?
> >>
> >> "Could not read and latch page (1:226688) with latch
> type
> >> SH. Latch failed."
> >>
> >> I get this error when i try to run a dbcc showcontig.
> >>
> >> Any help is welcome
> >>
> >> Thanxs
> >>
> >> :)
> >
> >
> >.
> >

Error

Hey,
Has anyone seen / gotten this error before?
"Could not read and latch page (1:226688) with latch type
SH. Latch failed."
I get this error when i try to run a dbcc showcontig.
Any help is welcome
Thanxs

Did you read in Books Online about this error (8966). The most recent update of books online has specific
suggestions for most of these error codes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"" <anonymous@.discussions.microsoft.com> wrote in message news:1a3b401c44dfe$60fa12d0$a001280a@.phx.gbl...
> Hey,
> Has anyone seen / gotten this error before?
> "Could not read and latch page (1:226688) with latch type
> SH. Latch failed."
> I get this error when i try to run a dbcc showcontig.
> Any help is welcome
> Thanxs
>
|||I dont find anything about this + when i look online on
error 8966 i get something completly different...
>--Original Message--
>Did you read in Books Online about this error (8966).
The most recent update of books online has specific
>suggestions for most of these error codes.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"" <anonymous@.discussions.microsoft.com> wrote in
message news:1a3b401c44dfe$60fa12d0$a001280a@.phx.gbl...[vbcol=seagreen]
type
>
>.
>
|||Do you have the updated books online? Where do you look?
http://msdn.microsoft.com/library/de...err_2_54ky.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message news:1a4d201c44e15$943cd170$a001280a@.phx.gbl...[vbcol=seagreen]
> I dont find anything about this + when i look online on
> error 8966 i get something completly different...
> The most recent update of books online has specific
> message news:1a3b401c44dfe$60fa12d0$a001280a@.phx.gbl...
> type

Error

I am getting this error trying accessing RM page.
Server Error in '/Reports' Application.
----
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set
to an instance of an object.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an
object.]
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object
sender, EventArgs e) +58
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64
Any idea?
ThanksOn Aug 12, 8:20 pm, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
> I am getting this error trying accessing RM page.
> Server Error in '/Reports' Application.
> ----
> Object reference not set to an instance of an object.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.NullReferenceException: Object reference not set
> to an instance of an object.
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
> [NullReferenceException: Object reference not set to an instance of an
> object.]
> Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object
> sender, EventArgs e) +58
> System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> +92
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +64
> Any idea?
> Thanks
This looks like a dual post. Here was my response for that one.
You should try looking in the SSRS logs to see if it gives you any
descriptive information (normally located in: C:\Program Files
\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles ). If you
cannot resolve the issue by looking at the logs, you should look into
reinstalling SSRS. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant