Mixologist behind bar, but not tending it, unavailable for orders

Same here. It's random and frequent. Fyi, I disabled all the packs to play with the base game, life and death, backyard stuff and basement treasure kit. It's a new save (15 days old) with only one played sim.