Fix/partner otrs view data

To fix a bug selecting data from OTRS:

it would appear that there are some problems with the customerid in the view. there are some records with no customerid and because this is mandatory the sql select fails and does not continue.