User Tools

Site Tools


dynamiczip:faq:unknown_error_number54

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 Tax Reports. All known occurances have been fixed in our latest builds. If you experience this error, please see Identifying Documents That Cause Reporting Errors to begin correcting the problem.

To work around this error:

  1. Open the DZ Reports window and choose your report.
  2. Click Modify to open the DZ Report Options window.
  3. 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.


FAQ
Glossary

dynamiczip/faq/unknown_error_number54.txt · Last modified: 2019/03/20 18:01 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki