Increase the Synergize Database Field Length for a Parent or Child Field

Use this article to increase the database field length for Synergize fields. Repeat all the steps below every time you edit a database field.

  1. Backup your repository database.

  2. Make sure all users are disconnected from Synergize.

  3. In SQL Management Studio, click Tools, Options.

    Graphical user interface, text, application Description automatically generated

  4. Expand Designers. Uncheck Prevent saving changes that require table re-creation. Click OK.

  5. Determine if the field is a parent or child field:

    1. Launch EMC.

    2. Navigate to Tenants, Repositories, and expand your repository node.

    3. Click Fields:

      • If your field is in the list, it is a parent field.

      • If your field is not in the list, it is a child field.

  6. Continue with the steps below for your parent or child field.

In this example, we want to increase the firstname field limit from 5 to 255 characters.

 

  1. Connect to Repository DataBase through SQL. In this example, we connect to the AP Repository DB.

    Graphical user interface, table Description automatically generated

  2. Right-click the dbo.FieldsDesc table and choose Edit Top 200 Rows.

  3. Look for firstname under the In_FieldName column.

    A picture containing graphical user interface Description automatically generated

  4. Increase the field length from 5 to 255 under In_FieldLength (Firstname is my example field in this scenario).

  5. Click File, Save All.

  6. Navigate to main table, right-click and click Design.

  7. Look for firstname, under Column properties, increase the length property from 5 to 255 (Firstname is my example field in this scenario).

  8. Close EMC and reset IIS.

  9. To reset IIS, open a command prompt, type iisreset and press Enter.

  10. Relaunch EMC to verify your changes.

  11. If you are using SPS, stop all process and restart SPS service.

  1. Navigate to FieldsDesc table, right-click and click Edit top 200 rows.

  2. Look for your field name and increase the value (In this example, I am increasing probill number from 5 to 255)

  3. Navigate to Billno (In this case, Billno is my schema under EMC) table, right-click and click Design

  4. Look for probillnumber.

  5. Change value to varchar(255) under Data Type, click File Save All.

  6. Close EMC and reset IIS

  7. To reset IIS, Open CMD, Type iisreset and press Enter

  8. Relaunch EMC.

  9. If you are increasing the field character limit for a child field:

    1. In EMC, navigate to Tenants, Repositories, expand your Repository Node.

    2. Click Schema, and double-click last one in the list and verify if you can see the child field you want to modify.