How to fix the exception "d_cloneSheetBySheetName exception: Provider for class javax.xml.parsers.DocumentBuilderFactory cannot be created" when running TIBCO ActiveMatrix BusinessWorks Plug-in for Microsoft Excel
Article ID: KB0075658
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Microsoft Excel | 6.1.1 |
Description
The below exception might happen when using the d_cloneSheetBySheetName function of the TIBCO ActiveMatrix BusinessWorks Plug-in for Microsoft Excel in runtime.
=========================================
ERROR com.tibco.bw.core-TIBCO-BW-CORE-500050: The BW process [test.module.Process] instance faulted, JobId [bw0a101], ProcessInstanceId [bw0a101], ParentProcessInstanceId [-], Module [Tst.module:1.0.0.20191216224322], Application [Tst:1.0].
<CausedBy> TIBCO-BW-CORE-500054: Activity [Log] XSLT transformation error.
<CausedBy> com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
<CausedBy> com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
<CausedBy> com.tibco.xml.cxf.runtime.exceptions.FunctionException: XPath function {http://my.excel.functions}d_cloneSheetBySheetName exception: Provider for class javax.xml.parsers.DocumentBuilderFactory cannot be created
...
com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxXsltExprImpl.eval(IpmxGenxXsltExprImpl.java:65)
at com.tibco.bx.core.behaviors.BxExpressionHelper.evalAsSubject(BxExpressionHelper.java:107)
at com.tibco.bx.core.behaviors.BxExpressionHelper.evaluate(BxExpressionHelper.java:122)
at com.tibco.bx.core.behaviors.BxExpressionHelper.evaluateAndSetInputBindings(BxExpressionHelper.java:284)
at com.tibco.bx.core.behaviors.activity.BxExtensionBehavior.evaluateInputBindings(BxExtensionBehavior.java:111)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.doEnter(BxActivityBaseBehavior.java:592)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.enter(BxActivityBaseBehavior.java:488)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.enter(BxActivityBaseBehavior.java:1)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:192)
at com.tibco.pvm.im.rt.xm.util.work.ImxEventDirector.invokeModelEvent(ImxEventDirector.java:30)
at com.tibco.pvm.im.rt.xm.util.work.ImxProcessWork.invokeModelEvent(ImxProcessWork.java:125)
at com.tibco.pvm.im.rt.xm.ImxInstControl.invokeModelEvent(ImxInstControl.java:145)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.invokeEnterOnSuccessors(BxLinkBehavior.java:441)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.eval(BxLinkBehavior.java:226)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.enter(BxLinkBehavior.java:74)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.enter(BxLinkBehavior.java:1)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:192)
at com.tibco.pvm.im.rt.xm.util.work.ImxEventDirector.invokeModelEvent(ImxEventDirector.java:30)
at com.tibco.pvm.im.rt.xm.util.work.ImxProcessWork.invokeModelEvent(ImxProcessWork.java:125)
at com.tibco.pvm.im.rt.xm.ImxInstControl.invokeModelEvent(ImxInstControl.java:145)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.invokeEnterOnSuccessors(BxActivityBaseBehavior.java:3292)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.handleStateChange(BxActivityBaseBehavior.java:1867)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.eval(BxActivityBaseBehavior.java:925)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.eval(BxActivityBaseBehavior.java:1)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:195)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleEvent(IpmEventDirectorBase.java:111)
at com.tibco.pvm.infra.support.work.impl.WorkItemAbstract.execute(WorkItemAbstract.java:177)
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.doWorkBlock(ImxSTWorkRunnable.java:170)
at com.tibco.pvm.infra.services.engine.impl.STWorkRunnable.run(STWorkRunnable.java:50)
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.run(ImxSTWorkRunnable.java:62)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxPathHelper.doXslTransform(IpmxGenxPathHelper.java:163)
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxXsltExprImpl.eval(IpmxGenxXsltExprImpl.java:58)
... 32 more
Caused by: com.tibco.xml.cxf.runtime.exceptions.FunctionException: XPath function {http://my.excel.functions}d_cloneSheetBySheetName exception: Provider for class javax.xml.parsers.DocumentBuilderFactory cannot be created
at com.tibco.xml.cxf.runtime.impl.CustomXPathFunctionEvalUtils.evaluateFunc(CustomXPathFunctionEvalUtils.java:71)
at com.tibco.xml.cxf.runtime.impl.CustomXPathBooleanTypeFunction.booleanValue(CustomXPathBooleanTypeFunction.java:68)
at org.genxdm.processor.xpath.v20.widget.AbstractOptionalBooleanTypeExpr.atom(AbstractOptionalBooleanTypeExpr.java:23)
at org.genxdm.processor.xpath.v20.widget.AbstractOptionalBooleanTypeExpr.evaluate(AbstractOptionalBooleanTypeExpr.java:52)
at com.tibco.genxdm.processor.xslt.exprimpl.TxSimpleContentHelper.constructSimpleContent(TxSimpleContentHelper.java:34)
at com.tibco.genxdm.processor.xslt.exprimpl.TxValueOfExpr.stream(TxValueOfExpr.java:29)
at com.tibco.genxdm.processor.xslt.exprimpl.TxLiteralResultElementExpr.stream(TxLiteralResultElementExpr.java:93)
at com.tibco.genxdm.processor.xslt.exprimpl.TxLiteralResultElementExpr.stream(TxLiteralResultElementExpr.java:93)
at com.tibco.genxdm.processor.xslt.exprimpl.TxTemplateExpr.stream(TxTemplateExpr.java:111)
at com.tibco.genxdm.processor.xslt.exprimpl.DefaultModuleTransformExpr.executeMatchingOrBuiltInTemplateRule(DefaultModuleTransformExpr.java:491)
at com.tibco.genxdm.processor.xslt.exprimpl.DefaultModuleTransformExpr.document(DefaultModuleTransformExpr.java:135)
at com.tibco.genxdm.processor.xslt.exprimpl.DefaultModuleTransformExpr.document(DefaultModuleTransformExpr.java:60)
at com.tibco.genxdm.processor.xslt.XSLTransformer.transform(XSLTransformer.java:159)
at com.tibco.genxdm.processor.xslt.XSLTransformer.transform(XSLTransformer.java:77)
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxPathHelper.doXslTransform(IpmxGenxPathHelper.java:154)
... 33 more
=========================================
=========================================
ERROR com.tibco.bw.core-TIBCO-BW-CORE-500050: The BW process [test.module.Process] instance faulted, JobId [bw0a101], ProcessInstanceId [bw0a101], ParentProcessInstanceId [-], Module [Tst.module:1.0.0.20191216224322], Application [Tst:1.0].
<CausedBy> TIBCO-BW-CORE-500054: Activity [Log] XSLT transformation error.
<CausedBy> com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
<CausedBy> com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
<CausedBy> com.tibco.xml.cxf.runtime.exceptions.FunctionException: XPath function {http://my.excel.functions}d_cloneSheetBySheetName exception: Provider for class javax.xml.parsers.DocumentBuilderFactory cannot be created
...
com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxXsltExprImpl.eval(IpmxGenxXsltExprImpl.java:65)
at com.tibco.bx.core.behaviors.BxExpressionHelper.evalAsSubject(BxExpressionHelper.java:107)
at com.tibco.bx.core.behaviors.BxExpressionHelper.evaluate(BxExpressionHelper.java:122)
at com.tibco.bx.core.behaviors.BxExpressionHelper.evaluateAndSetInputBindings(BxExpressionHelper.java:284)
at com.tibco.bx.core.behaviors.activity.BxExtensionBehavior.evaluateInputBindings(BxExtensionBehavior.java:111)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.doEnter(BxActivityBaseBehavior.java:592)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.enter(BxActivityBaseBehavior.java:488)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.enter(BxActivityBaseBehavior.java:1)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:192)
at com.tibco.pvm.im.rt.xm.util.work.ImxEventDirector.invokeModelEvent(ImxEventDirector.java:30)
at com.tibco.pvm.im.rt.xm.util.work.ImxProcessWork.invokeModelEvent(ImxProcessWork.java:125)
at com.tibco.pvm.im.rt.xm.ImxInstControl.invokeModelEvent(ImxInstControl.java:145)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.invokeEnterOnSuccessors(BxLinkBehavior.java:441)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.eval(BxLinkBehavior.java:226)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.enter(BxLinkBehavior.java:74)
at com.tibco.bx.core.behaviors.link.BxLinkBehavior.enter(BxLinkBehavior.java:1)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:192)
at com.tibco.pvm.im.rt.xm.util.work.ImxEventDirector.invokeModelEvent(ImxEventDirector.java:30)
at com.tibco.pvm.im.rt.xm.util.work.ImxProcessWork.invokeModelEvent(ImxProcessWork.java:125)
at com.tibco.pvm.im.rt.xm.ImxInstControl.invokeModelEvent(ImxInstControl.java:145)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.invokeEnterOnSuccessors(BxActivityBaseBehavior.java:3292)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.handleStateChange(BxActivityBaseBehavior.java:1867)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.eval(BxActivityBaseBehavior.java:925)
at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.eval(BxActivityBaseBehavior.java:1)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:195)
at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleEvent(IpmEventDirectorBase.java:111)
at com.tibco.pvm.infra.support.work.impl.WorkItemAbstract.execute(WorkItemAbstract.java:177)
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.doWorkBlock(ImxSTWorkRunnable.java:170)
at com.tibco.pvm.infra.services.engine.impl.STWorkRunnable.run(STWorkRunnable.java:50)
at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.run(ImxSTWorkRunnable.java:62)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.tibco.pvm.dataexch.xml.util.exceptions.PmxException: PVM-XML-106027: Transformation failed for XSLT input '<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns3="http://www.tibco.com/pe/WriteToLogActivitySchema" xmlns:Excel="http://my.excel.functions" version="2.0"><xsl:template name="Log-input" match="/"><tns3:ActivityInput><message><xsl:value-of select="Excel:d_cloneSheetBySheetName("D:\Test.xlsx", "xxxxx Criteria (PxDx level)", "New Tab")"/></message></tns3:ActivityInput></xsl:template></xsl:stylesheet>'
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxPathHelper.doXslTransform(IpmxGenxPathHelper.java:163)
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxXsltExprImpl.eval(IpmxGenxXsltExprImpl.java:58)
... 32 more
Caused by: com.tibco.xml.cxf.runtime.exceptions.FunctionException: XPath function {http://my.excel.functions}d_cloneSheetBySheetName exception: Provider for class javax.xml.parsers.DocumentBuilderFactory cannot be created
at com.tibco.xml.cxf.runtime.impl.CustomXPathFunctionEvalUtils.evaluateFunc(CustomXPathFunctionEvalUtils.java:71)
at com.tibco.xml.cxf.runtime.impl.CustomXPathBooleanTypeFunction.booleanValue(CustomXPathBooleanTypeFunction.java:68)
at org.genxdm.processor.xpath.v20.widget.AbstractOptionalBooleanTypeExpr.atom(AbstractOptionalBooleanTypeExpr.java:23)
at org.genxdm.processor.xpath.v20.widget.AbstractOptionalBooleanTypeExpr.evaluate(AbstractOptionalBooleanTypeExpr.java:52)
at com.tibco.genxdm.processor.xslt.exprimpl.TxSimpleContentHelper.constructSimpleContent(TxSimpleContentHelper.java:34)
at com.tibco.genxdm.processor.xslt.exprimpl.TxValueOfExpr.stream(TxValueOfExpr.java:29)
at com.tibco.genxdm.processor.xslt.exprimpl.TxLiteralResultElementExpr.stream(TxLiteralResultElementExpr.java:93)
at com.tibco.genxdm.processor.xslt.exprimpl.TxLiteralResultElementExpr.stream(TxLiteralResultElementExpr.java:93)
at com.tibco.genxdm.processor.xslt.exprimpl.TxTemplateExpr.stream(TxTemplateExpr.java:111)
at com.tibco.genxdm.processor.xslt.exprimpl.DefaultModuleTransformExpr.executeMatchingOrBuiltInTemplateRule(DefaultModuleTransformExpr.java:491)
at com.tibco.genxdm.processor.xslt.exprimpl.DefaultModuleTransformExpr.document(DefaultModuleTransformExpr.java:135)
at com.tibco.genxdm.processor.xslt.exprimpl.DefaultModuleTransformExpr.document(DefaultModuleTransformExpr.java:60)
at com.tibco.genxdm.processor.xslt.XSLTransformer.transform(XSLTransformer.java:159)
at com.tibco.genxdm.processor.xslt.XSLTransformer.transform(XSLTransformer.java:77)
at com.tibco.pvm.infra.dataexch.xml.genxdm.expr.IpmxGenxPathHelper.doXslTransform(IpmxGenxPathHelper.java:154)
... 33 more
=========================================
Issue/Introduction
How to fix the exception "d_cloneSheetBySheetName exception: Provider for class javax.xml.parsers.DocumentBuilderFactory cannot be created" when running TIBCO ActiveMatrix BusinessWorks Plug-in for Microsoft Excel
Environment
Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Microsoft Excel
Version: 6.1.1
OS: All Supported Operating Systems
Resolution
The issue could be resolved by adding the below properties in the appnode TRA file & restart the appnode & application.
java.extended.properties=-Djavax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl -Djavax.xml.parsers.SAXParserFactory=com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl -Djavax.xml.transform.TransformerFactory=com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl
java.extended.properties=-Djavax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl -Djavax.xml.parsers.SAXParserFactory=com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl -Djavax.xml.transform.TransformerFactory=com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl
Feedback
Yes
No
Powered by
