Excel Web Access : Graph Not Showing

Issue:

User claimed that he cannot see his graph in Excel when viewing it from browser.

Solution:

Font used by the graph is not web-compatible. Changing the font to web-compatible font (e.g. Verdana/Arial) solve the issue.

Product Configuration Wizard : Stopped at Step 9 After Changed Farm Passphrase

Issue:

Farm passphrase changed using Powershell but not reflected when running Product Configuration Wizard. Throw error on Step 9.

Solution:

1. Stop all SharePoint Timer Service in all SharePoint servers.
2. While SharePoint Timer Service stopped, clear SharePoint cache in all SharePoint servers; one by one.
1. Go to %SystemDrive%\ProgramData\Microsoft\SharePoint\Config. There will be 2 folders here. One has a GUID name, the other is not.
2. Open the non-GUID folder which consists of PERSISTEDFILE files. 
1. Delete all PERSISTEDFILE files.
3. Open the GUID folder which consists of XML and INI file. 
1. Open INI file and change the value to 1. Save it.
2. Delete all XML files.
3. Repeat step 2 to another SharePoint servers.
4. Once completed, start again the SharePoint Timer Service.
5. SharePoint will rebuilt again all XML in GUID folder. It will take a while to complete the process. I recommend you to leave it around an hour before proceed with next step.
6. Check the GUID folder again. INI file value has now been changed, and all XML files has been rebuild.
7. Re-run the Product Configuration Wizard. It should work by now.

p/s: You can also use this solution on your corrupted Search Service Application.