phelgren

Not sure how that is related to the issue. I am not migrating anything just rying to install new sinatnce so there would be no reports involved at all (yet).

Running this in an AIX environment (eq 7.2) Thisis exactly the same error as posted here: https://community.jaspersoft.com/questions/1186301/js-ant-import-minimal-ce-build-failed Circumstances are a bit different in that I am manually installing the war file and I am using mysql as the DB (Maria). All seems well but I haven't been able to determine what is causing the error (hard to follow all the XML references). Here is the compete error: bash-4.4$ ./js-ant import-minimal-ce Buildfile: /opt/jasperreports-server-cp-7.8.0-bin/buildomatic/build.xml [echo] chkIfPackageManagedTomcat: CATALINA_HOME and CATALINA_BASE are BOTH set [echo] chkIfPackageManagedTomcat: CATALINA_HOME folder location exists [echo] chkIfPackageManagedTomcat: CATALINA_BASE folder location exists [echo] Back-End version: ${git.currentBranchName}-SNAPSHOT [echo] Front-End version: ${git.currentBranchName}-SNAPSHOT [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: CATALINA_HOME and CATALINA_BASE are BOTH set [echo] chkIfPackageManagedTomcat: CATALINA_HOME folder location exists [echo] chkIfPackageManagedTomcat: CATALINA_BASE folder location exists [echo] tomcatPackageManaged IS SET [echo] Overriding fixedAppServerDir with value from CATALINA_BASE [echo] Maven settings: /opt/jasperreports-server-cp-7.8.0-bin/buildomatic/build_conf/default/maven_settings.xml keystore-properties: import-minimal-ce: [echo] --- (import-export.xml:run-import-export) archiveArg = --input-zip=/opt/jasperreports-server-cp-7.8.0-bin/buildomatic/install_resources/export/js-catalog-mysql-minimal-ce.zip --- [echo] dbType = mysql [echo] jdbcJar = mariadb-java-client-2.5.3.jar [echo] currentConf = /opt/jasperreports-server-cp-7.8.0-bin/buildomatic/build_conf/default [echo] importExportConfig = /opt/jasperreports-server-cp-7.8.0-bin/buildomatic/conf_source/ieCe [echo] [echo] Validating JasperServer database connection at jdbc:mysql://localhost:3306/jasperserver_new?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true&tinyInt1isBit=false&allowPublicKeyRetrieval=true. Phase: [import-export-test] [advanced-sql] Executing commands [advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [java] 2021-10-02T17:32:53,533 ERROR BaseExportImportCommand:45 - java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 Ideas on where to look or how to solve would be apprecaited.

Thanks...Actually, you misread the post. The *name* of IBM's JVM is called the J9 (not sure why) but it has nothing to do with the Java version. I was actually running the Java Version 6 of the IBM J9 JVM.... I have partially fixed the issues. The CSRF problem was resolved by adding 'org.owasp.csrfguard.PRNG.Provider=IBMJCE' to the jrs.csrfguard.properties file. With that out of the way I then got a "java.lang.UnsupportedClassVersionError: JVMCFRE003 bad major version" error which I resolved by changing from the Java Version 6 to Java Version 7. Currently chasing a couple of more unrelated errors but I am making progress.... Thanks for posting

I thought the IBM JVM was supported but jasperserver (6.0.3) doesn't start with at least one of the causes being: Caused by: java.lang.RuntimeException: java.security.NoSuchProviderException: Provider SUN is not available at org.owasp.csrfguard.config.PropertiesConfigurationProvider.<init>(PropertiesConfigurationProvider.java:234) at org.owasp.csrfguard.config.PropertiesConfigurationProviderFactory.retrieveConfiguration(PropertiesConfigurationProviderFactory.java:32) ... 21 more Caused by: java.security.NoSuchProviderException: Provider SUN is not available at java.security.SecureRandom.getInstance(SecureRandom.java:212) at org.owasp.csrfguard.config.PropertiesConfigurationProvider.<init>(PropertiesConfigurationProvider.java:121) ... 22 more disabling csrf protection didn't really make a difference. Is there a different provider I should reference when using the IBM JVM?

So this must be some weird MySQL bug because I simply ran the install 5 or 6 times and it finally completed successfully. Each time I ran the install it progressed slightly further. No logical explaination that I can think of....but at least I have the server installed

This is the error: [advanced-sql] Failed to execute: alter table JIInputControlQueryColumn add index FKE436A5CCE7922149 (input_control_id), add constraint FKE436A5CCE7922149 foreign key (input_control_id) references JIInputControl (id) Windows 7 - mySQL 5.1.42 New install, new database, does it every time I try the install and I verifed the the jasperserver database does not exist. If I choose to skip the database drop step it will install all the other sample data bases just fine. BUILD FAILED E:jasperreports-server-cp-6.0.1-binbuildomaticbindb-common.xml:926: The following error occurred while executing this line: E:jasperreports-server-cp-6.0.1-binbuildomaticbindb-common.xml:113: The following error occurred while executing this line: E:jasperreports-server-cp-6.0.1-binbuildomaticbinapp-server.xml:60: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'FKE436A5CCE7922149' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:775) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:745) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1055) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:985) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:653) at com.jaspersoft.buildomatic.sql.ant.AdvancedSQLExec.execute(AdvancedSQLExec.java:82) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:398) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:390) at org.apache.tools.ant.Target.performTasks(Target.java:411) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1249) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197) at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:154) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:390) at org.apache.tools.ant.Target.performTasks(Target.java:411) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397) at org.apache.tools.ant.Project.executeTarget(Project.java:1366) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1249) at org.apache.tools.ant.Main.runBuild(Main.java:801) at org.apache.tools.ant.Main.startAnt(Main.java:218) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) To also follow up.... I repeated the install multiple times and each time it is a DIFFERENT foreign key that the duplicate occurs on: Latest was: [advanced-sql] Failed to execute: alter table JILogEvent add index FK5F32081591865AF (userId), add constraint FK5F32081591865AF foreign key (userId) references JIUser (id) Others: [advanced-sql] Failed to execute: alter table JIListOfValuesItem add index FKD37CEBA993F0E1F6 (id), add constraint FKD37CEBA993F0E1F6 foreign key (id) references JIListOfValues (id) Any idea of why this behavior occurs? I looked at the DDL and I don't see anything out of the ordinary. Some kind of weird MySQL bug?

Much frustration with Jasper Reports (4.5) with some very simple reports and deployment: 1. The above mentioned error is coming from two sources: a. Missing images that have relative paths b. Fonts that are missing on the deployment server Lets deal with fonts first. Seems like this is common problem post 3.6.1 but the suggestions for fixing the issue haven't been helpful. Here is a response that *seemed* helpful but was lacking. It has to do with disabling the font checking: "You can do this by setting the net.sf.jasperreports.awt.ignore.missing.font=true in the jasperreports.properties file or as a custom property in that particular report template." Sounds wonderful except the author goes into no detail on HOW to accomplish this. Taking the first approach: net.sf.jasperreports.awt.ignore.missing.font=true in the jasperreports.properties file WHERE exactly does the jasperreports.properties file go? I am running these reports from a command interface and I placed the properties file in the /lib folder but it had no effect. This isn't a web app so where do I put the properties file if not in the /lib folder? So how about taking the second approach: "a custom property in that particular report template". Awesome! But just WHERE is such a custom property set? I went to the tools-->options-ireport settings and changed the jasperreport properties there (which didn't seem right) and changed the settings. No difference. I also went to the report, selected properties and then added a Property to the ones listed in "Properties" but that made no difference either. Continuing on to solve the font issue, I also jarred up the files in the demo font folder for DejaVuSans and added that jar to my classpath and then set the values in the jasperreports_extension.properties file which I also put in the lib folder. It made no difference. I still see the error "Could not create the report stream Font 'DejaVu Sans' is not available to the JVM". Sigh. My earlier projects using Jasper reports had none of these issues. The price of progress I guess. Finally, back to the images issues. Is the only way to make images that are referenced in the report appear to use a full path to the image. I saw a post about 4 ways to handle "relative" references but they all seem a lot more work and a hassle for multiple reports created by end users. I know there are solutions to these issues but reponses that lack detail are not helpful. Filling in the blanks would be helpful and get me moving forward again. Thanks in advance, Pete Post Edited by phelgren at 02/24/2012 23:22