1,500
We are receiving a message after trying to create a Employee"This record has been created since your attempt to create it. Changes won't be saved". We have updated GP 2010 to GP 2013.
*This post is locked for comments
Make sure all users should be out of GP before running the below query.
Select *from Dynamics..ACTIVITY
Select *from Dynamics..SY00800
Select *from Dynamics..SY00801
Select *from TEMPDB..Dex_Session
Select *from TEMPDB..Dex_Lock
If the above query returns any values, then run the below query to remove the unwanted sessions. Then try again to create a new employee.
Delete Dynamics..ACTIVITY
Delete Dynamics..SY00800
Delete Dynamics..SY00801
Delete TEMPDB..Dex_Session
Delete TEMPDB..Dex_Lock
Hope this helps!!!
Hi Wajahat,
Please check the below points after the upgrade.
1) Enable script debugger,Sql profiler to trace the issue cause.
2) Make sure the window is customized, if it is customized,open Sql server and run sp_helptrigger UPR00100 and find any new triggers apart from the below trigger list
aagTR_UPR00100Del
aagTR_UPR00100Ins
zDT_UPR00100U
if it contains any new trigger then, there must be customization associated with it. try to remove the customization objects and drop the new trigger.
Try going into SSMS and run this while no one is in GP.
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (