Menu

Friday, September 28, 2012

How To: BI Publisher 8 Desktop Preview Template does not work

When previewing a vanilla BI Publisher template (srvreqaa.rtf) for "Service Request Activity - All" report that comes with the Siebel installation in BI Publisher Desktop the following error is thrown :

ConfFile: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config\xdoconfig.xml
Font Dir: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\fonts
Run XDO Start
Template: C:\Documents and Settings\Administrator\Desktop\aclist_sample.rtf
RTFProcessor setLocale: en-us
FOProcessor setData: E:\Sia811\siebsrvr\XMLP\DATA\BIP Accounts Sample.xml
FOProcessor setLocale: en-us
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
at RTF2PDF.runRTFto(RTF2PDF.java:629)
at RTF2PDF.runXDO(RTF2PDF.java:442)
at RTF2PDF.main(RTF2PDF.java:289)
Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Class not found 'com.siebel.xmlpublisher.reports.XSLFunctions'
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)

Some of the standard Siebel templates contain references to functions that are included in specific .jar files and if these are not loaded prior to opening the RTF template, then the preview will fail with the aforementioned error.

 In order to resolve the behavior the following procedure can be used :

1) Locate the following files which should be available in the %SIEBEL_CLIENT_ROOT%\CLASSES folder :
SiebelXMLP.jar
Siebel.jar
XSLFunctions.jar
SiebelCustomXMLP.jar
SiebelCustomXMLP_SIA.jar

2) Close all Microsoft Word sessions

3) Create a .bat file (startword.bat), and run it before opening the RTF template.
 
The .bat file should contain the following text :
echo %1
set _JAVA_OPTIONS=-Xbootclasspath/a:D:\811\Client\CLASSES\SiebelXMLP.jar;D:\811\Client\CLASSES\Siebel.jar;D:\811\Client\CLASSES\XSLFunctions.jar;D:\811\Client\CLASSES\SiebelCustomXMLP.jar;D:\811\Client\CLASSES\SiebelCustomXMLP_SIA.jar;
"D:\Program Files\Microsoft Office\Office12\Winword.exe" %1

No comments:

Post a Comment