Re: <bug>: trying to bill something but get a exception instead.

[Karsten Hilbert]

Thanks for taking the time to report this issue.

> user comment  : trying to bill something but get a exception instead.
>
> client version: 1.8.9
>
> Exception:
>
>  type: <class 'psycopg2.errors.CheckViolation'>
>  value: new row for relation "bill" violates check constraint 
> "bill_bill_sane_recv_adr"
> DETAIL:  Failing row contains (13481, 2, 2023-06-14 13:48:06.205398+02, 
> any-doc, 1, GNUmed@Enterprise-2012-1, 2023-06-14 11:11:11.111111+02, t, null, 
> null, null, null).

This problem is caused by PostgreSQL (on behalf of GNUmed)
preventing "faulty" data from reaching the disk, more
precisely, GNUmed configures the database to not accepting
the lack of a bill receiver address when a bill closing date
has been set. However, it failed to gracefully recover when
PostgreSQL reminds it of this requirement.

This is now fixed for 1.8.13 which is yet to be released.

The workaround for now is to select a receiver address. In
case GNUmed tells you there's no addresses to pick from for
this patient one needs to first add an address to said
patient.

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B