JR58416: HOW TO HANDLE EXCEL FILES WITH DAM

IBM InfoSphere Master Data Management Collaboration Server Version 11.6.0, Fix Pack 5

APAR status

• Closed as program error.

Error description

• We want to handle Excel files with DAM (Digital Asset
  Management). When we tried to upload a Excel file to MDM using
  DAM UI, the operation was failed. The part of appsvr log is
  below.
  
  
  2017-06-08 12:33:18,884 [jsp_1516: saveEntries.wpc] ERROR
  com.ibm.pim.web.commands.components.AuthoringToolbarCommand -
  CWPCM0001E:Generic error / Exception : ,
  Exception:org/apache/poi/xssf/extractor/XSSFEventBasedExcelExtra
  ctor.setLocale(Ljava/util/Locale;)V (loaded from
  file:/opt/IBM/MDMCE/jars/poi-ooxml-3.7.jar by
  sun.misc.Launcher$AppClassLoader@fc1902a0) called from class
  org.apache.tika.parser.microsoft.ooxml.XSSFExcelExtractorDecorat
  or (loaded
  fromfile:/opt/IBM/MDMCE/etc/default/dam/jars/tika-app-1.9.jar
  by
  sun.misc.Launcher$AppClassLoader@fc1902a0).java.lang.NoSuchMetho
  dError:
  org/apache/poi/xssf/extractor/XSSFEventBasedExcelExtractor.setLo
  cale(Ljava/util/Locale;)V (loaded from
  file:/opt/IBM/MDMCE/jars/poi-ooxml-3.7.jar by
  sun.misc.Launcher$AppClassLoader@fc1902a0) called from class
  org.apache.tika.parser.microsoft.ooxml.XSSFExcelExtractorDecorat
  or
  (loaded from
  file:/opt/IBM/MDMCE/etc/default/dam/jars/tika-app-1.9.jar by
  sun.misc.Launcher$AppClassLoader@fc1902a0).
          at
  org.apache.tika.parser.microsoft.ooxml.XSSFExcelExtractorDecorat
  or.<init>(XSSFExcelExtractorDecorator.java:80)
          at
  org.apache.tika.parser.microsoft.ooxml.OOXMLExtractorFactory.par
  se(OOXMLExtractorFactory.java:90)
          at
  org.apache.tika.parser.microsoft.ooxml.OOXMLParser.parse(OOXMLPa
  rser.java:82)
          at
  org.apache.tika.parser.CompositeParser.parse(CompositeParser.jav
  a:281)
          at
  org.apache.tika.parser.CompositeParser.parse(CompositeParser.jav
  a:281)
          at
  org.apache.tika.parser.AutoDetectParser.parse(AutoDetectParser.j
  ava:120)
          at
  com.ibm.tech.dam.services.commands.MetaExtractorCommand.execute(
  MetaExtractorCommand.java:30)
          at
  org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:1
  66)
          at
  com.ibm.tech.dam.services.ServiceChainLoader.execute(ServiceChai
  nLoader.java:113)
          at
  com.ibm.tech.dam.services.ServiceChainLoader.execute(ServiceChai
  nLoader.java:120)
          at
  com.ibm.ts.fs.vfs.providers.common.RepositoryManager.processItem
  Events(RepositoryManager.java
  
  
  MDM version is 11.6 and DAM is in the
  IBM_InfoSphere_Master_Data_Management_IWM_Samples_v11.6.0.1.zip.
  As datamodel.zip is missing in this zip, I use
  dam_datamodel.zip from
  mdmsamples of MDM11.5
  

Local fix

• Not available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Master Data Management Collaboration Server              *
  * implementations are affected by this issue.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * We want to handle Excel files with DAM (Digital Asset        *
  * Management). When we tried to upload a Excel file to MDM     *
  * using                                                        *
  * DAM UI, the operation was failed. The part of appsvr log is  *
  * below.                                                       *
  *                                                              *
  *                                                              *
  * 2017-06-08 12:33:18,884 [jsp_1516: saveEntries.wpc] ERROR    *
  * com.ibm.pim.web.commands.components.AuthoringToolbarCommand  *
  * -                                                            *
  * CWPCM0001E:Generic error / Exception : ,                     *
  * Exception:org/apache/poi/xssf/extractor/XSSFEventBasedExcelE *
  * xtra                                                         *
  * ctor.setLocale(Ljava/util/Locale;)V (loaded from             *
  * file:/opt/IBM/MDMCE/jars/poi-ooxml-3.7.jar by                *
  * sun.misc.Launcher$AppClassLoader@fc1902a0) called from class *
  * org.apache.tika.parser.microsoft.ooxml.XSSFExcelExtractorDec *
  * orat                                                         *
  * or (loaded                                                   *
  * fromfile:/opt/IBM/MDMCE/etc/default/dam/jars/tika-app-1.9.ja *
  * r                                                            *
  * by                                                           *
  * sun.misc.Launcher$AppClassLoader@fc1902a0).java.lang.NoSuchM *
  * etho                                                         *
  * dError:                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix for this problem has been included in Master Data
  Management Collaboration Server version 11.6 FP06.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  MDM SERVER FOR

• Fixed component ID

  5724V5100

Applicable component levels