Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-20070

XML stored in database should have valid XML format

    XMLWordPrintable

Details

    Description

      Issue

      When selecting Use custom artifact handler settings under Plan configuration >> Miscellaneous >> Artifact handlers OR running Java Bamboo Specs, malformed XML tag(s) get added to build_definition.xml_definition_data. This prevent SQL XPATH from running due to XML malformation.

      Bamboo Specs sample

      .put("artifactHandlers", new MapBuilder()
          .put("comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:enabledForShared", "false")
          .put("comAtlassianBambooPluginArtifactHandlerLocal:ServerLocalArtifactHandler:enabledForNonShared", "true")
          .put("comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:enabledForNonShared", "false")
          .put("comAtlassianBambooPluginArtifactHandlerRemote:BambooRemoteArtifactHandler:enabledForShared", "false")
          .put("useCustomArtifactHandlers", "false")
          .put("comAtlassianBambooPluginArtifactHandlerLocal:ServerLocalArtifactHandler:enabledForShared", "true")
          .put("comAtlassianBambooPluginArtifactHandlerRemote:AgentLocalArtifactHandler:enabledForShared", "true")
          .put("comAtlassianBambooPluginArtifactHandlerRemote:BambooRemoteArtifactHandler:enabledForNonShared", "false")
          .put("comAtlassianBambooPluginArtifactHandlerRemote:AgentLocalArtifactHandler:enabledForNonShared", "false")
          .build())
      

      Result in database

      <artifactHandlers>
        <comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:enabledForShared>false</comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:enabledForShared>
        <comAtlassianBambooPluginArtifactHandlerRemote:BambooRemoteArtifactHandler:enabledForShared>false</comAtlassianBambooPluginArtifactHandlerRemote:BambooRemoteArtifactHandler:enabledForShared>
        <comAtlassianBambooPluginArtifactHandlerLocal:ServerLocalArtifactHandler:enabledForNonShared>true</comAtlassianBambooPluginArtifactHandlerLocal:ServerLocalArtifactHandler:enabledForNonShared>
        <comAtlassianBambooPluginArtifactHandlerRemote:AgentLocalArtifactHandler:enabledForNonShared>false</comAtlassianBambooPluginArtifactHandlerRemote:AgentLocalArtifactHandler:enabledForNonShared>
        <comAtlassianBambooPluginArtifactHandlerRemote:AgentLocalArtifactHandler:enabledForShared>true</comAtlassianBambooPluginArtifactHandlerRemote:AgentLocalArtifactHandler:enabledForShared>
        <comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:enabledForNonShared>false</comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:enabledForNonShared>
        <comAtlassianBambooPluginArtifactHandlerLocal:ServerLocalArtifactHandler:enabledForShared>true</comAtlassianBambooPluginArtifactHandlerLocal:ServerLocalArtifactHandler:enabledForShared>
        <useCustomArtifactHandlers>false</useCustomArtifactHandlers>
        <comAtlassianBambooPluginArtifactHandlerRemote:BambooRemoteArtifactHandler:enabledForNonShared>false</comAtlassianBambooPluginArtifactHandlerRemote:BambooRemoteArtifactHandler:enabledForNonShared>
      </artifactHandlers>
      

      Error thrown

      When running XPATH against column, the following gets thrown:

      # from Oracle Database
      
      [Code: 31011, SQL State: 99999]  ORA-31011: XML parsing failed
      ORA-19213: error occurred in XML processing at lines 45
      LPX-00240: element-start tag is not well formed
      ORA-06512: at "SYS.XMLTYPE", line 272
      ORA-06512: at line 1
      
      # from PostgreSQL Database
      
      [Code: , SQL State: 2200M]  ERROR: could not parse XML document
        Detail: line 45: Failed to parse QName 'comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:'
            <comAtlassianBambooPluginArtifactHandlerRemote:S3ArtifactHandler:enabledFo
                                                                            ^
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rsperafico Rafael Sperafico (Inactive)
              Votes:
              10 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: