Pages

Friday 24 April 2015

500 INTERNAL SERVER ERROR SharePoint Site 2013

When I tried to open one of my Site Collections then I got the following error message:
SharePoint 2013 HTTP 500 Internal Server Error
HTTP 500 Internal Server Error
Issue: Website cannot display the page due to HTTP 500 Internal Server Error.
I tried to do open SharePoint Central Administration, to see if I get the same error message. Strangely, I was able to open Central Administration without any errors.

I opened IIS Manager to make sure SharePoint – 80 Application Pool was running, and I noticed that SecurityTokenServiceApplicationPoolapplication pool was stopped.

I started SecurityTokenServiceApplicationPool application pool, refreshed my SharePoint site but that didn't resolve the issue. I opened IIS manager and noticed.that SecurityTokenServiceApplicationPool was stopped again.

I Check the IIS events log to check what’s the issue with SecurityTokenServiceApplicationPool application pool. 
Solution:
The Disable-SPSessionStateService cmdlet turns off the session state service. If your farm does not depend on session state service, we recommend that you disable it.

We can disable session state by Disable-SPSessionStateService command. 
Disable-SPSessionStateService 
We have some optional parameters to disable session state. We can write the command as  
Disable-SPSessionStateService -AssignmentCollection AssignmentCollectionForSharePoint -ConfirmConfirmationSwitchParameter –WhatIf ConfirmationSwitchParameter

Wednesday 8 April 2015

Subscripts and Superscripts in SSRS Reports

Display the following in SSRS:
Chemical Mathematical equation
Solution 1
1. Note down the following codes
Superscript and subscript codes
2. Use expressions along with the chrw function in textbox.
Eg:- ="a"&chrw(8304)&chrw(185)&chrw(178)&chrw(179)&chrw(8308)&chrw(8309)&chrw(8310)&chrw(8311)&chrw(8312)&chrw(8313)
Expression builder
3. Make sure that the font is Lucida Sans Unicode.
Font
4. Now you can preview the result.
Preview report

Solution 2
1. Click on StartRun and type charmap.exe. Click OK.
Run window
2. Change the font to Lucida Sans Unicode and then find the character that you need. For eg, Subscript Two is selected in the image below.
Charmap
Once that is selected, click on Select and continue writing your chemical/mathematical equation in the same way.
3. Once that is done, click on copy button (and not Ctrl+C or any other shortcut button) and all you have to do is to paste it in a textbox in the report. Make sure that the font is Lucida Sans Unicode for the textbox.
Textbox with chemical equation
4. Click on preview and you will have the equation that you wanted.
Preview report with equation
Note : You can select any character in the Character Map and then use the chrw function. For that, note down the number in the character map (for eg, in the image above for Step 2, the number for Subscript 2 is 2082) and convert it from hex to binary (You can use sites like this for converting it if you don’t want to do the maths) and then use it within the chrw().