Tuesday, November 4, 2014

SharePoint 2013 One Drive Issues

OneDrive not syncing with SharePoint and need a few ideas on what could be wrong?

  1. Make sure SharePoint MySite and profile features are enabled
    1. A corrupt MySite can prevent some account from syncing, we managed to fix an account by deleting it and recreating it. 
      1. If you cant recreate the account then (after backing up the server / data)
        1. Copy another users account (an empty one)
        2. Rename it
        3. Give the users permissions
        4. Set the mysite address in their user profile page.
  2. There are some issues with running the OneDrive client from a Citrix desktop
  3. Check the storage metrics page the user has enough Storage
  4. Try to resync
  5. Try the Microsoft diagnostic tools

SharePoint 2013 Blank login page and other login issues

Theres a few reasons for a blank SharePoint page after login*. It usually means you have an issue with the AD account.

The most common reasons are:
  1. Username/Password incorrect
    1. With 3 failed attempts usually
  2. The AD User has "change password after login" enabled
* Strangely there's no failed login page, just a blank page


If you are getting a request access screen when you already have access:
  1. Check the Security access page that the group the user is in has access
  2. Try removing the user from the group and re-adding them
  3. If there was a migration from 2010 to 2013 the accounts have to be upgraded to use claims

Tuesday, January 31, 2012

SharePoint 2010 / 2013 CAML In / Include Function

The <In> function is available in SharePoint 2010 /  2013 CAML query.
This works with similar functionality to the IN Function in sql. That is to say, that you can provide multiple values without having to use large blocks of <OR> functions.

The following query was working well:


   <Where>
                <In>
                                <FieldRef Name='UserID'/>
                                <Values>
                                                <Value Type='Number'>1</Value>
                                                <Value Type='Number'>2</Value>
                                                <Value Type='Number'>4</Value>
      </Values>
                </In>
   </Where>

You can also use the <In> function to query text values.

 
From this query you would receive items back where the UserID field was 1,2 or 4.

Taking this one step further I noticed it was not possible to embed the <In> function with an <Or> case:
   <Where>
       <Or>
            <In>
                <FieldRef Name='UserID'/>
                          <Values>
                                 <Value Type='Number'>2</Value>
                                 <Value Type='Number'>3</Value>
                          </Values>
           </In>
            <In>
               <FieldRef Name='SectionID'/>
                          <Values>
                                <Value Type='Number'>2</Value>
                                <Value Type='Number'>4</Value>
                          </Values>
             </In>     
       </Or>
   </Where>

The query above didnt work :(



Oh, and one thing to note. The <In> function was not returning the correct results through CAML query builder for me. However, this should work correctly through code!!!