==== Error Message (in Control) ====



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



==== Error Message (in SQL Server) ====



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.



==== Severity ====



Moderate. The chance for data loss is Moderate.



==== Explanation of Error ====



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



==== Resolution ====



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**



[[code_formatsql]]



SELECT COUNT(ID) AS CNT



FROM GLAccount



GROUP BY ID



Order BY CNT



[[code]]



====== See Also ======
  * Backlinks [[include_pagepage_componentbacklinks]]