Troubleshooting: Data Precision Enhancement Tool - Metasys - LIT-12012254 - Software Application - Metasys Database Manager - 13.0

Database Tools Commissioning Guide

Product
Building Automation Systems > Databases and Data Servers > Metasys Database Manager
Document type
Commissioning Guide
Document number
LIT-12012254
Version
13.0
Revision date
2023-10-13
Product status
Active

Error or Error Message

Solution

The Convert to float button is disabled.

The following scenarios could cause the Convert to float button to disable:

The tool was started with a database that is already converted: If the database is already converted, you do not need to run the tool. Click Exit to exit the tool.

There is not enough free disk space available: The conversion process could damage the database if there is not enough free disk space. Click Exit to exit the tool. Using Windows Explorer, manually ensure there is enough disk space available. When you determine there is enough disk space to proceed with the database conversion, start the process in Running the Data Precision Enhancement Tool again.

An error has been detected: Click Show log to show error details and resolve the error. When you have resolved the error, you may continue with the database conversion.

The Status field is red and displays the following message:

Not enough free disk space...

There is not enough free disk space to convert the database. The Status field lists the estimated value for the assumed required disk space. Click Exit to exit the tool. Using Windows Explorer, manually ensure there is enough disk space available. When you determine there is enough disk space to proceed with the database conversion, start the process in Running the Data Precision Enhancement Tool again.

The Status field is red and displays the following message:

SQL Express database too big for conversion. Maximum supported size for mdf: < 5 GB

The database you are converting is too large. You must change the database from SQL Express to SQL Server and detach the database from SQL Express and attach it to the SQL Server.

You receive a MPI - Warning/Hint dialog box after you attempt to convert the database.

Figure 1. MPI - Warning/Hint Dialog Box

The tool requires permission to read the free disk space information.

To resolve this problem:

  1. Click Change credentials. The Change Credential window appears.
    Figure 2. Change Credential Window

  2. Select the Use Windows credentials for authentication check box if you want to use Windows® credentials to read the free disk space information.

    Do not select the Use Windows credentials for authentication check box if you want to use the SQL Server authentication with user id and password.

  3. Enter an applicable user name and password based on Step 3 in the Change Credential window.
  4. Click Read free disk space. The database conversion continues if there is enough free disk space to continue.
    Note: We strongly recommend that you not click Convert to float on the MPI - Warning/Hint dialog box. Performing the database conversion without the necessary free disk space could damage the database.

The Status field is green and displays the following message:

Data Type float already exists in database analog tables

The database is already converted. You do not need to run the tool. Click Exit to exit the tool.