Uniimpsec cannot import roles from one UVMS to another

Document ID : KB000085760
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
The following error appears on the uvserver.log when trying to import the roles via the command uniimpsec:

#################
|ERROR| main | com.orsyp.central.server.CommonCommand | Cannot execute command: 
java.lang.reflect.UndeclaredThrowableException 
at com.sun.proxy.$Proxy1.create(Unknown Source) 
at com.orsyp.central.cli.securitycmd.RoleSecurityImportDeployment.createElement(RoleSecurityImportDeployment.java:33) 
at com.orsyp.central.cli.securitycmd.RoleSecurityImportDeployment.createElement(RoleSecurityImportDeployment.java:12) 
at com.orsyp.central.cli.securitycmd.ImportSecurityCmd.importObject(ImportSecurityCmd.java:48) 
at com.orsyp.central.cli.securitycmd.ImportSecurityCmd.importListRoles(ImportSecurityCmd.java:251) 
at com.orsyp.central.cli.securitycmd.ImportSecurityCmd.importObjects(ImportSecurityCmd.java:310) 
at com.orsyp.central.cli.securitycmd.ImportSecurityCmd.executeAfterAuth(ImportSecurityCmd.java:323) 
at com.orsyp.central.AbstractCommonCommand.execute(AbstractCommonCommand.java:686) 
at com.orsyp.central.AbstractCommonCommand.execute(AbstractCommonCommand.java:635) 
at com.orsyp.central.cli.securitycmd.ExportImportSecurityCommonCmd.work(ExportImportSecurityCommonCmd.java:282) 
at com.orsyp.central.cli.securitycmd.ExportImportSecurityCommonCmd.executeCmd(ExportImportSecurityCommonCmd.java:277) 
at com.orsyp.central.cli.securitycmd.ExportImportSecurityCommonCmd.cmdMain(ExportImportSecurityCommonCmd.java:168) 
at com.orsyp.central.cli.securitycmd.ImportSecurityCmd.main(ImportSecurityCmd.java:38) 
Caused by: com.orsyp.UniverseException: org.springframework.dao.DataIntegrityViolationException: A similar object already exists in the database.; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.orsyp.central.jpa.jpo.security.PermissionEntity] 
at com.orsyp.comm.client.ServiceInvocationHandler.readResponse(ServiceInvocationHandler.java:169) 
at com.orsyp.comm.client.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:91) 
... 13 more 
Caused by: org.springframework.dao.DataIntegrityViolationException: A similar object already exists in the database.; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.orsyp.central.jpa.jpo.security.PermissionEntity] 
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.orsyp.central.jpa.jpo.security.PermissionEntity] 
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_UNI_UV_PERMISSIONS_ROLES". The conflict occurred in database "uvmsdb", table "dbo.UNI_UV_ROLES2", column 'ID'.

###################

Patch level detected:Univiewer Management Server 6.5.01
Product Version: Dollar.Universe 6.5.01

Description :The uniimpsec does not work if the export file comes from another uvms
Environment:
OS: All
Cause:
Cause type:
Defect
Root Cause: N/A
Resolution:
Update to the fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.6.01
Additional Information:
Workaround :
N/A