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

HTML entities are not encoded as part of the XML backup, causing failure during restore

XMLWordPrintable

      Ive just found a bunch of HTML entities in a zip backup causing it to fail.

      This causes restores to fail:

      Errors
          * Error importing data: org.apache.commons.lang.exception.NestableException: 
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,35542]
      [body,Copyright symbol html entity is Α -->http://htmlhelp.com/reference/html40/entities/][author,aguy][updated,2007-06-12 12:22:32.043]
      [created,2007-06-12 12:22:32.043][issue,20512][type,comment][updateauthor,aguy] 
      (SQL Exception while executing the following:INSERT INTO DB2INST1.jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, 
      CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
      (DB2 SQL Error: SQLCODE=-1218, SQLSTATE=57011, SQLERRMC=4098, DRIVER=3.50.152))
      

      913 is Greek 'Alpha', http://htmlhelp.com/reference/html40/entities/symbols.html, if there is one, there will be many more.

      I'm donning my SED hat to see if I can fix the backup temporarily, however, I would have hoped that the export would have HTML encoded any weird characters so the restore would work (and subsequently _de_code such characters.

      If there is a problem in using these characters, Jira should fix the problem on data entry...

            Unassigned Unassigned
            4065af06a75f Andy Brook (Javahollic Software)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: