Skip to Content
0
Former Member
May 29, 2008 at 05:26 PM

Attempt to fetch logical page (6:78) in database 5 failed.

1435 Views

Hello every one:

I am upgrading to SQL 2005 using sql 2000 datafiles in clustered environment.

I have followd note 799058 hemogenious system copy. However after attaching the database, we are getting the following error message, when running SQL 2005 upgrade tools.

I ran dbcheck on source database there is no issue, However dbcheck is failing in new database. I tried dbcheck with repais fast and dbcheck with data loss, however both attempts have failed with exact same message.

I am not sure how to handle this error.

Please advice.

executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select (@@microsoftversion / 65536) / 256

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from master..sysdatabases where name = 'R3T'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'r3t'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from master..sysprocesses where dbid = db_id('R3T') and program_name like 'R3%' and uid = (select uid from R3T..sysusers where name = 'r3t')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select (@@microsoftversion / 65536) / 256

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''

DECLARE c CURSOR FOR

select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end

union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end

union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end

union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end

union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end

union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end

union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end

union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end

union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end

union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end

union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end

union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end

union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end

union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end

union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end

union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end

union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end

OPEN c FETCH NEXT FROM c INTO @n

WHILE @@FETCH_STATUS = 0

BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END

CLOSE c DEALLOCATE c select @ns

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select IS_SRVROLEMEMBER('sysadmin')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from master..sysdatabases where name = 'R3T'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'r3t'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'r3t'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T

declare @info nvarchar(2000)

declare @cs nvarchar(100)

declare @tmp nvarchar(200)

declare @rel nvarchar(100)

declare @patch nvarchar(100)

declare @sql nvarchar(2000)

declare schema_cursor cursor for

select name

from dbo.sysusers

where islogin = '1'

open schema_cursor

select @info = ''

fetch next from schema_cursor into @cs

while @@fetch_status = 0

begin

select @info = @info + @cs

select @info = @info + ':'

select @info = @info + cast(count(*) as varchar(20)) from sysobjects where uid = user_id(@cs) and name not in ('dtproperties')

select @info = @info + ':'

select @info = @info + cast(count(*) as varchar(20)) from sysobjects where uid = user_id(@cs) and type = 'U' and name not in ('dtproperties')

if exists(select * from sysobjects where name = 'CVERS' and uid = user_id(@cs) and type = 'U')

begin

select @info = @info + ':1'

select @sql = 'select @rel = RELEASE, @patch = EXTRELEASE from ' + @cs + '.CVERS where COMPONENT = ''SAP_BASIS'''

exec sp_executesql @sql, N'@rel nvarchar(100) output, @patch nvarchar(100) output', @rel output, @patch output

select @info = @info + ':'

select @info = @info + @rel

select @info = @info + ':'

select @info = @info + @patch

end

else select @info = @info + ':0'

if exists(select * from sysobjects where name = 'BC_CVERS' and uid = user_id(@cs) and type = 'U')

begin

select @info = @info + ':1'

end

else select @info = @info + ':0'

select @info = @info + ';'

fetch next from schema_cursor into @cs

end

close schema_cursor

deallocate schema_cursor

select @info

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use [R3T] select count(*) from sysobjects where name like 'Y%' and type='P' and uid=user_id('r3t')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select count(*) from R3T..sysusers where name = 'SAPR3TDB'

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''

DECLARE c CURSOR FOR

select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end

union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end

union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end

union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end

union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end

union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end

union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end

union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end

union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end

union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end

union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end

union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end

union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end

union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end

union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end

union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end

union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end

OPEN c FETCH NEXT FROM c INTO @n

WHILE @@FETCH_STATUS = 0

BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END

CLOSE c DEALLOCATE c select @ns

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select IS_SRVROLEMEMBER('sysadmin')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


DECLARE @n NVARCHAR(4000) DECLARE @ns NVARCHAR(4000) SET @ns = ''

DECLARE c CURSOR FOR

select case when serverproperty('Collation') is NULL then '' else convert(sysname, serverproperty('Collation')) end

union all select case when serverproperty('Edition') is NULL then '' else convert(sysname, serverproperty('Edition')) end

union all select case when serverproperty('InstanceName') is NULL then '' else convert(sysname, serverproperty('InstanceName')) end

union all select case when serverproperty('IsClustered') is NULL then '' else convert(sysname, serverproperty('IsClustered')) end

union all select case when serverproperty('IsFullTextInstalled') is NULL then '' else convert(sysname, serverproperty('IsFullTextInstalled')) end

union all select case when serverproperty('IsIntegratedSecurityOnly') is NULL then '' else convert(sysname, serverproperty('IsIntegratedSecurityOnly')) end

union all select case when serverproperty('IsSingleUser') is NULL then '' else convert(sysname, serverproperty('IsSingleUser')) end

union all select case when serverproperty('IsSyncWithBackup') is NULL then '' else convert(sysname, serverproperty('IsSyncWithBackup')) end

union all select case when serverproperty('MachineName') is NULL then '' else convert(sysname, serverproperty('MachineName')) end

union all select case when serverproperty('NumLicenses') is NULL then '' else convert(sysname, serverproperty('NumLicenses')) end

union all select case when serverproperty('ProcessID') is NULL then '' else convert(sysname, serverproperty('ProcessID')) end

union all select case when serverproperty('ProductVersion') is NULL then '' else convert(sysname, serverproperty('ProductVersion')) end

union all select case when serverproperty('ProductLevel') is NULL then '' else convert(sysname, serverproperty('ProductLevel')) end

union all select case when serverproperty('ServerName') is NULL then '' else convert(sysname, serverproperty('ServerName')) end

union all select case when serverproperty('Release') is NULL then '' else convert(sysname, serverproperty('Release')) end

union all select case when serverproperty('Patch') is NULL then '' else convert(sysname, serverproperty('Patch')) end

union all select case when serverproperty('IsSysAdmin') is NULL then '' else convert(sysname, serverproperty('IsSysAdmin')) end

OPEN c FETCH NEXT FROM c INTO @n

WHILE @@FETCH_STATUS = 0

BEGIN set @ns = @ns + @n + ';' FETCH NEXT FROM c INTO @n END

CLOSE c DEALLOCATE c select @ns

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


select IS_SRVROLEMEMBER('sysadmin')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


exec sp_configure 'show advanced options', 1

reconfigure with override

exec sp_configure 'xp_cmdshell', 1

reconfigure with override

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


exec sp_dbcmptlevel 'R3T', 90

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T select count(*) from sysobjects where type = 'P' and uid = user_id('r3t')

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T

declare @name sysname

declare allnames cursor for

select name from sysobjects

where type = 'P'

and (name like 'Y%' or name like 'SAP%')

and uid = user_id('r3t')

open allnames

fetch next from allnames into @name

while (@@fetch_status =0)

begin

exec ('drop procedure [r3t].[' + @name + ']')

fetch next from allnames into @name

end

close allnames

deallocate allnames

-


[Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to fetch logical page (6:78) in database 5 failed. It belongs to allocation unit 71905451171905536 not to 281474979397632.

-


executeSQL is called with following parameters:

Server: cacgcbcrr518

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use R3T select count(*) from sysobjects where type = 'P' and uid = user_id('r3t')

-


executeSQL is called with following parameters: