This is due to your use of not-found=”ignore” for your many-to-one which tells Hibernate, that the value in the LSENDERID column might not point to an actual row in the PORTALNUTZER table.

Either remove the not-found attribute or change your query to ... where fk(sender) = :pnutzerid.