"VALUES" error when generating a Z-report or X-report

What the «VALUES» error means in Z-/X reports

The «VALUES» error when generating or viewing a Z report / X report indicates a critical incompatibility between Torgsoft and the outdated SQL Server 2005. In this state, the Z report / X report cannot be printed from Torgsoft or opened for viewing.

When it occurs

• After updating Torgsoft (to the stable version 2022.0.48 or to the beta version 2022.4.7 and later)

• When trying to:

• close the cash register day on a software ECR (Generate the Z report)

• view the X report or a previously created Z report

• Always — if the database is running on SQL Server 2005

How it looks: symptoms and error text

• Unable to generate or open the Z report / X report for viewing

A message appears:
[FireDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]

Неправильный синтаксис около ключевого слова "VALUES"

• Work with the Z report / X report on the software ECR in Torgsoft is blocked

Why it happens: cause and compatibility context

1. Outdated DBMS (SQL Server 2005)
   SQL Server 2005 does not support modern SQL syntax used in current versions of Torgsoft.

2. Updated fiscal reporting logic
   After changes in requirements for fiscal receipts and reports, the program uses more complex SQL queries that are incompatible with the old engine.

3. SQL Server 2005 Express limitations

•    Maximum database size — 4 GB

•    High risk of errors when working with reports and large tables

How to fix it: SQL Server upgrade (step-by-step)

 The only correct solution — upgrade SQL Server

Basic workflow

1. Create a backup (archive) of the database

2. Detach the database from SQL Server 2005

3. Upgrade SQL Server 2005 on the PC to SQL Server 2008/2014 or later. Or remove SQL Server 2005 entirely and install SQL Server 2008/2014 or later

4. Attach the database to the upgraded/new SQL Server instance

5. If needed, change the database connection address in Torgsoft

6. Check Z and X report generation in Torgsoft

Operating system limitations (IMPORTANT)

• SQL Server 2014 cannot be installed on outdated operating systems
  (for example, Windows XP, Windows Server 2008 without updates)

• If the OS is outdated:

• you need to upgrade Windows, or

• temporarily use SQL Server 2008 as a compromise solution

Technical notes for administrators (rare cases)

After upgrading SQL Server, you may need to install or update the component
SQL Server Native Client 11.0 so that Torgsoft can connect to the database correctly.

If the error did not disappear after migration

For an administrator or technical support:

• Check the database Compatibility Level in SQL Server Management Studio

• If the compatibility level remains 90 (SQL Server 2005) — change it to:

• 100 — for SQL Server 2008

• 120 — for SQL Server 2014

An incorrect Compatibility Level can cause errors even after upgrading SQL Server.

Verification: how to confirm the issue is resolved

• The Z report is generated without errors

• The X report opens correctly

• The VALUES message no longer appears

Prevention: how to avoid recurrence

• Do not use SQL Server 2005 with current versions of Torgsoft

• Plan SQL Server upgrades together with program updates

• Consider OS compatibility before upgrading the server

• Using SQL Server 2005 in 2026 carries additional risks due to the lack of security updates

Summary: decision rule

If a “VALUES” error appears in the Z or X report → the database runs on SQL Server 2005 → you need to upgrade SQL Server (2008 / 2014), taking into account the OS and compatibility level.