Troubleshooting MSOffice Plug-In With OBIEE In 10.1.3.3



Generating Log files
The procedure to generate client log is as follows:
Client log:
1. Open Excel/PPT and go to About Oracle BI from the Oracle BI Menu
2. Press Ctrl + L
3. A dialog will appear to enable logging
4. Select all levels to be logged, close this dialog
5. Now try to login and set the error message
6. From windows explorer, go to folder where you installed the add-in, typically it is
“c:\program files\Oracle\BiOfficeExcel” or “c:\program files\Oracle\BiOfficePowerPoint” depending on whether if you are running Excel or PowerPoint respectively.
7. In the Log folder under the above, zip the log files generated.

 
Server log:
To enable server log, open the server config file at the installed bioffice application dir:
WEB-INF\bioffice.xml

 
Change the LogLevel property to 5 (debug):
    <!– LogLevel Never = 1; Error = 2; Warning = 3; Msg = 4; Debug = 5; –>
    <property name=”LogLevel” type=”int”>5</property>

 
 Then go back to Office Excel Client, try connecting to Office Server again. The server log file location is:
WEB-INF\log\bioffice_[Today's Date].log