Vladislav Chkhartishvili

https://community.jaspersoft.com/wiki/caused-javasqlbatchupdateexception-batch-entry-0-insert-jiuserrole-userid-roleid-values-number

While executing a report i get following errors: ERROR AbstractFlushingEventListener - Could not synchronize database state with sessionorg.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch updateCaused by: java.sql.BatchUpdateException: Batch entry 0 insert into JIUserRole (userId, roleId) values (454131, 4) was aborted: ERROR: duplicate key value violates unique constraint "jiuserrole_pkey" Detail: Key (userid, roleid)=(454131, 4) already exists. Call getNextException to see other errors in the batch.Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "jiuserrole_pkey" Detail: Key (userid, roleid)=(454131, 4) already exists###ERROR SystemErrorController - Internal server errororg.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into JIUserRole (userId, roleId) values (?, ?)]; constraint [jiuserrole_pkey]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch updateCaused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch updateCaused by: java.sql.BatchUpdateException: Batch entry 0 insert into JIUserRole (userId, roleId) values (454131, 4) was aborted: ERROR: duplicate key value violates unique constraint "jiuserrole_pkey" Detail: Key (userid, roleid)=(454131, 4) already exists. Call getNextException to see other errors in the batch.Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "jiuserrole_pkey" Detail: Key (userid, roleid)=(454131, 4) already exists.###ERROR JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "jiuserrole_pkey" Detail: Key (userid, roleid)=(454131, 4) already exists.###ERROR JDBCExceptionReporter - Batch entry 0 insert into JIUserRole (userId, roleId) values (454131, 4) was aborted: ERROR: duplicate key value violates unique constraint "jiuserrole_pkey" Detail: Key (userid, roleid)=(454131, 4) already exists. Call getNextException to see other errors in the batch.[/code]Why does jasper try to insert existing user in JIUserRole?

Is it possible to export a template from one jasper server and export it to another with jasper studio? I couldn't find any appropriate guide.

Log4j v1.2.x is still affected according to our vulnerability scanner, so the question is not about which versions are affected but about how to update log4j v1.2.x jar to v2.x or is it possible to use jasper without it.

Is there any solution for log4j vulnerability in jasper 6? It uses log4j v1.2.17 so there's no LOG4J_FORMAT_MSG_NO_LOOKUPS variable I wonder if jasper/tomcat will work correctly without log4j.jar? jasperserver.log is still created but tomcat reports: org.apache.catalina.startup.ClassLoaderFactory validateFile WARNING: Problem with JAR file [/usr/share/java/tomcat/log4j.jar], exists: [false], canRead: [false]