Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Austin Adams]

One of our admins ran a reconcile earlier this week and ever since then all users besides him get the message “Processes are currently being run that cannot be deleted.  These processes must be run to completion before you exit” when they log in to the company that reconcile was run on.   If you look at Process Monitor for the person who ran reconcile or any of the users getting the error, there is no activity or hung processes.

People can click through this error and it allows them to close GP without any errors or issues, so I”m guessing this is due to a stranded record in a table, but not sure which one it is.

I deleted SY01300 and flushed the dexsession and dexlock temp files and then rebooted, but it still happens.   I turned on logging to see if anything shows up, but I’m not seeing anything.

Anyone have any suggestions on how to address this?   Hoping there’s a record that can be deleted or a Checklinks option that will fix it.  At this point it’s just a nuisance, but I’d like to get it cleared.

Thanks!

——————————
Austin Adams
American Innovations
Austin TX
——————————

[Thaddeus Suter]

You didn’t say which reconcile they were running but if it was Utilities IV Reconcile Inventory Quantities, that process writes a record into the DYNAMICS SY00800 table and the TRXSORCE will be RECONCILE.

If the USERID is logged out, i.e., not in DYNAMICS ACTIVITY, delete this record.
If the user is logged in, have them log out completely and then delete the record in SY00800.

Other (but not all) GP reconciles also write records to SY00800, but they do not help you out with the value RECONCILE in TRXSORCE. Just look for and delete any records in SY00800, where the userid is not present in DYNAMICS ACTIVITY. You could also similarly clean up SY00801 but stranded (orphaned)  records there are different and create other issues

If you were doing some other reconcile, post what it is as that will help diagnose. Also whether your users are all on Citrix/DRP.

Hook em!

——————————
Thaddeus Suter
Retus, Inc
TX
——————————
——————————————-

[Mahmood M. AlSaadi]

Hello Austin
The first thing that I would look for is the activity tables as I suspect there are certain processes being stuck at some point preventing the login from proceeding as expected.

The first thing I would do is to run the following scripts while having all the users out of the system

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

If that didn’t work, then I would get on the SQL profiler to easily check the open record / flag causing this warning message to pop up.

Your feedback is highly appreciated,
Best Regards,

——————————
Mahmood M. AlSaadi – MVP
Principal Dynamics ERP Consultant
SIROCo LLC – (844) 708-0008
McKinney TX
m.saadi@sirocollc.com
http://www.sirocotech.com
——————————
——————————————-

[Austin Adams]

Sorry, it was an inventory reconcile that caused the issue.   I deleted everything from the following tables ( and SY01300) when everyone was logged off, but it’s still happening.  Also, the only person who isn’t seeing the error is the person who ran the reconcile.   

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

——————————
Austin Adams
American Innovations
Austin TX
——————————
——————————————-