Documentation needed for upgrade error java.sql.SQLException: ORA-12899

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Won't Do
    • Component/s: None
    • None

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      Hi all,

      We need to update our JIRA upgrade documentation for error java.sql.SQLException: ORA-12899.
      The customer is getting the following error during XML import when using Oracle database with utf8.

      2011-07-13 17:12:48,832 pool-5-thread-3 ERROR anonymous 1025x39x1 1uyf1my 10.10.10.217,10.10.10.217 /secure/SetupImport.jspa [jira.action.admin.OfbizImportHandler] Exception importing entity: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,Anasayfa linkini kullanarak anasayfaya dönüldükten sonra, anasayfadan yatırımcı menusune dönülmek istendiğinde doğrudan Mobil Hizmet Tanımlamarı sayfasına dönmektedir. Yatırımcı Bilgilendirme Hizmetleri ilk ekranına dönmesi sağlanmalıdır.][status,6][votes,0][assignee,asuner][resolution,1][type,10][resolutiondate,2008-09-05 15:44:08.0][id,35451][reporter,asuner][project,10310][created,2008-09-04 14:41:11.0][updated,2008-09-17 09:23:58.0][workflowId,166741][priority,5][key,WYP-78] (SQL Exception while executing the following:INSERT INTO jiraissue (ID, pkey, PROJECT, REPORTER, ASSIGNEE, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-12899: value too large for column "JIRATEST"."JIRAISSUE"."SUMMARY" (actual: 260, maximum: 255)
))

      The solution for the problem is :

      When creating an empty database, if database is created using
      "NLS_LENGTH_SEMANTICS = CHAR" in (NLS_DATABASE_PARAMETERS or nls_session_parameters) then there is no problem in XML Import.

      Refereces:

            Assignee:
            Ruchi Tandon (Inactive)
            Reporter:
            Ruchi Tandon (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: