TDM Portal not starting after upgrading from 4.10 to 4.11

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

TDM Portal not starting after upgrading from 4.10 to 4.11 and the TDMSchemaManagementStartup.log show the below error:

[ERROR] --- c.ca.tdm.schema.Main: Migration failed: 'DbMigrate.FlywayMigrateSqlException:
Migration V4.11.0.07__add_pii_setup_history_table.sql failed
------------------------------------------------------------
SQL State : 23000
Error Code : 515
Message : Cannot insert the value NULL into column 'ps_model_id', table 'gtrep.dbo.gtrep_pii_setup'; column does not allow nulls. UPDATE fails.
Location : db/migration/gtrep/sqlserver/V4.11.0.07__add_pii_setup_history_table.sql (C:\Path\CA\CA Test Data Manager Portal\schema-management\file:\C:\Path\CA\CA Test Data Manager Portal\schema-management\lib\TDMGtrepSchema-4.11.54.0.jar!\db\migration\gtrep\sqlserver\V4.11.0.07__add_pii_setup_history_table.sql)
Line : 65
Statement : ALTER TABLE gtrep_pii_setup ALTER COLUMN ps_model_id numeric(19, 0) not null;

, SQLServerException: Cannot insert the value NULL into column 'ps_model_id', table 'gtrep.dbo.gtrep_pii_setup'; column does not allow nulls. UPDATE fails.'
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'ps_model_id', table 'gtrep.dbo.gtrep_pii_setup'; column does not allow nulls. UPDATE fails.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)

Environment

TDM 4.11.x

Cause

'ps_model_id' column in table 'gtrep.dbo.gtrep_pii_setup' is missing and caused the issue.

Resolution

 Take a back of the table gtrep_pii_setup and truncate it. Then start the TDM Portal and shouldn't face the issue.