SAP Knowledge Base Article - Preview

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

Symptom

  • 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."


Read more...

Environment

SAP PowerDesigner (PD) 16.5 SP05

SAP PowerDesigner (PD) 16.7 SP05

Product

SAP PowerDesigner all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.