Hello,
I had exactly the same issue few weeks ago. If you have a look to your ALtiris log viewer you probably seen that tables are missing. In fact it's not table that are missing but SQL View!
I have tried to repair database without success!
The issue wa solved by created SQL view (not tables) missing under Symantec_CMDB database.
I have a chance to have a platform that working and I have compared missing view, exported it with Right clic command Create in SQL Management Studio then recreate it in my corrupted platform. I need to create at least 5 missing views.
Hope you have a working platform to export this view. If not, send me an email with missing view and I can provided it to you.
Stef.