ReadyForms 2021 Deployment Failure on TDD Step - Cannot insert duplicate key in object dbo.DocumentGenerationTemplates

Owned by Knowledge Assistant
Last updated: Jan 26, 2024 by Moriah Yorkey
2 min read
Description of Issue

ReadyForms deployment in Tyler Deploy is failing on TDD step.

The step failed: Activity Build Out DB and run TDD - Readyforms on xxxxx failed with error 'The remote script failed with exit code 1'.

The error at the end of TDD log (found at the bottom of the deployment log under Output Files) shows something similar to this:

Violation of UNIQUE KEY constraint 'UQ_DocumentGenerationTemplates_Description'. Cannot insert duplicate key in object 'dbo.DocumentGenerationTemplates'. The duplicate key value is (2022 1099-INT Print).

Context

  • ReadyForms

  • RF

  • Tyler Deploy

  • Deployment

  • Failure

  • Step 9

  • TDD

Cause

This happens when ReadyForms is trying to push out 2022 or 2023 templates, but they already exist. 

Resolution

Remove the listed 2022/23 ReadyForms template listed in the TDD error

  1. Log into ReadyForms Administration

  2. Find the template listed in the TDD error and delete it.

  3. Delete any templates marked as 2022 xxxx PCL,2021Standard Layout

    1. There likely will be multiple templates that will cause an issue. Check all Payroll 1099 and W2 templates, as well as Accounts Payable 1099 templates. See below for examples.

  4. Re-run the deployment.

  5. In some circumstances the TDD will fail again and list another template. You may need to remove multiple 2022 ReadyForms templates in order to get the issue resolved.

Additional Information

W-2 - Archive, Email, Print

System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ_DocumentGenerationTemplates_Description'. Cannot insert duplicate key in object 'dbo.DocumentGenerationTemplates'. The duplicate key value is (2022 W2 Print)

  • Navigate to Payroll

  • Select Payroll W2

  • Delete templates marked as 2022 xxxx PCL,2021Standard Layout

1095-B,1095-C - Archive, Email, Print

System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ_DocumentGenerationTemplates_Description'. Cannot insert duplicate key in object 'dbo.DocumentGenerationTemplates'. The duplicate key value is (2022 1095-C Print).

System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ_DocumentGenerationTemplates_Description'. Cannot insert duplicate key in object 'dbo.DocumentGenerationTemplates'. The duplicate key value is (2022 1095-C Archive).

  • Navigate to Payroll

  • Select Payroll 1095-x

  • Delete templates marked as 2022 xxxx PCL,2021Standard Layout

1099-MISC, 1099-NEC, 1099-INT, 1099-G, 1099-S - Archive, Print

System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ_DocumentGenerationTemplates_Description'. Cannot insert duplicate key in object 'dbo.DocumentGenerationTemplates'. The duplicate key value is (2022 1099-MISC Print).

  • Navigate to Accounts Payable

  • Select Accounts Payable 1099-x

  • Delete templates marked as 2022 xxxx PCL,2021Standard Layout

If you need additional assistance please contact Tyler Systems Management Support or log a case via the Online Support Client Portal.

Â