Pages

Tuesday, January 15, 2019

Recovering the suspected SharePoint 2013 Config database

Issue:

Central Administrator site not accessible.



Open SQL Server -- New Query, run these command to repair the SharePoint config database.




— Use the Master database 
Use Master

— Verify that database has issues 
EXEC sp_resetstatus 'SharePoint_Config'

— Put the database in emergency mode 
ALTER DATABASE SharePoint_Config SET EMERGENCY 
DBCC checkdb('SharePoint_Config')

— Set the database in single user mode 
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE

— Repair the database with data loss 
DBCC CheckDB ('SharePoint_Config', REPAIR_ALLOW_DATA_LOSS)

— Set the database in multi-user mode 
ALTER DATABASE SharePoint_Config SET MULTI_USER

— Verify that database is reset 
EXEC sp_resetstatus 'SharePoint_Config'

Friday, January 11, 2019

Sharepoint Online - Quick Edit supports JS Link and Client Side Rendering

The sharepoint online list quick edit (Data Sheet View) would support Client Side Rendering Code (CSR).

when I renamed a file to become “kar.txt” it turns the background green &  text white colour tag.   This could be leveraged to give end users real-time feedback on the values entered.   Unlike a JQuery page load event which only triggers once, this triggers per row as values are changed.

 Upload JS file to Site Asset library and Provide in the following

~site/SiteAssets/CSSQEdit.js




Thursday, December 6, 2018

Hide Nintex form fields via Custom CSS


Add this name "nf-hide-calculatedcolumn" in the CSS class from calculated field.


Add in this CSS code from Custom CSS Section.

.nf-hide-calculatedcolumn 
{
visibility:hidden;
}


All of your CSS related control will be hidden.


Monday, October 15, 2018

Microsoft Flow to Update Azure AD User's Mobile Number via Custom Graph API App


Issue: When Updating Azure AD User Mobile number via Microsoft flow then we are getting error is Graph API - Insufficient privileges to complete the operation.

Our Techie team breaking head for few days and resolved issue and found solution.

Solution: Create Custom App for Graph API then Create HTTP Web service call inside flow to access Custom Graph API to update Azure AD User Mobile Number.

Friday, September 7, 2018

Sharepoint 2013 Installation Error : Application Server Role, Web Server (IIS) Role : Configuration error

I got in the below error   while trying to install the pre-requisites of sharepoint 2013 on the windows server 2012 R2 OS,

• Application Server Role, Web Server (IIS) Role: configuration error

The tool was unable to install ApplicationServer Role, Web Server (IIS) Role.

I tried to add role via Power shell command, still that Sharepoint 2013 Pre Requiste file is not passed.
we break head and we spent three days trying to figure out this issue and finally we found solution into %WINDIR% to find my solution

The Solution is:
The installer is trying to run the executable C:\Windows\System32\ServerManagerCMD.exe
 Taking a look in the system32 directory, you’ll see that in R2, ServerManagerCMD.exe doesn’t exist! How do we fix that? We do the logical thing. Take ServerManager.exe, copy it, and rename it to ServerManagerCMD.exe. Who cares if it’s messy, it works. :

Now, Run the Sharepoint Pre Requeste Installer: