Hi,
I encountered an issue while upgrading LF 10.2 to 10.3.1 which Laserfiche support fixed it through our VAR, the issue was when LF upgrade process reached database upgrade it just kept running forever.
This is the version of SQL server I was running:
Microsoft SQL Server 2008 (SP4-GDR) (KB4057114) - 10.0.6556.0 (X64) Dec 28 2017 15:21:01 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)
And this is the error on Laserfiche-ContentRepository-Service/Admin logs :
Error - Event ID: 132
.
.
.
E:\Program Files\Laserfiche\Server\sql\ms-upg90.sql
92
if not exists (
select * from sys.spatial_indexes
where [object_id] = OBJECT_ID(N'tocgeo')
and name = 'tocgeo_geo1_ix')
begin
create spatial index tocgeo_geo1_ix on tocgeo (geo1)
end
[Microsoft][SQL Native Client][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with spatial index operations.
And Laserfiche support ask me to do the following which fixed the issue:
"In SQL Server Management Studio right click on the SQL instance that hosts the Laserfiche database and select Properties. Go to Connections and make sure that ansi warnings, ansi padding and arithmetic abort are checked under Default connection options. Once that has been done, restart the LF Server service."
My question: I am now in process of migrating to new Laserfiche Server and I am going to use SQL Server 2017, should I do the steps support provided "Ansi warnings, ansi padding and arithmetic abort are checked under Default connection options" or the issue was specific from SQL 2008?
--------
update: I asked our VAR and he suggested not to change the default SQL server settings unless I get a similar issue with going next maintenance release, will I don't believe this is the right answer and I will change the default to as support request and have Ansi warnings, ansi padding and arithmetic abort are checked under Default connection options.