Uniimpsec cannot import roles from one UVMS to another
book
Article ID: 85760
calendar_today
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
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
Cause
Cause type: Defect Root Cause: N/A
Environment
OS: All
Resolution
Update to the fix version listed below or a newer version if available.