Uniimpsec cannot import roles from one UVMS to another
Article ID: 85760
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
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
Defect
Root Cause: N/A
Environment
OS: All
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
Fix Status: Released
Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.6.01
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
