2 added previous comments into response
source | link

Try applying the cumulative hotfix CD_2011.1.1.83467 from https://www.sdltridionworld.com/ (login required).

As stated, this contains

TT82946 Publish to the deployer fail with the exception "org.hibernate.exception.ConstraintViolationException: could not insert"

In addition, You state...

I haven't tried with any other file

why not try? Perhaps with a file with no Component Presentations to remove that from the equation.

Also - did you recently upgrade? Is this a clean installation?

Try applying the cumulative hotfix CD_2011.1.1.83467 from https://www.sdltridionworld.com/ (login required).

As stated, this contains

TT82946 Publish to the deployer fail with the exception "org.hibernate.exception.ConstraintViolationException: could not insert"

Try applying the cumulative hotfix CD_2011.1.1.83467 from https://www.sdltridionworld.com/ (login required).

As stated, this contains

TT82946 Publish to the deployer fail with the exception "org.hibernate.exception.ConstraintViolationException: could not insert"

In addition, You state...

I haven't tried with any other file

why not try? Perhaps with a file with no Component Presentations to remove that from the equation.

Also - did you recently upgrade? Is this a clean installation?

1
source | link

Try applying the cumulative hotfix CD_2011.1.1.83467 from https://www.sdltridionworld.com/ (login required).

As stated, this contains

TT82946 Publish to the deployer fail with the exception "org.hibernate.exception.ConstraintViolationException: could not insert"