Observability

"Roll back the transaction. dbm_EnsureMEObjects Conversion failed when converting the varchar value 'All parameters: @table_name: ' to data type int." error in Configuration Wizard during upgrade to 2025.2

The Configuration Wizard fails with an error at 4.8%, during Database Configuration.

First published date

6/17/2025 5:49 PM

Last published date

7/15/2025 3:49 PM

Overview

During an upgrade to 2025.2 from 2025.1 or 2025.1.1, the Configuration Wizard fails with an error message. The log can be found at C:\ProgramData\SolarWinds\Logs\Orion\ConfigurationWizard.log.

 ERROR TaskAdapter - Error running task Orion.ConfigureDatabase SolarWinds Platform Database
System.Data.SqlClient.SqlException (0x80131904): The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
dbm_EnsureMEObjects: Conversion failed when converting the varchar value 'All parameters: @table_name: ' to data type int.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

Product section

Hybrid Cloud Observability

Cause

Unknown, still under investigation.

It is unclear why CW failed and was not able to downgrade following db.entities tables automatically:

  • Cloud_Azure_LoadBalancerPoll_rel_1

  • Cloud_Azure_LoadBalancerStatus_poll_1

  • Cloud_Azure_SqlDatabasePoll_rel_1

 

Resolution

Workaround:

Please make sure you have a backup of the database before performing the steps below. SolarWinds recommends working with your DBA in doing the steps. They need to be done in the SQL Server/DB.

1. Drop the following tables:

Cloud_Azure_LoadBalancerPoll_rel_1
Cloud_Azure_LoadBalancerStatus_Poll_1
Cloud_Azure_SQLDatabasePoll_rel_1

2. Re-create the tables by:

exec dbm_EnsureMEObjects

3. Run Configuration Wizard