[SOLVED] SQL error on upgrade to 9.5: Cannot create a row

Availability for the Always-On Enterprise

[SOLVED] SQL error on upgrade to 9.5: Cannot create a row

Veeam Logoby obroni » Wed Nov 23, 2016 1:31 pm

Hi All,

I had an issue upgrading v9 to v9.5 yesterday where the install error out with a SQL error "Cannot create a row of size 8067 which is greater than the allowable maximum row size of 8060".

This is now fixed, but posting for the benefit of others.

After looking through the database which was Full 2008 R2 at the time, I could see that the Backup.Model.OIBs table had a column aux_data which was a very large XML type. From what I understand this shouldn't be a problem as SQL 2005+ should support row overflow for certain data types, including XML columns. In the end I uninstalled Veeam completely, reinstalled Veeam with the local 2012 SQL express, restored config backup and then finally upgraded to v9.5. The fact that this worked, I can only guess there might be some limitation in SQL 2008??? But one to possibly be aware of.

Log from setup below:
Code: Select all
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] IF EXISTS (SELECT 1 FROM [dbo].[Version] WHERE current_version >= 3441 AND current_version < 3442)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] BEGIN
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] IF NOT EXISTS (SELECT * FROM syscolumns WHERE id = OBJECT_ID(N'[dbo].[Backup.Model.OIBs]') and [name] = N'creation_usn')
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] BEGIN
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] ALTER TABLE [dbo].[Backup.Model.OIBs] ADD [creation_usn] bigint NOT NULL DEFAULT 0
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] PRINT 'New column {creation_usn} has been successfully added to [dbo].[Backup.Model.OIBs]'
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] EXEC [dbo].[CreateNonClusteredIndex] N'Backup.Model.OIBs', N'creation_usn'
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] END
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] IF @@Error = 0 BEGIN UPDATE [dbo].[Version] SET current_version = 3442; END
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] END
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] GO
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] ExecuteNonQuery failed for Database 'Veeam2Backup'.  (Microsoft.SqlServer.Management.Smo.FailedOperationException)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Veeam.Backup.DBCreator.DatabaseQueryExecutor.Execute(String text, Object[] args)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Veeam.Backup.DBCreator.DatabaseScriptExecutor.Execute(String path, OnStatementExecute statementExecute)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Veeam.Backup.DBCreator.DatabaseFileExecutor.ExecuteEscalation(DatabaseVersionType contentType)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Veeam.Backup.DBCreator.DatabaseFileExecutor.Execute(DatabaseScriptType type)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Management.Common.ExecutionFailureException)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR]    at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] Cannot create a row of size 8067 which is greater than the allowable maximum row size of 8060.
***Veeam***  SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] The statement has been terminated. (System.Data.SqlClient.SqlException)
obroni
Service Provider
 
Posts: 86
Liked: 10 times
Joined: Fri Nov 21, 2014 10:50 pm
Full Name: Nick Fisk

Re: [SOLVED] SQL error on upgrade to 9.5: Cannot create a ro

Veeam Logoby davidhaycox » Tue Dec 06, 2016 3:23 pm 1 person likes this post

Just had the same problem upgrading from 9.0 to 9.5. This had previously been upgraded from earlier versions and so had a SQL 2008 database. Was able to resolve as follows:

1. Uninstall Veeam (did not delete any folders)
2. Reboot
3. Install Veeam 9.5 including SQL 2012 Express
4. Restore configuration backup
5. Remove SQL 2008 database and instance (optional)

In other words, the same as the previous answer but it was not necessary to install 9.0 then upgrade it; simply installing 9.5 and restoring the configuration was sufficient.
davidhaycox
Lurker
 
Posts: 1
Liked: 1 time
Joined: Tue Dec 06, 2016 3:12 pm
Full Name: David Haycox


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot] and 35 guests