[CONTINUUM-2100] Unable to import data that includes installations

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.3.1, 1.3.1 (Alpha)
• Fix Version/s: 1.3.3 (Beta)
• Component/s: Data Management
• Assignee: Maria Catherine R. Tan
• Reporter: Wendy Smoak
• Created: 27/Feb/09 14:06
• Updated: 09/Dec/09 12:45
• Resolved: 28/Mar/09 00:18

Description

When importing builds.xml data into 1.3.1, I get the following error:

ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'INSTALLATION_PK' defined on 'INSTALLATION'.

To reproduce, create a 'backups' directory, save the attached builds.xml file into it, and execute:

java -Xmx512m -jar data-management-cli-1.3.1-app.jar -buildsJdbcUrl jdbc:derby:/path/to/apache-continuum-1.3.1/data/databases/continuum/ -mode IMPORT -directory backups

The attached builds.xml was exported from a Continuum 1.2 instance using data-management 1.2.3.1.

If you edit builds.xml and delete the <installations> ... </installations> then the import will complete without error.

Issue Links

• is duplicated by: CONTINUUM-1912 Unable to import data to new version
• is related to: CONTINUUM-2323 Duplicate entry error during database migration from 1.2.2 to 1.3.3
• relates to: CONTINUUM-2408 Unable to import data that includes installations