fix(analyst): report tool failures as failures, accept valid read-only syntax, retrieve long text in full

fix(analyst): report tool failures as failures, accept valid read-only syntax, retrieve long text in full #8237