- Plesk 11.0 for Windows
- Plesk 11.0 for Linux
- Plesk 11.5 for Windows
- Plesk 11.5 for Linux
- Plesk 9.x and below for Windows
When trying to update service plan or install APS application, the following error message appears:
Violation of PRIMARY KEY constraint 'longtaskparamsPrimaryKey', cannot insert duplicate key in object 'dbo.longtaskparams'. The duplicate key value is ('id', 'name').
' was cleaned, but table '
' was not and contains old orphan records. As a result Plesk tries to use duplicated ID values.
You should always clean both tables:
if it is needed for some reasons.
To fix the issue clean up '
' table with the command:
"%plesk_bin%\\dbclient" --direct-sql --sql="truncate table longtaskparams"