Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Uncategorized

Performance Point – Unable to Install on Domain Controller – FIXED

Today I had tried to load PPS on my handy SharePoint VM and it promptly fell on it’s face.  Whoops!   The workaround is very easy and came to me by looking at the Performance Point Monitoring Server install MSI  (PSCSrv.msi)  using the incredibly helpful Orca MSI editor tool.

  1. Browse to the PPS install media folder
  2. Locate the file named "PSCSrv.msi”
  3. Open a CMD prompt window to the path in #2
  4. Type “PSCSrv.msi SKIPREQCHECK=1” to launch the install and bypass the check
  5. You’ll still see the error message but can click “Next” to skip and complete a full normal install
  6. Enjoy!

 

Microsoft Office PerformancePoint Server 2007 — Monitoring Server — Failed    Windows Vista or Windows XP SP2 or Windows Server 2003 SP1 (non domain-controller) or Windows Longhorn (non domain-controller)

 

image

image

image

URL Source= for Thank You on Submit

Many times I’ve been asked to adjust the NewForm.aspx (add record) experience for users to display a custom message after submit.    A “Thank You” page for a survey is a great example.    Other times in request forms people want to show a confirmation or instructions page.

Thankfully the SharePoint product team made this easy for us developers.

Action Steps

  1. Visit the list or library you’d like to tweak
  2. Click on New item to get to /NewForm.aspx
  3. Take a close look at the URL and notice the word “Source=”
  4. We’ll come back to this in a minute
  5. To create a “ThankYou.aspx” page I like to duplicate the “DispForm.aspx” by going into SharePoint Designer
    1. Right click Copy on DispForm.aspx
    2. Right click and Paste
    3. Edit the file to remove the main web part
    4. Rename the file to “ThankYou.aspx”
  6. Edit the part after the equals sign (=) from #3 and replace with a URL you’d like to take people to after submit

 

Often the destination page for #5 above doesn’t yet exist.   So you’ll want to open SharePoint Designer 2007 and create a new ASPX page to hold a “Thank You” message.    For this I always place the ASPX file in the same /Forms/ folder as the list I’m working on.   

Why?    By placing a custom ASPX in the same /Forms/ folder it will be including in any List template (.STP) creation and is easier for future admin and dev staff to locate for troubleshooting.

 

 

image

 

image

 

image

 

image

image

 

image

 

image

 

image

 

image

 

image

 

image

 

image

Save C# Time with .OpenWeb()

One of my most common coding task is a simple command line EXE that takes a few parameters in, opens the object model, and applies some sort of changes.   Yes, I know about PowerShell, but am very comfortable with Visual Studio and Intellisense today.

Action Steps

  1. Start a new “Console Application” project type
  2. Add an assembly reference for “Microsoft.SharePoint.dll”   (12.0.4518.1016)
  3. Type “SPSite s” and right click to add the “using” statement.   Very nice shortcut, thank you Joel G!
  4. Create a new SPSite object and use the full URL to the web for the constructor
  5. Use the SPSite.OpenWeb()  method to grab that one web object without the hassle of looping through children
  6. This trick works no matter how far the SPWeb is nested down in the site collection

 

image
image

 

image

 

image

 

image

 

image

Event Error 5553 – failure trying to synch site”??” for ContentDB “??” WebApp “??”. Exception message was Cannot insert duplicate key row in object ‘dbo.UserMemberships’ with unique index

I ran into this problem this week after doing several site collection moves.     The resolution is simple, effective, and only take a few minutes.

ststam -o preparetomove –contentdb [SQLServer:DatabaseName] –site http://sharepoint
stsadm -o deletecontentdb –url http://sharepoint –databasename [database] –databaseserver [SQLSever]
stsadm -o addcontentdb –url http://sharepoint –databasename [database] –databaseserver [SQLSever]

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲