Has anyone ever encountered a situation where a transaction is confirmed (more than 6000 times) but the total balance is still pending?
I suggest you make a backup of your wallet.dat (you should of course have backups already, but make a new one anyway!), and start Bitcoin Core with the -rescan flag on it's command line. See if that makes Bitcoin Core realize it's confirmed already.
-rescan
Rescan the block chain for missing wallet transactions on startup