Solve 'Unique Constraint (CORPUS.ASSET_PK)' Error Message during Checkout an Asset

Short description of the following content

Sometimes it is not possible to checkout an Asset because a 'unique constraint (CORPUS.ASSET_PK) violated' error message occurs.
Here you can find a possible reason for the error message and a solution.

Problem

You can not check out an Asset, because a 'unique constraint (CORPUS.ASSET_PK) violated' error message occurs.

Solution

One possible cause is a wrong state in the embedded database or in the Oracle database.
The Asset is marked as checked out in the Oracle database but not in censhare Client.
You will find a how to for solving the problem here:

how to-correct a asset which is not marked as checked out in the censhare Client but in the Oracle database