Hello all.
We are using BI publisher as our rendering, for basic standard rendering it works fine.
But I created a report query, downloaded the report query, used MS word and the BI publisher desktop to create a report. I can load the XML data from the report query and the report previews just fine in MS word. I upload the RTF back into APEX as a report layout and set the report query to use the layout. When I go to test the report, I can generate the XML just fine. But when I try to test the report, or run the report from somewhere in the APEX application I get the
"Adobe Reader cold not open 'testreport[2].pdf' because it is either not a supported file type... etc"
If I set the query to be generic layout, the PDF generates just fine.
When I get the adobe error, the BI publisher log shows:
[082907_075837783][oracle.apps.xdo.common.xml.XSLTWrapper][EXCEPTION] XSL error:
<Line 650, Column 168>: XML-20221: (Fatal Error) Invalid char in text.
<Line 816, Column 168>: XML-20221: (Fatal Error) Invalid char in text.
[082907_075837798][][EXCEPTION] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(Unknown S
ource)
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.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 oracle.apps.xdo.servlet.Converter.process(Converter.java:302)
at oracle.apps.xdo.servlet.Converter.render(Converter.java:231)
at oracle.apps.xdo.servlet.Converter.doPost(Converter.java:95)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletReque
stDispatcher.java:711)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(Ser
vletRequestDispatcher.java:368)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequ
estHandler.java:866)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpReques
tHandler.java:448)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpReque
stHandler.java:216)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.ja
va:117)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.ja
va:110)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSo
cketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(Server
SocketAcceptHandler.java:239)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocket
AcceptHandler.java:34)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(
ServerSocketAcceptHandler.java:880)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(Relea
sableResourcePooledExecutor.java:298)
at java.lang.Thread.run(Thread.java:595)
Caused by: oracle.xdo.parser.v2.XMLParseException: Invalid char in text.
at oracle.xdo.parser.v2.XSLProcessor.reportException(XSLProcessor.java:7
82)
at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:
564)
... 30 more
We are using APEX 3.0.0.00.20 on a 10.1.0.2.0 database.
I have tried this many different times and I can not determine what the problem with the RTF is.
any ideas on what I am missing?