Versions Compared

Old Version 2

changes.mady.by.user Knowledge Assistant

Saved on

compared with

New Version Current

changes.mady.by.user Moriah Yorkey

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

ReadyForms deployment in Tyler Deploy is failing on TDD step 9.

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).

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext

  • ReadyForms

  • RF

  • Tyler Deploy

  • Deployment

  • Failure

  • Step 9

  • TDD

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

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

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

Remove the listed 2022 ReadyForm /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.

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional 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.

...