I followed all the steps to upgrade from ART 3.1 to 3.2. After starting tomcat (everything looks ok), I fire up my brower, update the settings, and go to look at reports. I get an empty report list and the following is on my brower:
An error occurred
org.hsqldb.HsqlException: file input/output error
I will attached the stack trace.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
yes it is a HSQLDB database and yes there are columns defined as CLOB. I changed all CLOB's to LONGVARCHAR, restarted the server and it is still getting the error.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm not sure just changing the CLOB keyword to LONGVARCHAR would be enough. CLOB columns were introduced in 3.1 so not sure how things were working before and why they would stop working in 3.2.
Do other areas of the application give the same error? Configure | Reports, Configue | Jobs etc.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anyway. For your 3.1 database, are there clob files i.e. a .properties file, .script file and other files? Are these files present in your 3.2 database?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
ok, i'm confused. first you say clob columns were introduced in 3.1 and now you are saying there should not be any ?! And i have not created any clob files that i know of.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is odd, i built a new tomcat instance based on production, put in the war file and started it up. Its been trying to initialize now for almost an hour and the deploying the art web application directory still is not complete. The last message from a successful run was
art has finished in 189,338 ms
This is really odd. Any ideas how to get this running again?
Thanks,
Ray
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I followed all the steps to upgrade from ART 3.1 to 3.2. After starting tomcat (everything looks ok), I fire up my brower, update the settings, and go to look at reports. I get an empty report list and the following is on my brower:
An error occurred
org.hsqldb.HsqlException: file input/output error
I will attached the stack trace.
stack trace attached
I'm assuming that you are using a HSQLDB database as your repository database. If you look at your .script file are there columns defined as CLOB?
yes it is a HSQLDB database and yes there are columns defined as CLOB. I changed all CLOB's to LONGVARCHAR, restarted the server and it is still getting the error.
I'm not sure just changing the CLOB keyword to LONGVARCHAR would be enough. CLOB columns were introduced in 3.1 so not sure how things were working before and why they would stop working in 3.2.
Do other areas of the application give the same error? Configure | Reports, Configue | Jobs etc.
failing functions
reports, jobs, configure reports, access rights, jobs, caches, connections, loggers
working functions
configure datasources, report groups, users, parameters, schedules
Does your 3.1 database have clob columns.
Yes, and here they are.
PUBLIC.ART_QUERIES
REPORT_SOURCE CLOB(1G)
PUBLIC.ART_JOBS
EXTRA_SCHEDULES CLOB(1G)
HOLIDAYS CLOB(1G)
PUBLIC.ART_JOB_SCHEDULES
EXTRA_SCHEDULES CLOB(1G)
HOLIDAYS CLOB(1G)
PUBLIC.ART_ENCRYPTORS
OPENPGP_PUBLIC_KEY_STRING CLOB(1G)
PUBLIC.ART_HOLIDAYS
HOLIDAY_DEFINITION CLOB(1G)
You shouldn't have had clob columns in 3.1.
Anyway. For your 3.1 database, are there clob files i.e. a .properties file, .script file and other files? Are these files present in your 3.2 database?
ok, i'm confused. first you say clob columns were introduced in 3.1 and now you are saying there should not be any ?! And i have not created any clob files that i know of.
Please review the notes in the 3.0.1_to3.1.0.sql script. For HSQLDB, the CLOB keyword was to be replaced with LONGVARCHAR.
OK, so i'm in the Squirrirrel SQL Client changing the CLOB's to LONGVARCHAR. I'm at the last one and I take an error. Any help would be appreciated.
ALTER TABLE ART_QUERIES ALTER COLUMN REPORT_SOURCE LONGVARCHAR;
and i get:
Error: file input/output error in statement [ALTER TABLE ART_QUERIES ALTER COLUMN REPORT_SOURCE LONGVARCHAR]
SQLState: S1000
ErrorCode: -452
yes it is.
Ok. Could you check with your 3.1 installation, where your HSQLDB files are located, if there is a *.lobs file there.
yes, ArtRepositoryDB.lobs
well now i recycled my production server and it wont get out of the
Deploying web application directory /usr/local/tomcat/art8/webapps/art
any thoughts?
This is odd, i built a new tomcat instance based on production, put in the war file and started it up. Its been trying to initialize now for almost an hour and the deploying the art web application directory still is not complete. The last message from a successful run was
art has finished in 189,338 ms
This is really odd. Any ideas how to get this running again?
Thanks,
Ray
You could check the tomcat logs for any errors there.
I checked the logs and found nothing. Looks like tomcat came up fine and gave control to the web application and then nothing.
So my first recommendation would be to go back to a working backup.
ok thanks