EditI'm having the same problem and it's at the point where my Sim won't stay asleep at all. I have everything except city living, fitness stuff, bowling night stuff, vintage glamour stuff and luxury party stuff. I have no mods or cc.
I just got back to playing the Sims when cats & dogs came out. I changed beds, repaired game and everything else I could think of. They can have full needs and it doesn't matter their pets appear to be fine. They just won't sleep. They are both Young Adults.
Edit: I went back in the save and my Sim, upon being woken up from I didn't know what at first, had a music thought bubble with an x through it and I found the dog barking right outside the locked door (apparently barking is music...?) and I clicked on the dog and it said "scold for waking up" and I did. I keep trying to send her to sleep but the cats keeping waking up but at least now I know it IS the pets because I get "lecture for waking up" from their meowing. I'm assuming after enough lecturing they'll learn to stop it? Hopefully....at least I know the problem now. The pets even wake her up through locked doors. Locked doors make no difference, which I suppose is realistic but man is this annoying in the game.So sorry. If someone is having the same issue see if a pet is barking or meowing and if clicking on them brings up "scold/lecture for waking up"