1. ADDM information comes trough ADDM sync to the ADDM dataset. By promotion I believe you mean you run the ADDM Reconciliation job to merge to ASSET. This is not a sandbox, so I´m not sure what you mean by the message "Promote Sandbox Changes in progress"... this will only show while doing a user edit of a CI in BMC.ASSET.
2. I´m not clear what console are you talking about. Federation and Reconciliation are two different processes, and they are not associated in any particular way. Please clarify.
3. What logs did you review?
thank you since resolved, the problem was a service that fell,