2271654 - Check In cancelled due to SQL Errors; Check In fails during Check Out of repository model - SAP PD

• We upgraded from SAP PowerDesigner (PD) 16.1 to SAP PowerDesigner 16.5 SP5 PL02. Our repository has a defined folder and branch hierarchy. We Check Out a physical data model (PDM) which is updated from 16.1.0.3805 to 16.5.5.4770. The model check out completes without issue. We make several changes to the model and attempt to check it back into the repository. PD starts Checking out the repoository copy of the model to compare\merge. During the update of the model from v16.1 to v16.5 an error occurs with the following message and the Check In fails.

The consolidation fails with the following error:

PowerDesigner - Error
---------------------------
The upgrade of the repository model failed.

The Output window reads:

Checking in the document 'D:\temp\abc_123_XXX.pdm'
 - Checking out the repository document 'abc_123_XXX_PDM'...
Updating model version for model "abc_123_XXX_PDM" from 16.1.0.3805 to 16.5.5.4770
The upgrade of the repository model failed.
The check in of the document has been cancelled.

• We upgraded from SAP PowerDesigner (PD) 16.1 to SAP PowerDesigner 16.5 SP5 PL02. Our repository has a defined folder and branch hierarchy. When attempting to update a model in the repository via the proxy, the update fails with the following error:

Checking in the document 'D:\temp\xxx\ABC_PDM.PDM'
 - Checking out the repository document 'ABC_PDM'...
Updating model version for model "ABC_PDM" from 16.1.0.3805 to 16.5.5.4770
 - Comparing the local model with the repository model...
 - Updating the repository document...
Some errors occur during the update of the repository model.
Unexpected error while executing SQL statements in the repository
A command sent to the repository proxy failed.
23000 (SQLSTATE [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'TRGT', table '<database>.dbo.PMXRSH'; column does not allow nulls. UPDATE fails.)
01000 (SQLSTATE [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.)
Query: update PMXRSH set TRGT=(select T.NUM2 from #PMTMP2 T where T.SESS=308889773 and T.NUM1=PMXRSH.SRCE) where RTYP=2 and SRCE in (13938889 , 13938890)23000 (SQLSTATE [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'TRGT', table '<database>.dbo.PMXRSH'; column does not allow nulls. UPDATE fails.)
01000 (SQLSTATE [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.)
Query: update PMXRSH set TRGT=(select T.NUM2 from #PMTMP2 T where T.SESS=308889773 and T.NUM1=PMXRSH.SRCE) where RTYP=2 and SRCE in (13938889 , 13938890)

Unexpected error while updating the repository document.
The check in of the document has been cancelled.

• We upgraded from SAP PowerDesigner (PD) 16.1 to SAP PowerDesigner 16.7 SP5. Our repository has a defined folder hierarchy with many Porjects. We Check Out Project which is updated from 16.1.0 to 16.7.5. The project check out completes without issue. We make several changes to models in the project and attempt to check it back into the repository. The update fails with the following error

The consolidation fails with the following error:

PowerDesigner - Error
---------------------------
The upgrade of the repository model failed.

The Output window reads:

Checking in the document 'D:\temp\abc_123_XXX.ldm'
 - Checking out the repository document 'abc_123_XXX_LDM'...
Updating model version for model "abc_123_XXX_LDM" from 16.1.0.3714 to 16.7.5.6978
The upgrade of the repository model failed.
The check in of the document has been cancelled.

Checking in the document 'D:\temp\xyz_123_XXX.prj'
- Checking out the repository document 'xyz_123_XXX'...
Updating model version for model "xyz_123_XXX" from 16.1.0.3714 to 16.7.5.6978
The check in of the document has been cancelled.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP PowerDesigner (PD) 16.5 SP05

SAP PowerDesigner (PD) 16.7 SP05

cancel, failed, CR790625, 790625, CR790669, 790669 , KBA , BC-SYB-PD , PowerDesigner , Problem