Tag Archives: SharePoint

iCiber – delivers expert support for SharePoint, IT Operational improvements, Transition & Transformation Programs, Troubleshooting & Performance challenges

Founded in 2016, iCiber delivers expert support for SharePoint, IT Operational improvements, Transition & Transformation Programs, Troubleshooting & Performance challenges. Focus of iCiber is on the Microsoft platforms (e.g. SharePoint, Exchange, Office365, Azure, SQL). Our colleagues from iCiber are Microsoft MVP (Most Valuable Professional) or similar levels. iCiber has significant expertise in delivering operational services from offshore centers.

Areas of expertise: Migration of Service Desk Services, Local Support Services, Cross Functional Services (processes & procedures), Mail Services, File Services, Live Collaboration Services (Skype for business), Computer Device Services (Windows 7/Windows 10), Print & Scan Services, SharePoint Services, Stepping Stone Services and Server Management Services, Performance and Operational improvements large SharePoint environment (>50.000 users), Performance and Operational improvements large Exchange environment (>90.000 mailboxes), SQL, VMware


SharePoint rewrite issue opening office doc Juniper VPN

I experience a rewriting problem with an Juniper VPN Appliance (SA-2500) and a SharePoint website. When I try to access a SharePoint (2007 & 2010)  site after connection with the Juniper VPN, the SharePoint site is displayed fine. But, if I try to open an office document stored in a SharePoint document library the document opens and displays the Juniper sign- in page instead of the document.

After searching the Juniper site I found different solution and found out that this is a known issue. A combination of two solutions solved for me this issue:

  1. Add the login URL from the Juniper appliance to the alternate acces mapping from the SharePoint web application.
  2. Add the login URL from the Juniper appliance to the trusted sites in the Browser.
  3. Add the SharePoint URL to the trusted sites in the Browser.

Crawling Large Library`s in SharePoint 2007

I had been experiencing issues crawling a large document library of over 60,000 items in a SharePoint 2007 farm 64x after the index was corrupt and I had to reset the crawled content. The only error I could find in the crawl log was the error “The item may be too large or corrupt.” The crawler stopted around the 33,000 items from this document library. I have searched a lot on the internet for this problem and found a few Blogs describing this problem with different solutions. The solution for my issue was a mix of what I found on the internet. After these changes the crawler was able to index all 60,000 items from one Library.

Register changes:

  • HKLM/SOFTWARE/Microsoft/Office Server/12/Search/Global/GatheringManager/DedicatedFilterProcessMemoryQuota” –> Change the value to: 256000000 Hex
  • HKLM/SOFTWARE/Microsoft/Office Server/12/Search/Global/GatheringManager/FilterProcessMemoryQuota –> Change the value to: 256000000 Hex
  • HKLM/SOFTWARE/Microsoft/Office Server/12/Search/Global/GatheringManager/FolderHighPriority –> Change the value to: 500 Hex
  • HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Office Server/12.0/Search/Global/Gathering Manager: set DeleteOnErrorInterval –> Change the value to: 4 Decimal

Search Time Out settings:

1. Central Administration -> Application Management -> Search section -> Manage search service

2. Manage Search Service page –> “Farm-level search settings

3. Change the “Timeout Settings” both from 60 –> 500

MOSS 2007 Workflow: An error has occured in Approval

If you create a custom approval workflow in a document library and select this option on the customize workflow screen:
[x] Update the approval status (use this workflow to control content approval)

SharePoint maybe report the following error:

“An error has occured in Approval.”

The solution for this problem is very simple, if you want your workflow to update approval status you need to enable content approval in your document library. To enable content approval here is what you need to do:

Go to your document library Settings > Versioning Settings and select ,Yes” for: “Require content approval for submitted items?” option.

SharePoint Designer & User information List Metadata in a Workflow

I was building a workflow in SharePoint Designer and sometimes you need some metadata, for extra information or for an e-mail, from a SharePoint user. The problem is SharePoint Designer returns only the username and you cannot do a lookup for the the rest of the metadata from that user.

This is a  list out the metadata available in the “User Information List“, with the Paul Kotlyar’s “Lookup User Info” custom SharePoint Designer workflow activity you can use all off these fields in your workflow. Download the solution from CodePlex Don’t forget to put this line in the web.config:

authorizedType Assembly=”DP.Sharepoint.Workflow, Version=, Culture=neutral, PublicKeyToken=0298457208daed83″ Namespace=”DP.Sharepoint.Workflow” TypeName=”*” Authorized=”True” /

The “User Information List“ is available with administrator rights under: _catalogs/users/simple.aspx

Display Name Type Name
Content Type ID ContentTypeId ContentTypeId
Name Text Title
Approver Comments Note _ModerationComments
File Type Text File_x0020_Type
Account Text Name
E-Mail Text EMail
About Me Note Notes
SIP Address Text SipAddress
Locale Integer Locale
Calendar Type Integer CalendarType
AdjustHijriDays Integer AdjustHijriDays
TimeZone Integer TimeZone
Time Format Boolean Time24
Alternate Calendar Type Integer AltCalendarType
CalendarView Options Integer CalendarViewOptions
WorkDays Integer WorkDays
WorkDay StartHour Integer WorkDayStartHour
WorkDay EndHour Integer WorkDayEndHour
Is Site Admin Boolean IsSiteAdmin
Deleted Boolean Deleted
Picture URL Picture
Department Text Department
Job Title Text JobTitle
Is Active Boolean IsActive
Report To User Report_x0020_To
ID Counter ID
Content Type Text ContentType
Modified DateTime Modified
Created DateTime Created
Created By User Author
Modified By User Editor
Has Copy Destinations Boolean _HasCopyDestinations
Copy Source Text _CopySource
owshiddenversion Integer owshiddenversion
Workflow Version Integer WorkflowVersion
UI Version Integer _UIVersion
Version Text _UIVersionString
Attachments Attachments Attachments
Approval Status ModStat _ModerationStatus
Edit Computed Edit
Name Computed LinkTitleNoMenu
Title Computed LinkTitle
Select Computed SelectTitle
Instance ID Integer InstanceID
Order Number Order
Workflow Instance ID Guid WorkflowInstanceID
URL Path Lookup FileRef
Path Lookup FileDirRef
Modified Lookup Last_x0020_Modified
Created Lookup Created_x0020_Date
Item Type Lookup FSObjType
Effective Permissions Mask Computed PermMask
Name File FileLeafRef
Unique Id Lookup UniqueId
ProgId Lookup ProgId
ScopeId Lookup ScopeId
HTML File Type Computed HTML_x0020_File_x0020_Type
Edit Menu Table Start Computed _EditMenuTableStart
Edit Menu Table End Computed _EditMenuTableEnd
Name Computed LinkFilenameNoMenu
Name Computed LinkFilename
Type Computed DocIcon
Server Relative URL Computed ServerUrl
Encoded Absolute URL Computed EncodedAbsUrl
File Name Computed BaseName
Property Bag Lookup MetaInfo
Level Integer _Level
Is Current Version Boolean _IsCurrentVersion
Group Computed GroupLink
Edit Computed GroupEdit
Name Computed ImnName
Picture Computed PictureDisp
Name Computed NameWithPicture
Name Computed NameWithPictureAndDetails
Edit Computed EditUser
Selection Checkbox Computed UserSelection
Content Type Computed ContentTypeDisp

Create a DPM Recovery farm

Tutorial to create a DPM recovery farm (MOSS 2007):


  1. Open the SharePoint 3.0 Central Administration console from the Start Menu.
  2. Once the SharePoint 3.0 Central Administration console is open, click on the Application Management tab which opens to display all of the various options for managing your SharePoint installation.
  3. Look under the SharePoint Web Application Management heading to find the Web application list at the bottom and select this menu item.
  4. When the Web Application List appears, check through the list to confirm that the DPMRecoveryWebApplication does not already exist. If it does exist, you are free to delete it and continue with these instructions or you may continue with the one that exists. If it does not exist, please continue through the following steps to create one.
  5. Click the “back arrow” to return to the Application Management page. Under the SharePoint Web Application Management heading, click on the Create or Extend Web application.
  6. The Create or Extend Web application page appears with two options. The first called Create a new Web application is the one we will choose. The second option, Extend an existing Web application is not needed for this purpose.
  7. After clicking the Create a new Web application link, the Create New Web Application page appears displaying various necessary fields for details about the web application that is being created. Here is a brief summary of the important fields of this page.
    • Chose the Create a new IIS web site and in the description, name it “DPMRecoveryWebApplication”.
    • In the Port field, give it a unique port which is not shared by any other internal application.
    • The Host Header and Path fields can remain unchanged.
    • Scroll down to the radio button Create new application pool and in the Application pool name box, note that the entry name includes the port number and the SharePoint recovery server name.
    • Under the Select a security account for this application pool, select the Configurable radio button and type in a suitable account and password in the fields that follow. Note the security warning at the top of the page indicating that the credentials of this account may be transmitted in clear-text across the network.
    • Lastly, in the Database Name box, type in DPMRecoveryWebApplication.
    • iisreset /noforce