Hi,
I have looked at other posts on the site regarding 9523 errors during upgrade and not found the best way to proceed so wondering if anyone has seen something similar and managed to resolve:
We upgraded from LF 9.21 server to LF 10.4 - everything went OK until registering the repository when we got the 9523 error.
Examining the logs reveals several SQL schema errors so I assume the upgrade has failed and will not resolve itsel if we wait. (In fact I had to roll back as this is a production environment).
The repository is reasonably large (450GB Volume, 8GB database)
Key errors in database are
There was an error executing an SQL script. File C:\Program Files\Laserfiche\Server\sql\ms-upg70.sql, line 338: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x93601cf3; actual: 0x9b601cf3). It occurred during a read of page (1:752955) in database ID 7 at offset 0x0000016fa76000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL14.APMSQL3\MSSQL\DATA\LF.mdf'. Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.. Command: "if not exists (
select * from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 'propval'
and COLUMN_NAME = 'pos2')
begin
ALTER TABLE propval ADD pos2 smallint default 0 not null
end".
and
An error occurred when executing an SQL query, retrieving the results of a query, or otherwise communicating with the database server. Session ID=0; Dialog ID=0; Repository="APM"; Function=SysRepMount; Message="[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x93601cf3; actual: 0x9b601cf3). It occurred during a read of page (1:752955) in database ID 7 at offset 0x0000016fa76000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL14.APMSQL3\MSSQL\DATA\LF.mdf'. Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online."; Statement="if not exists (
select * from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 'propval'
and COLUMN_NAME = 'pos2')
begin
ALTER TABLE propval ADD pos2 smallint default 0 not null
end"; SQL Variable=""; SQL State="HY000".
Is there a recommended way to proceed when we next attempt this? Given the size of the repository it is very difficult to organise a test in another environment. Time didn't allow running DBCC and we don't have a copy of the corrupted database to try it on. Has nyone successfully resolved from this situation?
Thank you,
Ian