Sunday, November 3, 2013

Error occurred in deployment step 'Activate Features'

On the Quality Enrivonment i created a new Project in Visual Studio and when deploying this message appear:

"Error occurred in deployment step 'Activate Features'"

Solution is to deploy it manually for the first time:
  1. Add the solution to your Farm Add-SPSolution -LiteralPath
  2. Then Install Solution Install-SPSolution -Identity -WebApplication
After that you can deploy automatically using Visual Studio. Enjoy

Infopath Anonymous Users

Things i have learnt from doing Forms with Anonymous Users

  • You have to have a Site Collection Template of Team. Note: Publishing template will not allow Anonymous Users to submit data in ANY WAY
  • Can only Submit forms through lists and using customizing form.
  • Items submitted by anonymous users can’t automatically trigger workflows
This is a great post by Guru Clayton Anonymous Forms

If you don't want to use customizing form option you will have to use code in your forms. 

Use this code in your submit button:


Hope you enjoy

Error SharePoint Calculated Column Formulas

I was trying to create calculated column formulas in Site Column..

I realize that you can only do calculated column formulas in list column or by list columns...

Although, I found that initially when you creating Calculated Site Columns you can add formulas...

That's wierd but it took me several hours to find out.

Hope you enjoy you day.

I will leave a great combination of formulas here Calculated Formulas

Error The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator

When accessing Managed Metadata Service the following message is prompt:

"The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator"

I have done everything that i found on internet on Production and Quality SharePoint Environment and no solution worked for my Production Environment

What i have done:
  • Verify the “Managed Metadata Web Service” is "started". Reset several times..
  • Recreate the Service Application “Menaged Metadata Web Service”. Set full Permissions on and all others services account in hope it will work..but it didn't happen. It's not permissions issue.
  • Publish the same Service Application
  • Verify the Service Application Association have Managed Metadata Service is checked.
  • Dedicated Application Pool
  • Several iisresets

1 - Solution for Quality Environment: Create a new dedicated Application Pool 
  1. Go to Central Administration
  2. Click Application Management, then Manage Service Applications
  3. Select Managed Metadata Service and click Properties
  4. Create a new Application Pool

2 - Solution for Production Environment: Reattach Managed Metadata Database
This took me a harder solution.

  1. Go to SQL Server detach "Managed Metadata Database". Note: Select "Close Connection" option
  2. In Central Administration, Delete "Managed Metadata Service Application"
  3. Note: DO NOT Delete data associated with the Service Applications, You are deleting YOUR Database!!!
  4. Create a new Managed Metadata Service Application with a different name from the original DatabaseNote: Select the check-box "Add this service application to the farms default list".
  5. Take the newer database offline and close connections(At the end of this solution, this DB can be deleted)
  6. Do an attach of the original database
  7. At Central Administration, go to properties of managed Metadata and change the name to the original Database
  8. Do an iisreset

Thursday, September 26, 2013

SharePoint 2013 Drag and Drop doesn't appear + System Requirements

My clients was getting trouble to upload documents in the new installed SharePoint 2013 version because they still had the Office 2010. So They had to get Office 2013 (that takes hours to install, logistics and that stuff) or install Chrome in 5 min with no permission and use this great functionality.

I leave the System Requirements to use the drag and drop functionality

You have to have at least one of this requirements to drag and drop in SharePoint 2013 or you can use Windows Explorer (List/Library menu -> "Open with Explorer"). Windows Explorer can be limited if you have customizations. 

  • Internet Explorer 10
  • Internet Explorer 9 + Office 2013
  • Internet Explorer 8 + Office 2013
  • FireFox 24+ version
  • Chrome 28+ version

Have a nice day.

The following form template cannot be upgraded because it is not currently uploaded on this farm: urn:schemas-microsoft-com:office:infopath


This problem took me some hours to figure out what was happening, so I wanna share with you who are reading, so you can take 10min to resolve!

Problem:  When uploading a form by Administrator-Approved From Template (Advanced) the following message appear:
Sorry, something went wrong
The following form template cannot be upgraded because it is not currently uploaded on this farm: urn:schemas-microsoft-com:office:infopath:
I have tried several things, like removing the Form in CA, retracting the Solution.
Note: When you upload a Form to CA it's creates a solution or a file called .wsp.

Well, my mistake was changing the Form Name in InfoPath, so Form ID change based on Form Name and the Form ID HAVE to be the same to get upgraded and not creating a new Form when uploading to CA.


1- Verify the Form ID in InfoPath exemplified above and on CA-> General Application Settings -> Manage form templates -> (existing Form) view properties -> Form ID if they have the same exact characters ?
If yes go to step 3.

2- If they don't match, you have to edit the Form ID of the new Form in InfoPath and Upload back.

Although, this hasn't worked and same error appeared. May be because our Farm just had been upgraded to SharePoint 2013.

3- So I had to do one more step to get it working. Retracted the Solution of the old Form (CA -> System Settings -> Manage farm solutions -> Select solution with name beginning by "form-

3.1 - Uploaded the new Form and it worked! No more alerts about it is not currently uploaded on this Farm.

Have a nice day!

Monday, September 16, 2013

SharePoint Designer Workflow running two times and only twice

Problem: SharePoint workflow is running two time everthing thing i do..

Solution: At the beginning of the workflow, add an action "Pause for duration" of 1 minute.