How to upgrade from 1.0.1 to 1.1.0 ?

[lovetide]

I installed jasperintelligence 1.1 now, and I have configured the database setting of JasperServer webapp as the same as 1.0.1, but when I try to login, I got an error like this:

Code:

Invalid credentials supplied.
Could not login to JasperServer.

 

I checked the log of tomcat, I found the following message:

Code:

[code] 15:13:51,125 ERROR JDBCExceptionReporter,http-8080-Processor22:72 - Table 'jasperserver.jiuser' doesn't exist

It seems that JI1.1 use a new database schema than JI1.0.1, so how can I upgrade it ? Must I install a fresh JI1.1 ?

 

by the way, I can't start both JI1.1 and JI1.0.1 at the same time, see the following exception:

Code:

[code] java.lang.IllegalStateException: Web app root system property already set to different value: 'jasperserver.root' = [C:WebApplicationsjasperserver] instead of [C:WebApplicationsjasperserver1.0.1] - Choose unique values for the 'webAppRootKey' context-param in your web.xml files!

[lovetide]

Okay, I try to resolve it by myself. Here is my solution:

 

I use MySQL-5.0.24a for windows, and installed Tomcat 5.5.17, Apache 2.0.59, phpMyAdmin 2.9.0

 

1. use phpMyAdmin to clone a new database from the old database of JI-1.0.1.

my old database name: JasperServer

my new database name: JServerMeta1

 

2. use phpMyAdmin, select JServerMeta1 database, then execute the following SQL statements.

Code:

ALTER TABLE BeanDatasource RENAME TO JIBeanDatasource;
ALTER TABLE DataType RENAME TO JIDataType;
ALTER TABLE content_resource RENAME TO JIContentResource;
ALTER TABLE file_resource RENAME TO JIFileResource;
ALTER TABLE InputControl RENAME TO JIInputControl;
ALTER TABLE InputControlQueryColumn RENAME TO JIInputControlQueryColumn;
ALTER TABLE JNDIJdbcDatasource RENAME TO JIJNDIJdbcDatasource;
ALTER TABLE JdbcDatasource RENAME TO JIJdbcDatasource;
ALTER TABLE ListOfValues RENAME TO JIListOfValues;
ALTER TABLE ListOfValuesItem RENAME TO JIListOfValuesItem;
ALTER TABLE log_event RENAME TO JILogEvent;
ALTER TABLE MondrianConnection RENAME TO JIMondrianConnection;
ALTER TABLE MondrianXMLADefinition RENAME TO JIMondrianXMLADefinition;
ALTER TABLE ObjectPermission RENAME TO JIObjectPermission;
ALTER TABLE OlapClientConnection RENAME TO JIOlapClientConnection;
ALTER TABLE OlapUnit RENAME TO JIOlapUnit;
ALTER TABLE JSQuery RENAME TO JIQuery;
ALTER TABLE ReportDataSource RENAME TO JIReportDataSource;
ALTER TABLE report_job RENAME TO JIReportJob;
ALTER TABLE report_job_calendar_trigger RENAME TO JIReportJobCalendarTrigger;
ALTER TABLE report_job_mail RENAME TO JIReportJobMail;
ALTER TABLE report_job_mail_recipient RENAME TO JIReportJobMailRecipient;
ALTER TABLE report_job_output_format RENAME TO JIReportJobOutputFormat;
ALTER TABLE report_job_parameter RENAME TO JIReportJobParameter;
ALTER TABLE report_job_repository_destination RENAME TO JIReportJobRepoDest;
ALTER TABLE report_job_simple_trigger RENAME TO JIReportJobSimpleTrigger;
ALTER TABLE report_job_trigger RENAME TO JIReportJobTrigger;
ALTER TABLE ReportUnit RENAME TO JIReportUnit;
ALTER TABLE ReportUnitInputControl RENAME TO JIReportUnitInputControl;
ALTER TABLE Report_Unit_Resource RENAME TO JIReportUnitResource;
ALTER TABLE repository_cache RENAME TO JIRepositoryCache;
ALTER TABLE Resource RENAME TO JIResource;
ALTER TABLE resource_folder RENAME TO JIResourceFolder;
ALTER TABLE Role RENAME TO JIRole;
ALTER TABLE JSUser RENAME TO JIUser;
ALTER TABLE UserRole RENAME TO JIUserRole;
ALTER TABLE XMLAConnection RENAME TO JIXMLAConnection;


ALTER TABLE JIQuery ADD COLUMN dataSource BIGINT(20) DEFAULT NULL AFTER id, ADD COLUMN query_language VARCHAR(40) NOT NULL AFTER dataSource;
ALTER TABLE JIReportUnit ADD COLUMN controlrenderer VARCHAR(100) DEFAULT NULL AFTER mainReport,	ADD COLUMN reportrenderer VARCHAR(100) DEFAULT NULL AFTER controlrenderer;
ALTER TABLE JIResourceFolder MODIFY COLUMN uri VARCHAR(250) NOT NULL, MODIFY COLUMN description VARCHAR(250) DEFAULT NULL;

 

and now it works.

 

Although it "works" now, but I have not a fully test, so take it carefully.

[Teodor Danciu]

Hi,

 

Thank you for posting your solution to the forums.

In the JI product we also ship an export/import tool that should help with this.

However, we have not fully tested the import of an older JI export, so for the moment we cannot certify this as a solution. But it is meant for this tool to work this way in the future.

We'll probably revisit the code and make it more configurable and flexible so that the import could work on arbitrary old database export files (if possible).

 

Check section 2.5.3 Database Setup with Sample Data in the JasperIntelligence-WarFile-Install-Guide.pdf document that comes with our distribution.

 

Thank you,

Teodor