Collision Resolving Rules

Collision case 1

A pack contains a record X that references a record Y. The record Y does not exist on the target instance and is not included into the retrieved pack. When loading a VCS record, the following information appears in the Message column of the VCS Preview Log:

Reference {sys_id} in {column_name} does not exists in referenced table {reference_table_name}

Solution:

• Add the record Y to this configuration pack on the source instance.
  
  OR

• Leave the record Skipped in the VCS Preview Log.

Collision case 2

A pack contains a record version X for deleting from the system. But there is a reference to this record in the configuration pack or on the instance. When loading a VCS record, the following information appears in the Message column of the VCS Preview Log:

{column_name} column in {reference_table_name} table referenced on this record;

Solution:

• Leave the X record version Skipped in the VCS Preview Log.

Collision case 3

The set of fields mismatches when importing a pack.

Details:

The Scheduled scripts table on the source instance contains N fields. The Scheduled scripts table on the target instance contains N-1 fields (see the scheme below). When loading a VCS record, the following information appears in the Message column of the VCS Preview Log:

Column "c_typical" related to "sys_schedule_script" does not exist.

Solution:

• Continue import with the Warning state. In this case, the column c_typical will not be created, and the imported version will have the N-1 of key-value pairs in the JSON copy field.

OR

• Import the lacking c_typical column into the target instance. Then reload the initial local pack.
  
  OR
  
  
• If the absence of a particular field was expected:
  1.  Open the record from the VCS Preview Log.
  2.  In the Retrieved Records related list, click the record to open it.
  3.  Remove the key-value pair for the c_typical column from the JSON copy field.
  4. Save the record and click Prepare for import.

Collision case 4

A record version on the target instance is newer than the one in the configuration pack. You can determine it by the date and time stated in the value of the sys_updated_at key in the JSON copy field. The record versions that are older than the ones in the system will be in the Skipped state. When loading a VCS record, the following information appears in the Message column of the VCS Preview Log:

The system has a newer record

Solution:

• Change the state to Good to update the record versions from the configuration pack.

OR

• Leave the Skipped state unchanged in the VCS Preview Log.

Collision case 5

A configuration pack contains a table that should be deleted. The same table on the target instance contains some records. When loading a VCS record, the following information appears in the Message column of the VCS Preview Log:

Table is not empty

Solution:

• Change the state to Good. In this case, the table and all records will be deleted.

OR

• Leave the Skipped state unchanged in the VCS Preview Log. 

Collision case 6

A configuration pack contains a version of the application X. The target instance does not have this application installed. When loading the pack, the following information appears in the Message column of the VCS Preview Log:

Related application "{application_id}" does not exist. Please repack this pack on the source instance

Solution:

1. Export a version of the sys_application from the source instance.
2. Import it to the target instance.
3. Reload the pack with the application X versions again. To do so, click Load again on the Retrieved Pack form.

Collision case 7

A unique key violation causes a collision.

Details:

1. The imported configuration pack contains a record X₁ from a table with a SQL unique constraint.
2. The target instance contains the same record with a different ID, this is the record X₂. In other words, these two records have identical field values except the ID.
3. When loading the pack to the target instance, the following information appears in the Message column of the VCS Preview Log:

This record has a duplication of a unique key. DETAIL: Key (column_id, record_id, language_id)=(156941403909472422, 159170696512371798, 156628684306200767)

Solution:

• Delete the record X₂ on the target instance and click Reload pack.

OR

• Leave the Skipped state unchanged for the record X₁ in the VCS Preview Log. 

Collision case 8

The column to be inserted exists on some level of inheritance.

Details:

The target instance has a table X and its child table Y. The table Y inherits columns of the table X. These columns belong to the table X (See the Table Extension article to learn more). The pack has a VCS record, which inserts column A to table Y. At the same time, the parent table X already has the same column A. When loading a pack, the following information appears in the Message column of the VCS Preview Log:

A record for column A already created in the table X.

Solution:

Set the Skipped state for the record X. 

Collision case 9

An imported column contains a reference to a table that does not exist on the target instance. The configuration pack also does not contain a record of the table. When loading a pack, the following information appears in the Message column of the VCS Preview Log:

Trying to get property 'name' of non-object

Solution:

Import a pack with a version of the table, and then reload the configuration pack with that column. 

Collision case 10

It is impossible to import a record, if its Protection policy is Protected.

When loading a pack, the following information appears in the Message column of the VCS Preview Log:

Don't update, policy is protected

Solution:

The solution depends on the Protection policy that the target record should have after the pack is loaded.

• To import a record without changing its policy, do the following:

1. In the VCS Preview Log, open the necessary record.

2. In the related list of the form that opens, click the record in the Retrieved Record tab.

3. Change the Protection policy to Protected.

4. Click Prepare changes on the top right of the form.

As a result, the Message value for the record version in the VCS Preview Log has changed.

• To import record versions with a change of the Protection policy, do the following:

1. On the source instance, open the VCS record that caused the collision and select the Is strong override checkbox.

2. Export the local pack with the updated record version and import it to the target instance. 

Collision case 11

A VCS record on the target instance has been changed (Protection policy = Changed). When loading a pack, the following information appears in the Message column of the VCS Preview Log:

Don't update, record is changed 

Solution:

1. In the VCS Preview Log of the imported pack, open the necessary record.
2. In the Current version related list, there is a record. Open it.
3. Study the values of the JSON Copy, Local pack and Created by fields.
4. If this record version should be imported, change the record state to Good in the VCS Preview Log.