-
Type:
Bug
-
Resolution: Won't Fix
-
Priority:
Medium
-
None
-
Affects Version/s: 2.1 Pro, 2.2.1 Pro, 2.0.2
-
Component/s: None
-
Environment:
Redhat 9 / Tomcat 4.1 / HSQL / Java 1.4.1 02_b06 / WAR version
-
2
Installed new application and imported our exported data (upgrade failed). Warnings:
2003-06-27 10:09:16,068 WARN [core.entity.jdbc.DatabaseUtil] Entity "Issue" has 23 fields but table "jiraissue" has 22 columns.
2003-06-27 10:09:16,068 WARN [core.entity.jdbc.DatabaseUtil] Field "duedate" of entity "Issue" is missing its corresponding column "DUEDATE"
2003-06-27 10:09:16,089 ERROR [core.entity.jdbc.DatabaseUtil] Could not add column "DUEDATE" to table "jiraissue"
2003-06-27 10:09:16,090 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
ALTER TABLE jiraissue ADD DUEDATE TIMESTAMP
Error was: java.sql.SQLException: Unexpected token: TIMESTAMP in statement [ALTER TABLE jiraissue ADD DUEDATE TIMESTAMP]
2003-06-27 10:09:19,288 INFO [atlassian.jira.upgrade.UpgradeManagerImpl] Performing Upgrade Task: Reindexing all data in JIRA to include Issue Level Security values.
2003-06-27 10:09:19,540 ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: Error: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, VOTES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT FROM jiraissue (Column not found: DUEDATE in statement [SELECT ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus,
CREATED, UPDATED, DUEDATE, VOTES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT FROM jiraissue]): SQL Exception while executing the following:SELECT ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, VOTES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT FROM jiraissue (Column not found: DUEDATE in statement [SELECT ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, VOTES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY,FIXFOR, COMPONENT FROM jiraissue])
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:292)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1162)
at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:592)
at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:149)
– Michael van Leeuwen