oliver.rauer

Hey everyone, we've been using Jasperserver 5.0 for years, now we have a new server with version 7.1.0 installed. I'm currently trying to move the reports to the new server, but I'm not making any progress here. I export the reports from the old server via js-export (e.g. js-export --report-jobs /Jira --output-zip Jira.zip) After that I import the zip file via import function in the settings of the new server, get succeeded However, nothing happens, the reports cannot be found afterwards. What am I doing wrong? kind regards

How? I have the community edition of Jasper and i don't have the option "Export" in the contextmenu.

Hey, i have the problem that i cannot use the js-export The Error is: First resource path:C:Program Filesjasperreports-server-cp-5.0.0buildomaticconf_sourceieCeapplicationContext-cascade.xml Started to load resources Resource name: applicationContext.xml Resource name: applicationContext-cascade.xml Resource name: applicationContext-data-snapshots.xml Resource name: applicationContext-events-logging.xml Resource name: applicationContext-export-config.xml Resource name: applicationContext-export-import.xml Resource name: applicationContext-logging.xml Resource name: applicationContext-olap-connection.xml Resource name: applicationContext-report-scheduling.xml Resource name: applicationContext-search.xml Resource name: applicationContext-security.xml Resource name: applicationContext-themes.xml Resource name: applicationContext-virtual-data-source.xml Creating ActionModelService object. Creating action model infrastructure. Unknown column 'this_.theme' in 'field list' org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id7_0_, this_.tenantId as tenantId7_0_, this_.tenantAlias as tenantAl3_7_0_, this_.parentId as parentId7_0_, this_.tenantName as tenantName7_0_, this_.tenantDesc as tenantDesc7_0_, this_.tenantNote as tenantNote7_0_, this_.tenantUri as tenantUri7_0_, this_.tenantFolderUri as tenantFo9_7_0_, this_.theme as theme7_0_ from JITenant this_ where (this_.tenantId=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query I've looked at the Table jitenant but i can't find the Issue. The column theme is there and looks like another of my postgres JasperDBs Any Help would be great.

Hi, at the beginning, sorry for my bad english. I have the project to migrate our postgres databases for jasperserver to mysql. I've found a way to do that, documented here: http://community.jaspersoft.com/questions/543372/changing-jasper-server-postgres-mysql I had create the DB, used the Scripts: ./js-ant create-js-db ./js-ant init-js-db-pro ./js-ant import-minimal-pro That was not the problem. The migration of the postgres data with js-import works too, but after editing the context.xml and login i've got many errors. The creation of a new Report is impossible too. So i thought i start with an blank mysql db. I had dropped the database and created it again. But then i'm not able to login, i've got an error when i try to go to the login site: Status report The requested resource () is not available. Have i forgotten something? Many Greetings, Oliver