04-26-2013 05:40 PM
Sorry. Meant to post back. So Blackberry support never got back to me for a solid week. They did say it was a bug in the BES10 server software. I installed SQL Management Studio software on the server, connected to the BDSMgmt (not BESMgmt as was the name in BES5), navigated to the dbo.DeviceUser table, found my userid and deleted myself. My user account was back in the system after that, created a new activation passcode and activated myself again.
04-26-2013 05:55 PM
Anytime. Saved my butt. I'm the lead IT administrator and I didn't have a working mobile device with my emails. Glad it got sorted out. Had to do it with another user actually afterwards. Same good result. Glad it worked out for you.
04-30-2013 10:37 AM
Still can't delete user even with the "Immediate removal" workaround.
this error occures:
Caused by: org.hibernate.exception.ConstraintViolationExcepti
... 667 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "FK_BASUserApplicationReconciliations_DevicePerime
... 678 more
05-02-2013 03:45 AM
After deleting the user in the SQL Database, the User Account is back in the system but does not work any more - it can not be assigned to the current BES Server. It can not be deleted either....
05-02-2013 11:34 AM
I highly recommend that you never try to manually delete any records from the BDSmgmt tables.
This is a known bug and I was able to resolve it by using the KB18404 document.
This is the part that is specific to the BDS environment.
For BlackBerry Enterprise Service 10
The user can be purged from the database or removed immediately from the BlackBerry Enterprise Server services by performing the following steps:
05-08-2013 08:53 AM
I came across this thread when I searched an error from my BBAS AS log:
"The DELETE statement conflicted with the REFERENCE constraint "FK_BASUserApplicationReconciliations_DevicePerime
We had a user in BDS6.2 that just couldn't be deleted. Someone deleted him and wanted to re-add them to activate another device. I followed what bysdontcry posted and deleted the users entry from the dbo.deviceuser table.
At first I wasn't able to add the user back, but then I noticed they were still in the BDS, but as an Adminstrator User. After clicking "Add to Blackberry Device Service" the user was able to be activated again.
Props, and I hope this helps others.