BO XiR2 - Troubleshooting

Some frequent errors and fix in BOXiR2

_____________________________________________________________________________________
Problem: 
System hangs, after hitting the Refresh button, while creating/modifying a WebI report which uses a prompt. (Note: Report will run properly if no prompts are included).

Fix:
Check to see if you have Java 5 and Java 6 loaded to your system. If so, have a system administrator remove one of the versions. (Start / Control Panel / Add or Remove Programs / J2SE Runtime Environment [version])
_____________________________________________________________________________________
Problem:
Unable to view a particular universe

Fix:
Need to verify BO XI permissions. Open ticket and submit to PSOCC.SD@randolph.af.mil.
_____________________________________________________________________________________
Problem:
Receive a Web Intelligence message stating “There is no data corresponding to this query.”

Fix:
There are no rows that meet the criteria in the query. Double-check query conditions. Basic logic applies – If using “equals”, there should be only one value If using In List, use semi-colons to separate values (instead of commas) Can’t have a value AND another conflicting value in the same conditions (try OR)
The user may not have permissions to access the data. Open ticket and submit to AFPC/DPDOPI AFCSU.
_____________________________________________________________________________________
Problem:
Connection or SQL sentence error (DA0005)

Fix: 
User is not logged into InfoView; is logged into BO 6.5.
_____________________________________________________________________________________
Problem: 
Your Web Intelligence session has timed out. Log out and log in again to InfoView.

Fix: 
Log out / log back in to InfoView to continue using Web Intelligence (you will lose any unsaved modifications you made previous to timeout).
[NOTE: The timeout session setting is 60 mins.]

_____________________________________________________________________________________
Problem: 
Receiving a log in screen

Fix: 1. 
Make sure you are accessing the correct BO XI URL – even if you have added XI to your Favorites or saved the link as .html to your desktop – please attempt to logon by clicking this link:
https://joshua.afpc.randolph.af.mil
Fix 2. 
Clear the certificate’s cache at: Tools / Internet Options / Content / Clear SSL State May need to exit / re-launch browser Might loop; try approximately 3 times before submitting a ticket
Fix 3.
Remove the Certificates and make them available to Windows Remove Existing Certificates Open Internet Explorer Click Tools...Internet Options Click on the Content tab Click the Certificates button Select the certificates from the Personal tab that have a matching expiration date as the date on her CAC Click the Remove button Close the Internet Explorer windows Make Certificates Available to Windows Click on Start...All Programs...ActivIdentity...ActivClient...User Console Click Tools...Advanced...Make Certificates Available to Windows Click OK Exit the User Console
Fix 4. 
Does user have BO account? Yes: Submit ticket to AFPC/DPDPC AFCSU (afcsu@randolph.af.mil) No: User should submit User ID Request Form (https://ask.afpc.randolph.af.mil/restricted/prodops/SystemAdministration/Docs/1423_AFPCUserIDRequest.doc) to AFPC/DPDPC AFCSU (afcsu@randolph.af.mil)
_____________________________________________________________________________________
Problem: 
“You do not have the right to add objects to the folder” (trying to save DeskI report)
“Your security profile does not include permission to save documents and corporate documents or send documents through InfoView” (trying to save WebI report)
“Unable to save the document to the repository due to the following error: Sorry, you do not have the right to ‘Edit objects’ (id – 6) for ‘*USERNAME+’ (ID – 13927). Please contact your system or permissions administrator if you require this right. (Error: WIS 30567)”

Fix: 
User is trying to save the report to a Public folder. Save it to their private folder under ‘My Folders / Favorites’.
For further detail, see:
https://gum.afpc.randolph.af.mil/cgi-bin/askafpc.cfg/php/enduser/std_adp.php?p_faqid=8564
or search for “Saving Reports” in this document:
https://ask.afpc.randolph.af.mil/Restricted/BusObjects/8332_IntroToBOXIInfoview.pdf
_____________________________________________________________________________________
Problem: 
SQL generation failed. See your Business Objects administrator.

Fix: 
Log out of XI completely, log back in, and try building/running your query again. If this does not work, please contact PSOCC.SD@randolph.af.mil and ask to create a Remedy Ticket.
_____________________________________________________________________________________
Problem:
No server was available to process the request. Please try again later. (Error: RFC 00101) (Error: INF)

Fix: 
Log out of XI completely, log back in, and try building/running your query again. If this does not work, please contact PSOCC.SD@randolph.af.mil and ask to create a Remedy Ticket.
_____________________________________________________________________________________
Problem:
“Unable to retrieve the first page of the current report. Check the report for errors or contact your Database administrator. The report panel will switch to Structure View.”

Fix: 
If working with breaks/sorts: delete all breaks and sorts in the report and add them again.
If removing/re-introducing changes does not work, exit report and start over.
_____________________________________________________________________________________
Problem: 
“Do you want to save this file? Name: doc.zabo_fc” ….

Fix: 
A user without Desktop Intelligence loaded is attempting to Open/Modify a DeskI report. Trying to Open? Modify preferences: In InfoView Panel, Preferences / Desktop Intelligence tab /select HTML or PDF format. For further details, search for “Setting Preferences” in this document: https://ask.afpc.randolph.af.mil/Restricted/BusObjects/8332_IntroToBOXIInfoview.pdf
Trying to Modify a DeskI report? User cannot modify DeskI reports (blue ball icons); only WebI reports (red ball icons). User might search for another report to satisfy requirements (help at https://gum.afpc.randolph.af.mil/cgi-bin/askafpc.cfg/php/enduser/std_adp.php?p_faqid=1432) OR submit a Data Retrieval Request (https://ask.afpc.randolph.af.mil/Restricted/BusObjects/6774_DataRetrievalRequest.doc) to AFPC/DPDOPI AFCSU (afcsu@randolph.af.mil).
_____________________________________________________________________________________
Problem:
“The file is corrupted and cannot be opened.”

Fix:
User attempting to open/save a DeskI report in BO 6.5. User might search for another report to satisfy requirements (help at https://gum.afpc.randolph.af.mil/cgi-bin/askafpc.cfg/php/enduser/std_adp.php?p_faqid=1432) OR submit a Data Retrieval Request (https://ask.afpc.randolph.af.mil/Restricted/BusObjects/6774_DataRetrievalRequest.doc) to AFPC/DPDOPI AFCSU (afcsu@randolph.af.mil).



_____________________________________________________________________________________
Problem: 
“The page cannot be displayed” The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.

Fix:
Close browser window. Attempt to log in again, if message is received again, contact PSOCC.SD@randolph.af.mil.
_____________________________________________________________________________________
Problem: 
When creating a new Web Intelligence report, the screen freezes on the JAVA panel.

Fix: 
Remove the Certificates and make them available to Windows Remove Existing Certificates Open Internet Explorer Click Tools...Internet Options Click on the Content tab Click the Certificates button Select the certificates from the Personal tab that have a matching expiration date as the date on her CAC Click the Remove button Close the Internet Explorer windows Make Certificates Available to Windows Click on Start...All Programs...ActivIdentity...ActivClient...User Console Click Tools...Advanced...Make Certificates Available to Windows Click OK Exit the User Console
_____________________________________________________________________________________
Problem: 
Prompts do not appear when refreshing a Web Intelligence report from the Query Panel.

Fix: 
We are currently looking into to a permanent solution for this problem. However, we have a workaround for this problem.
From the query panel, select the Result Objects and Query Filters you want to use in the report. Click on the Edit Report button Save the report Close the report Navigate to the location of the saved report Open the report Click the Refresh Data button
_____________________________________________________________________________________
Problem:
Can’t print. Click on print icon, a window seems to flash on screen, disappears; nothing happens

Fix: 
Workarounds while we investigate the problem: Hold down the CTRL key before clicking the print icon; keep held down until document prints If still can’t print: Select Document / Save to my computer as / PDF / Open / Print If still can’t print: Save report to Personal folders, close BO XI, re-open, try again (starting with CTRL)
_____________________________________________________________________________________
Problem: 
Not able to see available universes when creating a new Web Intelligence report.

Fix: 
Your preferences are set to use a default universe in Web Intelligence. Follow the steps below to remove the default universe.
Click on the ‘Personalize InfoView now’ link at the top of the page
Select the ‘Web Intelligence Document’ tab Scroll down to the ‘Select default Universe:’ option at the bottom of the page Click the ‘Browse’ button Select ‘No default universe’ Click OK Scroll down and click OK
To set your BO XI Preferences, search for “setting preferences” in this document:
https://ask.afpc.randolph.af.mil/Restricted/BusObjects/8332_IntroToBOXIInfoview.pdf
_____________________________________________________________________________________
Problem: 
Cannot launch JAVA Report Panel, please make sure you have installed a Java virtual machine.

Fix: 1. 
Check the latest version of JAVA installed on your computer Navigate to C:\Program Files\JAVA You will see a directory for each version of JAVA installed. Select the latest version listed. Navigate to the ‘Bin’ directory in that folder Open JAVACPL.exe. (This will open the JAVA Control Panel) Click on the JAVA tab Click on the View button in the JAVA Application Runtime Settings area. (Bottom portion of the window) Disable the all versions except for the latest version by removing the check mark from the box in the ‘Enabled’ column Click OK twice
Fix 2. 
If the above option does not solve the problem, then uninstall and reinstall the JAVA application.