[medium] investigator status update in console, api and database (with doc)
[minor] various nits (error checks, http codes, ...)