1. NiceLabel Help Center
  2. LPS Conversion Service
  3. Conversion error messages

LMS-6549

MESSAGE

The SQL statement for database data source {dataSetName} could not be converted properly. It has to be resolved manually.

SEVERITY

Danger

DETAILS

The Converter cannot successfully convert the SQL query used in the label template.

The Conversion Service runs on a server outside of the customer's environment. The database sources referenced in the label template are therefore not accessible. Additionally, that type of database connection (e.g. respective ODBC driver) might not be configured on the server at all - especially when some older or proprietary connections are used.

6549_SqlQuery.png

you have to accomplish two tasks here: (1) reconfigure connection to the database and (2) update the SQL query.

RESOLUTION

The converted label will contain the database connection, but you will have to modify it yourself to make it work.

  1. Make sure you have a database driver installed and configured on your computer (for the database type used in the label template).

  2. Make sure you have access to the database source and re-configure the connection to the database.

    Note

    This step can be difficult to achieve when the label template uses some server-based database (e.g. MSSQL or PostgreSQL) to which you do not have access.

    1. In Data source explorer pane, navigate to Databases section.

    2. Find the affected database item by the red exclamation sign in front of its name.

    3. Double-click the database item to open its definition.

      6549_DoubleClickDatabase.png

    4. Follow the on-screen prompts/features to connect to the database.

      6549_ConnectToDatabase.png

      1. If you have the correct database driver installed and the database is available in the referenced location, you can click the Connect button.

      2. However, in most cases, you will have to go through the whole Connection Setup from scratch.

  3. Once you have a connection to the database established, you can recreate the custom SQL statement (query) in NiceLabel Designer.

    Note

    The Converter will copy the SQL statement used in the original LWL label, but that can be LLM-specific and might not work in NiceLabel.

    6549_UpdateSqlQuery.png

Also, see this topic.