I take exception with the word 'except'.
The Book says...
Acts 13:22 (niv)
After removing Saul, he made David their king. God testified concerning him:
I have found David son of Jesse, a man after my own heart; he will do everything I want him to do.
Refering to...1 Samuel 13:13-14And Samuel said to Saul, You have done foolishly. You have not kept the commandment of the Lord your God, which He commanded you. For now the Lord would have established your kingdom over Israel forever. But now your kingdom shall not continue. The Lord has sought for Himself a man after His own heart, and the Lord has commanded him to be commander over His people, because you have not kept what the Lord commanded you.But...David committed adultery with Bathsheba. He then tried to cover up her pregnancy, and when he failed with that, he had her husband Uriah the Hittite killed.
David took a census of the people, willfully violating God's command not to do that.
David was often lax, or absent as a father, not disciplining his children when they needed it.
2 Samuel 12:12-13
Then David said to Nathan, "I have sinned against the LORD." Nathan replied, "The LORD has taken away your sin. You are not going to die. But because by doing this you have shown utter contempt for the LORD, the son born to you will die." (NIV)
I take exception to your exception, as I trust the Bible over you.
1 Kings 15:4But for Davids sake the LORD his God gave him a lamp in Jerusalem, to raise up his son after him and to establish Jerusalem; 5because David did what was right in the sight of the LORD, and had not turned aside from anything that He commanded him all the days of his life, except in the case of Uriah the Hittite.
Reread your comment - you are going to need to back up your statements with scripture:
David took a census of the people, willfully violating God’s command not to do that.
Can you share where God commanded him to not do this? I cannot find it.
By the same token, can you back up the discipline issue with scripture. I haven’t studied this out, but I do not remember this being noted as a sin. You may be able to prove me wrong though.