Versions Compared

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

Cannot insert duplicate key in object 'dbo.DocumentGenerationTemplates'. The duplicate key value is (2024 W2 Print)


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • ReadyForms
  • RF
  • Tyler Deploy
  • Deployment
  • Failure
  • Step 9
  • TDD
  • TDD
  • Enterprise Forms Templates
  • Year End


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

This happens when ReadyForms is trying to push out 2022 or 2023 year-end specific templates, but they already existone already exists with the same name. Someone may have manually created templates by copying a previous year's template.

Year-end templates are generated by installing the latest release of ReadyForms. Users should NOT attempt to manually create the standard year end templates as this will cause conflicts


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

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

  1. Log into ReadyForms AdministrationForms Administration with an account that has permissions to delete templates
    1. If there is a failed deployment and you cannot access Enterprise Forms Administration due to 400 Bad Request Your request resulted in an error, please contact Tyler Systems Management Support or log a case via the Online Support Client Portal
  2. Find the template listed in the TDD error
    1. Hover over the template name and click the trashcan icon to delete it
    .
  3. Delete any templates marked as 2022 xxxx PCL,2021Standard with mismatching years in the template name and layout
    1. Ex: 2024 W2 Archive, 2023Standard Layout
    2. There likely will may be multiple templates that will cause an issue. Check all Review Payroll 1099 and W2 templates, as well as Accounts Payable 1099 year end templates. See below Additional Information for examples.
  4. ReOnce mismatched templates are deleted, re-run the deployment.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

Payroll

  • Review various Payroll sections
    • Payroll W-2
- Archive, Email, PrintSystem.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
,
    • Payroll 1095-C
    • Payroll 1099-R
  • Possible template sub types: 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.
        • Ex: 2024 W2 Archive, 2024 W2 Email, and 2024 W2 Print
      • Delete templates with mismatched years in name and layout 
        • Ex: 2024 W2 Email PDF,2023Standard Layout


      Accounts Payable

      • Review various Accounts Payable 1099 sections
        • 1099-G
        • 1099-INT
        • 1099-MISC
        • 1099-NEC
        • 1099-S
      • Possible template sub types: Archive, Print
        • Ex: 2024 1099-G Archive and 2024 1099-G Print
      • Delete templates with mismatched years in name and layout
        • Ex: 2024 1099-G Archive PDF,2023Standard Layout