Database Connector Error: '[Database Vendor Code: 8153 ]'

Msg 512, Level 16, State 1, Line 22

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, = or when the subquery is used as an expression.

Warning: Null value is eliminated by an aggregate or other SET operation.

• This error is received when trying to run the report SQL query in SQL Server.

Moderate. The chance for data loss is Moderate.

This error was discovered when previewing a report in Control. This issue was caused by duplicate IDs in the GLAccount Table.

The following steps should only be performed after all other troubleshooting steps have been taken:

- IMPORTANT - Backup the database before you take any further steps!

- Reference internal ticket 210107.

- Use SQL Query 1 (below) to determine if there are duplicate IDs in the GLAccount table.

- If there are duplicate IDs, the manually entered GL Accounts will need to be re-sequenced. The GLAccountIDs in the Ledger Table that use the IDs you are re-sequencing will need to be updated with the new IDs as well. See the update statements in internal ticket 210107.

SQL Query 1

SELECT COUNT(ID) AS CNT
FROM GLAccount
GROUP BY ID
ORDER BY CNT