Make it possible for automation type adapters to return null as an adapted value and throw an explicit error what adapt cannot be done

For instance, the empty string "" should be converted into the null date, but the service throws an error when the adapter returns a null value => this should be more explicit, using a dedicated exception