Category Archives: Sharepoint

Sharepoint 2010/ 2013 – One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas

I can confirm that a Data Type Column cannot be used in a Formula. But there is an easy workaround using Workflows in SharePoint Designer 2010/2013 without any coding required

  • Create an additional Column in your list (DataTypeColumn01) as type Single Line Text
  • In SharePoint Designer, open the List from the specific website and click New on the Worflows tab

SharePoint_Workflow_01

  • Give the Workflow an appropriate name and select the Platform; either SharePoint 2010 /2013 Workflow
  • From Workflow Tab select Action – List Actions – Set Field in Current Item
  • Set DataTypeColumn01 to CurrentItem:DataTypeColumn
  • Use the lookup button next to the Action to achieve this

SharePoint_Workflow_Lookup.PNG

  • Save the Workflow
  • Enable the Start Options for the Workflow as per your requirement

SharePoint_Workflow_StartOptions

  • Publish the Workflow
  • You can now use the DataTypeColumn01 Column with any SharePoint Formula
Advertisements

SQL Database ‘SharePoint_Config’ on SQL Server instance not found

SQL Database ‘SharePoint_Config’ on SQL Server instance ‘GDFS’ not found. Additional error information from SQL Server is included below.

Cannot open database “SharePoint_Config” requested by the login. The login failed. Login failed for user ‘GOLTENSDXB\SP_Farm’.

Before you go about making any drastic changes to the database; it would be wise to check the Status of the Sharepoint_Config database within the SQL Server Management Studio

Is your Sharepoint_Config Database set to Single User Login?

Sharepoint_Config

If yes, we require the trace and kill the session that is connected to this database before we enable multi user

Step 1 – Trace the Session ID connected to the Sharepoint_Config Database

select * from master.sys.sysprocesses 
msp,master.sys.sysdatabases msd 
where msp.spid>50
and msd.name='SharePoint_Config'
and msp.dbid=msd.dbid

Step 2 – Kill the Session and set the Sharepoint_Config Database database to offline mode

kill <spid> [eg: kill 62]
alter database Sharepoint_Config set offline with rollback immediate;

Step 3 – Switch back the Database to Online Mode and set it for Multi-User login

alter database Sharepoint_Config set online,multi_user with rollback immediate;

If your Sharepoint_Config database was not in Single User Login Mode and are still faced with this error; I would recommend below post

http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010setup.aspx?ID=b7ba6c51-3248-4dc2-a476-49cdd4267210

Unable to shrink Sharepoint_Config_Log file in Sharepoint 2010

Is your Sharepoint_Config_Log file reaching enormous GB size of data and nearing your full drive space utilization?

Shrinking a Log File in your SQL Database may seem very straightforward when accessing SQL Server Management Studio

You may have already tried the below and still not seen any change in the file size

ShrinkLogFile

If the above scenario is true, it is most likely that you have set your DB in Full Recovery Mode and hence will not allow you to shrink the log file

Please note that in my illustration I have made an assumption that the default dbname Sharepoint_Config has been changed; if changed please make revisions to the script accordingly

To confirm this further, run the shrink operating using the SQL Query.

From the SQL Server Management Studio

  • Click New Query and type below command
  • DBCC SHRINKFILE (Sharepoint_Config_LOG);
  • Execute the command
  • Click the Messages tab at the bottom and take note of the error

Your are most likely to get the below error

“Cannot shrink log file 2 because the logical log file located at the end of the file is in use”

In SQL Server Management Studio; run below commands

use master;
alter database Sharepoint_Config set recovery simple;
  • DBCC SHRINKFILE (Sharepoint_Config_LOG);

This will shrink the log file to its default size.

Opening PDF files in a browser from Sharepoint 2010

If you are facing an issue wherein your Sharepoint users are having to download PDF files onto their local machines to view the files; the below post has got just the solution you are looking for.

Below Step by Step Powershell commands can be run to get the functionality working

From your Sharepoint Application Server; proceed to Start – All Programs – Microsoft Sharepoint 2010 Products – Sharepoint 2010 Management Shell and type below commands

$webApp = Get-SPWebApplication("http://yourwebapplicationurl")
$webApp.AllowedInlineDownloadedMimeTypes.Add("application/pdf")
$webApp.Update()

Once the above commands have been successfully run, you can confirm that the PDF application has been added to the MIME Type list using below command

$webApp.AllowedInlineDownloadedMimeTypes

The result is immediate and you can test the solution right away.

The attempted operation is prohibited because it exceeds the list view threshold

Sharepoint 2010  – Changing the List View Threshold

Reason for Error : The Web Application Settings of your Sharepoint Site has been configured to allow list content below the number that you wish to store in it

If you are the Sharepoint Administrator; the below settings will get you through

1. Open Central Administration from your Sharepoint Server

2. Proceed to Application Management – Manage Web Application and click on your web application to select it.

3. From the top Ribbon, click on General Settings drop-down and choose Resource Throttling

4. In the List View Threshold field, increase the value to the desired amount and click OK.

5. Try to replicate the error. If the error persists, increase the value again until the error goes away.

Migrate Sharepoint 2007 List to Sharepoint 2010

Lets say you have a List in Sharepoint 2007 with Large Content and Views which you would want to replicate in Sharepoint 2010.

You can achieve this with Powershell Commands; but I will illustrate in the most simplest manner to achieve desired result

  1. From your Sharepoint 2007 List; Click Settings –  List Settings
  2. Save your list as a template (.stp); ensure that you select the Include Content CheckboxList_Settings
  3. From the Parent Site; proceed to Site Actions – Site Settings – List Templates and download the new template to local machine folder
  4. Change the extension of the downloaded file from .STP to .CAB
  5. Extract the content of the CAB file (manifest.xml) to a local folder; lets call it c:\sp2007_template\
  6. Edit the manifest.xml file; search for the ProductVersion element. This should have a value of 3; change its value to 4 and save the file
  7. Repackage the manifest.xml into a .CAB by using makecab.exe in the C:\Windows\System32 folder
    Syntax: makecab.exe c:\sp2007_template\manifest.xml c:\sp2007_template\{template-name}.cab
  8. Change the newly generated cabinet file extension from .CAB to .STP
  9. From the parent site of your Sharepoint 2010 Site;  proceed to Site Actions – Site Settings – List TemplatesSite_Settings
  10. Upload the newly created .STP file to the List Template directory
  11. When creating a new list in Sharepoint 2010; the new template will show up for selection.

Sharepoint 2010 Backup – Automated Backup with Powershell

You can run powershell commands directly from the Sharepoint 2010 Management Shell window; but that does not suit the purpose when you require a daily backup

Start - All Programs - Sharepoint 2010 Management Shell

Its’ surprising why Sharepoint themselves could not come out with an easy automated tool. Nevertheless; the below post would guide you through

Firstly, we need to define a backup location.

  • Is your Sharepoint Farm and SQL Server on different Servers? If yes, kindly ensure that the Backup Location that you define is a Share Drive (\\sharedrive\backupfolder) and has full Write Access for both the Sharefoint Farm Admin Account and SQL Server Account

Farm Backup is best done as both a Full and subsequent Incremental Backups

Full Backup

Create a File with the extension ps1 (denotes a powershell command file)

Add-PsSnapin Microsoft.SharePoint.Powershell
Backup-SPFarm -Directory \\sharedrive\backupfolder -BackupMethod Full

Setting up a Windows Task Schedule for the Farm Backup

Start – All Programs – Administrative Tools – Task Scheduler – Create Task

Give an appropriate name and under Actions tab; click New

Type powershell under Program field and state the ps1 file that you created above under the Add Arguments field

Task_Schedule

Specify an appropriate time under the Trigger tab for your task to run.  Since its a full backup its best to set a time after regular office hours

Incremental Backup (Daily backup of changed data since the last backup)

Create a File with the extension ps1 (denotes a powershell command file)

Add-PsSnapin Microsoft.SharePoint.Powershell Backup-SPFarm -Directory \\sharedrive\backupfolder -BackupMethod Differential

Use the Task Scheduler as illustrated earlier to define the daily backup

Alerts: Someone changes an item that appears in the following view is missing

Applies to Sharepoint 2010 and above

If you want to setup Alerts against a View created for a list; you will need to first ensure that the View is created using a Filter

sharepoint_list_filter

 

Once the filter is created as per your needs; Alert settings will show the option that was missing earlier

alert_settings

Remembering Sharepoint Password in Internet Explorer

How do I avoid SharePoint from asking for my password?

Use the below steps to save the password in Internet Explorer

  1. From Internet Explorer Menu – Select Internet Options
  2. Security – Custom Level
  3. Scroll to the bottom and check ‘Automatic logon with current user name and password’
  4. Click Ok and close Internet Options

IE_Security