Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Description of Issue

ReadyForms deployment in Tyler Deploy is failing on 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).

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.





  • No labels