[daisy] Error: Table JBPM_JOB does not exist

[Lou Parisi]

I figured out what is causing the issue but not sure why or how to fix it.

I am getting a sql error for JBPM_JOB does not exist because of table name
case sensitivity.  I suspect this is a result of restoring the database on
Linux environment from a Windows environment when daisy was moved from
Windows to Linux.  I am using Daisy 2.1 and MySQL 4.1.14

I can reproduce the error using the mysql command line as follows:

mysql> select * from daisyrepository.jbpm_job;
Empty set (0.20 sec)

mysql> select * from daisyrepository.JBPM_JOB;
ERROR 1146 (42S02): Table 'daisyrepository.JBPM_JOB' doesn't exist

My daisyrepository has all lower case names for all of the table names
including the JBPM_ tables.

Comparing to a fresh install of daisy 2.2, all of the JBPM_ tables are upper
case but the rest of the tables are lower case.  

The only option I see is to manually rename the tables to upper case from
the MySQL command line.  Anyone else have a suggestion?



Lou Parisi wrote:
> 
> I am running daisy 2.1 on Linux with MySQL for about 3 months.  I have
> had the repository stop from time to time without known cause.  The only
> thing I see in the daisy.log is an error for the table JBPM_JOB does not
> exist but when I check in mysql I can see the table.  I don't know if
> this is causing my problem but would like to get rid of this error.  I
> also don't know if this error has been occurring since we started using
> daisy or if it is new.
> 
> 

-- 
View this message in context: http://www.nabble.com/Error%3A-Table-JBPM_JOB-does-not-exist-tp15967006p16452224.html
Sent from the Daisy - General mailing list archive at Nabble.com.