Categories
- All Categories
- 72 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 39 Oracle Analytics Trainings
- 58 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
BI Publisher Preview Issues_Cannot Preview a Report in any format
Summary
BI Publisher Throwing File Not Found Errors When Trying to Preview a Report
Content
Good afternoon,
I have redownloaded BI Publisher Office 32-bit extensions from Oracles webpage, and after creating a report template I am getting the below error when previewing in Excel and Word RTF templates. I will upload various screenshots if needed, The metadata.dxo tab on my excel spreadsheets is loaded as they work just fine in OBTI and BIP. I keep seeing these files not found related to the .jar and local template builder files, and when I navigate to the network drives I see them just fine.
Any thoughts, Oracles vast treasure trove is not giving me anything useful so far? Appreciate your time!
Error Message:
ETBExcelObject _metadatasheet is null.
XDO_METADATA is not null
ETBExcelObject isCellInside cv: =Sheet1!$A$3
ETBExcelObject getETBFields start
ETBExcelObject getETBFields end
ETBExcelObject setCellName label: C.C.T.E.A./C.E.A. N.E.A
ETBExcelObject setCellName newname: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject setCellName label: 18457
ETBExcelObject setCellName newname: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject setCellName label: Jan_FY21
ETBExcelObject setCellName newname: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject setCellName label: L-0108214
ETBExcelObject setCellName newname: XDO_?XDOFIELD4?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD4?
ETBExcelObject setCellName label: 01/08/21
ETBExcelObject setCellName newname: XDO_?XDOFIELD5?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD4?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD5?
ETBExcelObject setCellName label: 4768
ETBExcelObject setCellName newname: XDO_?XDOFIELD6?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD4?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD5?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD6?
ETBExcelObject setCellName label: 4768
ETBExcelObject setCellName newname: XDO_?XDOFIELD7?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD4?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD5?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD6?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD7?
ETBExcelObject setCellName label: 10.0000.000.0000.742170.00000.00000.00.0000
ETBExcelObject setCellName newname: XDO_?XDOFIELD8?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD4?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD5?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD6?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD7?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD8?
ETBExcelObject setCellName label: 01/08/21
ETBExcelObject setCellName newname: XDO_?XDOFIELD9?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD4?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD5?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD6?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD7?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD8?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD9?
ETBExcelObject setCellName label: 10
ETBExcelObject setCellName newname: XDO_?XDOFIELD10?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD1?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD2?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD3?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD4?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD5?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD6?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD7?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD8?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD9?
ETBExcelObject getDefinedNames Added: XDO_?XDOFIELD10?
………………..
javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml"
File not found.
javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml"
File not found.
javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml"
File not found.
javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml"
File not found.
………………..
javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml"
File not found.
javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml"
File not found.
Sean Curry
Version
32 Bit BI Publisher Desktop
Code Snippet
……………….. javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml" File not found. javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml" File not found. javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml" File not found. javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml" File not found. ……………….. javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml" File not found. javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\ExcelRunner.jar" "C:\Users\scurry3\AppData\Local\Oracle\BIPublisher\TemplateBuilderforExcel\tmp\etb_param.xml" File not found.
Answers
-
Please see if below solution works for you may be you need update latest jre path
First set the Java Home in BI Publisher > Options -- Give the jre path which you are using.
Otherwise
Go to Environment variables
Both in system and user variables
Enter JAVA_HOME and value as "C:\Program Files (x86)\Java\jre1.8.0_101" -> see latest jre version
Then Restart excel and you will be able to preview it.
0 -
Worked like a charm.
Thanks Syed!
0 -
Worked like a charm.
Thanks Syed!
0