SYMPTOM

Customer is getting error when attempting to activate Analytical Accounting(AA).

"Installation of analytical accounting has failed as there are other users logged into the system"

There are other users logged into DYNAMICS, but not that particular Company where you are adding AA. You are wondering if everyone has to be out of Dynamics GP to create default records as well as running the AA Activation Wizard itself. 

CAUSE

Users logged into Dynamics GP while activating Analytical Accounting. 

All users do need to be out of the system (all companies in same Dynamics database) when going through the AA activation process.  This is mainly because Analytical Accounting uses the dynamics table (AAG00102) to populate the next record values in the AAG work, open, and history tables for all of the companies.  When you activate AA, those tables will have default records created so that you can go back and add dimensions (using the AA edit analysis window) to posted journal entries should you need to.  It will also update a flag setting in the dynamics AAG00104 table after the activation is completed.  Since the Dynamics tables are impacted, all users need to be out of all company databases.
 

RESOLUTION

Run these scripts to see if anyone else is in the system and ask them to exit properly through the front-end. If all users are out, these tables should be empty, so provided ‘delete’ scripts below as well.

 

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

----------------------------------------

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×