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

Oracle import fails because text field greater than 4000 characters

    XMLWordPrintable

Details

    Description

      Failed to import data. Exception:Error in action: com.atlassian.jira.action.admin.DataImport@12a4674, result: error Exception occurred: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ChangeItem][group,10184][field,description][oldstring,Redo all safeway asset categories and asset category values. OBJECTIVES:
      ...
      Step 11a: script: remove_inactive_assets.sql Step 11b: script: add_assets.sql Step 12a: TG exported the data and loaded it into the Survey Tool. ][id,10230] (SQL Exception while setting value: (Data size bigger than max size for this type: 4104))

      The problem is caused by <oldstring> and <newstring> tags containing text greater than 4000 characters.

      I ran the XSLT stylesheet against an XML backup of my xml exported file. The report shows no descriptions or comments exceeding 4000 chars, however the stylesheet fails to recognize the large text fields in tags <oldstring> and <newstring>.

      What must been done to clean out the old/new text before for running the import to load the Oracle database.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              de0f3f38c05d Dan Riesland
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: