Some Errors occur while updating the repository model issue

[Former Member]

Hi,

Unable to check-in the model into the repository.

Getting the above error with the below statement

Unexpected error while executing SQL statements in the repository

A Command sent to the repository failed

Cannot insert the value NULL into column "TRGT" teble

[eduardo_marques2 · Accepted solution]

Hi, "TRTG" is a column that can be found in the following PD repository tables:

PMDRLS

PMINTG

PMRLSH

PMXDSQ

PMXRSH

My first suggestion would be to make sure your repository matches your PowerDesigner version.

After updating/upgrading PD, when an Admin connects to the repository, it may be update/upgraded

to match the PD version.

So if the repository was updated/upgraded by an admin but you are using an older PD version,

you  could get such an error. You shouldn't be allowed to connect to the repository by the way,

but just make sure it's not the case.

Second option would be applying a SP to your installation.

Third option, which usually requires second option, is opening a case.

Regards,

Eduardo

[Former Member · Accepted solution]

Thanks Marques.

We have recently upgraded the PD to PD 16.5 SP05 PL02.

And the first 2 options are fine in our case.

So probably , we need to raise a case.

thanks again.

[jong-kil_park]

Hi,

I'm not sure which SP you applied, but I had a similar problem in updating repository using PD 16.5 SP05.

The error I ran into was "cannot insert NULL into ("PDREP"."PMTXCS"."CSUM").....".

Please refer to a KBA 2226577 just in case you have still encountered the problem.

https://i7p.wdf.sap.corp/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3...

Best regards,

Jerry

[Former Member]

Thanks Jong-kil Park.

But the link is not working , can you please check and update me.

[jong-kil_park]

Hi Kavitha,

Here is the link available for you.

https://i7p.wdf.sap.corp/sap/support/notes/2226577

Best regards,

Jerry

[Former Member]

Hi Park,

Still the link is not opening. Please check. Thanks.

[lbreddemann]

Hi there

be careful when trying to post URLs from SAP internal systems - they don't work for people outside of the sap network.

The canonical public link to the mentioned SAP note is:

https://service.sap.com/sap/support/notes/2226577

Please make sure to not just copy and paste the URL from your browser's address bar, as this will be a re-routed URL. Instead use the "Quick link" function (the little 'chain' icon at the upper right edge of the page) to get the canonical URL.

- Lars

[Former Member]

Hi Park,

I don't have SAP support site access, that's why I am unable to open it.

[Former Member]

Hi Lars,

Can you please share me the screen shot for "Quick link" option, as I am unable to get it. Thanks.

[jong-kil_park]

Hi,

As I said, the error I encountered was "The error I ran into was "cannot insert NULL into ("PDREP"."PMTXCS"."CSUM").....", which was similar with your error.

It happened while updating repository after applying PD 16.5 SP05.

The error was fixed in SP05 PL03.

So, if you also failed to update repository using SP05 due to the error, then it's worth while to apply it.

Because the error messages are a little different, applying the patch may not resolve your case.

You should back up the repository first.

Best regards,

Jerry

[Former Member]

Thanks Park.

Let me check.

[Former Member]

When PD updates a model in the repository, it only saves the differences.  If you upgraded the PD version of the new model version from what it is in the repository now, there can be some issues calculating what the differences are, and merging the new version into the old model version.  We have found that if we save as a baseline after an upgrade, there will be a full copy using the new version in the repository, and differences will be calculated from that point on.  Until you upgrade again, that is. 

HTH,

Jane

[Former Member]

Thanks Caddel for the details.