Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-22387

OfBiz does not deal with being started under a Turkish locale

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Medium
    • None
    • 4.0, 4.0.1, 4.0.2, 4.1, 4.1.1, 4.1.2, 4.2
    • Installation
    • Trunk 4.2 - r128675, Postgres 8.4.4

    Description

      When starting up JIRA under a Turkish locale you are unable to create issues. It looks like Ofbiz is being hit by http://www.mattryall.net/blog/2009/02/the-infamous-turkish-locale-bug. You get the following warnings and errors:

      2010-09-29 11:13:57,092 main ERROR      [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      ALTER TABLE public.favouriteassociations ADD ID NUMERIC(18,0)
      Error was: org.postgresql.util.PSQLException: ERROR: column "id" of relation "favouriteassociations" already exists
      2010-09-29 11:13:57,092 main WARN      [core.entity.jdbc.DatabaseUtil] Column "?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field
      2010-09-29 11:13:57,092 main WARN      [core.entity.jdbc.DatabaseUtil] Column "DESCR?PT?ON" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field
      2010-09-29 11:13:57,092 main WARN      [core.entity.jdbc.DatabaseUtil] Column "F?ELD?D" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field
      2010-09-29 11:13:57,092 main WARN      [core.entity.jdbc.DatabaseUtil] Column "CUSTOMF?ELD" of table "public.fieldconfigscheme" of entity "FieldConfigScheme" exists in the database but has no corresponding field
      2010-09-29 11:13:57,092 main WARN      [core.entity.jdbc.DatabaseUtil] Field "description" of entity "FieldConfigScheme" is missing its corresponding column "DESCRIPTION"
      2010-09-29 11:13:57,093 main ERROR      [core.entity.jdbc.DatabaseUtil] Could not add column "DESCRIPTION" to table "public.fieldconfigscheme"
      2010-09-29 11:13:57,093 main ERROR      [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      
      2010-09-29 11:14:15,285 main WARN      [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following:
      SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig'
      Error was:
      2010-09-29 11:14:15,285 main WARN      [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?.
      2010-09-29 11:14:15,286 main WARN      [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following:
      SELECT SEQ_ID FROM public.SEQUENCE_VALUE_ITEM WHERE SEQ_NAME='ServiceConfig'
      Error was:
      2010-09-29 11:14:15,286 main WARN      [ofbiz.core.entity.SequenceUtil] Bu ResultSet i<E7>inde SEQ_ID s<FC>tun ad? bulunamad?.
      2010-09-29 11:14:15,286 main ERROR      [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null
      2010-09-29 11:14:15,288 main ERROR      [sal.jira.scheduling.JiraPluginScheduler] Error adding service to jira
      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ServiceConfig][id,null][time,28800000][name,Service Provider Token Remover][clazz,com.atlassian.sal.jira.scheduling.JiraPluginSchedule
      rService] (SQL Exception while executing the following:INSERT INTO public.serviceconfig (ID, delaytime, CLAZZ, servicename) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint))
              at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149)
      
      2010-09-29 12:49:20,291 http-8090-Processor6 ERROR admin 769x2237x1 vqg7s 0:0:0:0:0:0:0:1%0 /secure/CreateIssueDetails.jspa [atlassian.jira.workflow.SimpleWorkflowManager] Error occured while creating issue.
      com.opensymphony.workflow.StoreException: Could not create workflow instance: root cause: while inserting: [GenericEntity:OSWorkflowEntry][id,null][name,jira][state,0] (SQL Exception while executing the following
      :INSERT INTO public.OS_WFENTRY (ID, NAME, INITIALIZED, STATE) VALUES (?, ?, ?, ?) (ERROR: null value in column "id" violates not-null constraint))
              at com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore.createEntry(OfbizWorkflowStore.java:119)
      
      Work around

      The only workaround is to start JIRA under a non-Turkish locale. You can still see JIRA in Turkish when you do this. Check out JRA-22386 for details on how to do this.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              bbain bain
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: