https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IyODg0IiwiaGFzaCI6IjQ5Y2Q4NzExLTU5MTAtNDNjMi1iNjM1LTk4OTI2NDg2MTU0MyJ9
1-800-691-1991 | 9am - 8pm ET
EN

Veeam Backup & Replication upgrade fails with an error "Database version downgrade detected ... Reboot and restart the setup"

Challenge

The upgrade to Veeam Backup & Replication U4 fails with "Database version downgrade detected ... Reboot and restart the setup". You may find following error in the C:\ProgramData\Veeam\Setup\Temp\BackupSrvLog.log:

***Veeam***  SRV: [31.01.2019 11:39:43]:<00000001> [VEEAM] Database version has been incremented to <5186>
***Veeam***  SRV: [31.01.2019 11:39:43]:<00000001> [VEEAM] Executing version command (ContentType=[Schema], Version=<5186>)
***Veeam***  SRV: [31.01.2019 11:39:43]:<00000001> [VEEAM] Adding trusted hosts (InitialCatalog=[VeeamBackup], DatabaseVersion=<5186>)
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] declare @id uniqueidentifier;
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] set @id = '52107791-e0ff-4538-a26e-4717962aef77';
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] declare @usn bigint;
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] exec IncrementUsn @usn output;
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] BEGIN
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] INSERT INTO [dbo].[Backup.Model.HostSshFingerprint]
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] (
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] [id], [network_name], [accepted_fingerprint], [current_fingerprint], [public_key], [agent_id], [network_name_hash], [last_update_time], [usn]
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] )
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] VALUES  
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] (
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] @id, '<IP Address>', '', '', '', '00000000-0000-0000-0000-000000000000', '', '<Day>/<Month>/Year <time>', @usn
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] )
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] END;
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM] [SQL|ERROR] GO
***Veeam***  SRV: [31.01.2019 11:39:44]:<00000001> [VEEAM|ERROR] Conversion failed when converting date and/or time from character string. (System.Data.SqlClient.SqlException)

Cause

This is a known issue in Veeam Backup & Replication 9.5 U4. There are 2 mandatory conditions for this issue to raise:
  1. System time format uses a.m. and p.m. (in small symbols with dots)
  2. Application-aware processing, or guest OS file indexing is enabled for a Linux machine.
Affected regional formats and countries are:

English (New Zealand)
Greek (Greece)
Maori (New Zealand)
Spanish (Argentina)
Spanish (Bolivia)
Spanish (Costa Rica)
Spanish (Honduras)
Spanish (Nicaragua)
Spanish (Peru)
Spanish (Puerto Rico)
Spanish (Paraguay)
Spanish (El Salvador)
Spanish (Bolivarian Republic of Venezuela)
Galician (Galician)
Guarani (Paraguay)
K'iche (Guatemala)
Quechua (Bolivia)
Quechua (Peru)
Romanian (Romania)

Solution

Note: This issue is now resolved in Update 4a. Please download the new Update ISO and install Update 4a instead of Update 4.
KB ID:
2884
Product:
Veeam Backup & Replication
Version:
9.5.4.2615
Published:
2019-01-31
Last Modified:
2020-08-13
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.

ty icon

Thank you!

We have received your request and our team will reach out to you shortly.

OK

error icon

Oops! Something went wrong.

Please go back try again later.