KampData Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

======Unknown error number 54 / SQL #515 /ODBC error: 23000======

This is a SQL error that occurs when an attempt is made to insert a record into a SQL table that would result in duplicating one of the table's unique keys. SQL does not allow this to occur and throws this error.

This error has occurred under certain circumstances when printing [[dynamiczip:reports:DynamicZip Tax Reports]]. All known occurances have been fixed in our latest builds. If you experience this error, please see [[dynamiczip:faq:identifying_documents_that_cause_reporting_errors|Identifying Documents That Cause Reporting Errors]] to begin correcting the problem.

To work around this error:

  - Open the [[dynamiczip:windows:dz_reports_window|DZ Reports window]] and choose your report. 
  - Click Modify to open the [[dynamiczip:windows:DZ Report Options window]].
  - Clear the SQL optimized check box and save your changes.

There will be no difference in your reports, the only difference is that when this option is selected, Microsoft SQL Server rather than the local workstation handles the report generation process. 

----

[[dynamiczip:faq:Frequently Asked Questions|FAQ]] \\
[[dynamiczip:glossary:Glossary]]