Skip to main content

SharePoint Tip: Common error when creating Project Web Database site

Thought I could share this one. I was creating a SharePoint 2010 Project Web database subsite and was faced with an error message "The formula contains a syntax error or is not supported."
After doing some research on technet, I found that my site collections regional settings Locale was set to "English (South Africa)" and apparently for the site database schema to be created, it required the regional settings to be "English (United States)", probably because the Database instance may have been set up this way, but anyway, after changing the regional settings to "English (United States)", site creation immediately worked.
Labels:

Comments

Post a Comment

Popular posts from this blog

Zambia's first K2 BlackPoint roll-out

Reporting to you live from Code|Influence... My colleague and I have been managing our organization's SharePoint infrastructure for some time now and we have just rolled out the first K2 BlackPoint in the country, intended mostly for SharePoint workflow developments.
8 comments
Read more

SharePoint: How to create a custom action to open Word Documents using "Edit in Microsoft Word".

Imagine you have a SharePoint custom search webpart, and on your search results, you return word documents, you will obviously want to at times be able to open them in your MS Word client program for editing. So basically, depending on your office client installed on your local machine, there are 2 different approaches that can be made for Office 2003 and Office 2007/10, using the same function " editDocumentWithProgID2 ". For Office 2003: - If your document libraries versioning settings have got "Require Check out" ticked, then you will first want to check out the document using: onclick ="CheckoutviaXmlhttp(‘{SiteURL}’, ‘{DocumentDownloadURL}’)" - Then to open the document, you use: onclick =" return editDocumentWithProgID2(‘ {DocumentDownloadURL} ’, ”, ‘SharePoint.OpenDocuments’, ’1′,’ {SiteURL} ’, ’0′);" href ="#" - and now combining the above 2 actions into one clickable action: onclick ="CheckoutviaXmlhttp(‘ {SiteURL} ’, ‘ {...
2 comments
Read more

How to document your SharePoint Projects.

Here are the essential documents you need to complete… Initiation Business Case: To justify the financial investment in your SharePoint Project, you need to write a Business Case. It lists the costs and benefits, so everyone knows what the return on investment will be. Feasibility Study: Before you kick-off your SharePoint Project, you need to determine whether your project is feasible, using a Feasibility Study. SharePoint Project Charter: You then need to document the objectives, scope, team, timeframes and deliverables in a SharePoint Project Charter. Planning SharePoint Project Plan: You need to create a Project Plan listing all of the tasks required to undertake your SharePoint Project from start to finish. Every task must be scheduled, so you know what needs to be done and when. Resource Plan: Next, you need to plan your resources by documenting the money, equipment and materials needed for your SharePoint Project. Quality Plan: You then need to set quality targets, so that the S...
4 comments
Read more