Warnings & Errors while upgrading

XMLWordPrintable

    • 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

            Assignee:
            Unassigned
            Reporter:
            dave (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: