- BlackBerry® Enterprise Server 5.0 SP3
When navigating in the BlackBerry® Administration Service interface to Software, Manage application control policies for unlisted applications, attempts to delete the ACP fails with the following error:
The request could not be completed.
The BAS-AS logs show the following error:
*** Start of original stack trace ***
javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.ConstraintViolationException: could not delete: [com.rim.bes.bas.applicationcontrolpolicymanager.entity.HandheldAppControlPolicyEntity#6]
*** end of original stack trace ***
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "FK_BASUserUAMReconciliations_HandheldAppControlPolicy_Other". The conflict occurred in database "BESMgmTest502", table "dbo.BASUserUAMReconciliations", column 'PreviousOtherAppControlPolicyId'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "FK_BASUserUAMReconciliations_HandheldAppControlPolicy_Other". The conflict occurred in database "BESMgmTest502", table "dbo.BASUserUAMReconciliations", column 'PreviousOtherAppControlPolicyId'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
A user account is still associated with the Application Control Policy.
Assign the related user to a different IT policy.
Disclaimer
By downloading, accessing or otherwise using the Knowledge Base documents you agree:
(a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and
(b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.
Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.