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.


Read more...

Environment

SAP PowerDesigner (PD) 16.5 SP05

Product

SAP PowerDesigner 16.5

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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