Advertisements

Category Archives: Sharepoint 2010

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.