Ponto de Partilha

WSS User Info data not in sync with MOSS User Profile

noreply@blogger.com (Pedro Mateus) — Thu, 08 Sep 2011 15:29:00 +0000

If your WSS User Info data not in sync with MOSS User Profile and you have two or more frontends, please read on...

After trying everything on the books (http://blogs.technet.com/b/nishants/archive/2010/08/23/troubleshooting-user-profile-sync-issues-in-office-sharepoint-server-2007.aspx) I wasnt able to solve it, including with the stsadm commands:

stsadm -o sync -ignoreisactive 1
stsadm -o sync -deleteolddatabases 0
stsadm -o sync

Then, after browsing the ULS I found the following error:

User Profile Import: Error while querying for whether the import is in progress:
System.Net.WebException: The underlying connection was closed:
An unexpected error occurred on a send. ---> System.IO.IOException: Authentication failed because the remote party has closed the transport stream.

and a quick browse @ google this post appeared (http://mrvsharepoint.blogspot.com/2009/02/when-you-to-search-settings-you-get.html)

After that it was a question of replacing the SSL Certificates for the Office Server Web Services web site using selfssl from IIS 6.0 Resouces kit and the problem was solved.

Hope you find this information usefull.

Log Parser

noreply@blogger.com (Pedro Mateus) — Tue, 10 May 2011 14:13:00 +0000

Just found out about Log Parser 2.2 from Microsoft, and while I was at it, i grabbed Visual Log Parser from CodePlex for a nice GUI (who likes cl right?)

This is simple app that I found out while trying to understand by IIS was recycling too many times and browsing this post.

It looks like you can query your EventViewer and a ton of other Log repositories just like a regular SQL database:

Select top 100 *

from \\server\System where SourceName = 'W3SVC'

and EventID in (1009;1010;1011;1074;1077;1078;1079;1080;1117)

order by timegenerated desc

Better than scrolling up and down right? You can even build up some VBS or something else to have some real time data from your logging. And this will work for different log platforms.

Remote Log4Net

noreply@blogger.com (Pedro Mateus) — Tue, 10 May 2011 13:43:00 +0000

You probably know this already, or this might not come as a surprise but enabling log4net to log to a remote place is really simple.

We had a scenario of only one front end with custom systems using log4net, but we needed to add a second front end, and with that the question about what to do about logging.

I wasn't aware how simple is to enable remote logging on log4net. So, heads up if you were like me:

Get log4net Remove Logging Service at CodePlex (you can get the source and change at your will), after install this will create a listener service where you want to store your remote log repository.

Then, at your local clients just change the appender to something like this

<appender name="remotAppend" type="log4net.Appender.RemotingAppender" >
<sink value="tcp://remoteserver:port/Log4netRemotingServerService" />
<lossy value="false" />
<bufferSize value="10" />
<onlyFixPartialEventData value="true" />
</appender>

At your Remote repository use your favorite appender, RollingLogFileAppender or whatever.

Remember to add the hostname property to your layout type: (%-10property{log4net:HostName}).

Something like this:

</layout>

</appender>

Maybe you could do without this Codeplex service, but since it was so simple and the component is working fine I didnt waste any time looking for alternatives.

If you dont agree, please comment, shed some light :) Thank you.

Full documentation on:

http://log4netremotelogging.codeplex.com/

http://logging.apache.org/log4net/index.html

IE8 Life Saver Tip

noreply@blogger.com (Pedro Mateus) — Thu, 29 Jul 2010 11:25:00 +0000

If you usually access say SharePoint (or any other site) with several users at the same time, for testing, admin, regular user, etc., you may found that IE8 doesnt allow you since every Window will share only one credential. With IE7 everything worked fine, it seems its a new 'feature'.

Well, the solution is pretty simple, File -> New Session, or else you can add "-nomerge" in your local IE shortcut.

Everything on http://www.walkernews.net/2009/03/26/use-ie8-nomerge-option-to-login-multiple-accounts-of-same-site/

Files missing in SharePoint? Even from RecycleBin and (god forbids) AllUserData?

noreply@blogger.com (Pedro Mateus) — Tue, 20 Apr 2010 13:21:00 +0000

If files are disappearing from your SharePoint Document Library and you are (probably) using some custom code on SharePoint Doc Libs then check if you have any SPFile.Delete() call because if so, that row will disappear from SharePoint for ever...Unless you have you Backup/Restore working on.

Developers should be aware that there is another method, .Recycle() that will send the file to the RecycleBin, and this is safer in most cases. Of couse if RecycleBin is disabled this method doesn't add any value i guess...

There are other cases that will delete the file for ever like sp workflow deletions but im not aware of more...probably those that internally use Delete().

There are some nice posts with more info on this @ sharemypoint, and its also good to read the SPFile documentation ;)

A new challenge(company) for 2010!

noreply@blogger.com (Pedro Mateus) — Tue, 12 Jan 2010 10:32:00 +0000

Thats right, I'm starting 2010 at a new company, ANCP. I have great memories from my former company, DevScope, and i will always remeber it has a great place to work, always at the tip of the edge adopting new technologies, young and smart people working on new stuff that most people on the country haven't heard about, even those working on IT.

I just want to say thanks to everyone at DevScope, specially Luis Martins for the opportunity and Marco Silva with who i have been working more regularly in the past year ;)

Now I will be focusing on SharePoint, and start to learn a BPM tool for SharePoint, but because i have moved to a non-IT company i will be giving support to other stuff as well. It's a different point of view that, I hope, will give me a different perspective to my work and insight to the business. Also because it's a government agency i might not be exposing everything i will be doing, still, expect some more SharePoint stuff, and more. Wish me luck @ ANCP.

Language "pt-PT" does not exist in this MessageManager instance

noreply@blogger.com (Pedro Mateus) — Thu, 03 Dec 2009 11:26:00 +0000

Hi,

We were having some problems with the Variation site of a Commerce 2009 Contemporary Site. It seems when errors happen the message doesnt get translated. These things happen for example when searching and presenting orders in Order History. In the root or en-US site they work ok. In MOSS logs we didnt find much information.

We have most of the functionality working on the pt variation but these 'errors' were stoping us from advancing.

We get something like this in event log:

Pipeline Error: Component Execution failed for component[0x9] hr: 0x1B5AA390 ProgID: Commerce.OrderDiscount.1 Language "pt-PT" does not exist in this MessageManager instance. And something like this: An exception of type 'System.Runtime.InteropServices.COMException' occurred and was caught.
-------------------------------------------------------------------------------------------
12/02/2009 15:19:14 Type : System.Runtime.InteropServices.COMException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Component Execution failed for component[0x9] hr: 0x1B5AA390 ProgID: Commerce.OrderDiscount.1 Language "pt-PT" does not exist in this MessageManager instance. Source : Commerce.MtsPipeline

We solved it by creating a MessageManager Resource dll, all info here: http://msdn.microsoft.com/en-us/library/ms964360(CS.70).aspx

You can find rc.xml in commerce sdk, RCxml2resx in commerce tools, resgen and al in visual studio command prompt.

We lost some time with this, and this solved almost all our problems, it should be documented in the variations paper ;)

Commerce Server 2009 + Windows 2008 R2 + Alias

noreply@blogger.com (Pedro Mateus) — Wed, 18 Nov 2009 11:42:00 +0000

If you get a strange error running Sharepoint Comerce Server Wizard at unpacking or having problems running PUP.exe and have an ALIAS configured for Sql, try adding the alias to the hosts file. This solved some problems. It seems PUP.exe uses named pipes to access Sql, go figure..

An error has occurred (80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

More detail on the MSDN Forum: http://social.msdn.microsoft.com/Forums/pt-BR/commserver2009/thread/2b2cce1e-189b-42ff-ad4a-1282552e69f8

.NET 3.5 SP1 missing when installing Commerce Server 2009 on Win 2008 R2

noreply@blogger.com (Pedro Mateus) — Thu, 12 Nov 2009 14:37:00 +0000

When you try to install Commerce Server 2009 (after the 2007 install) on a Windows Server 2008 R2 you will get an error saying to install .NET 3.5 SP1.

You may try to install it, but you cant, when you try to install it extracts and the installer vanishes...you know why? R2 already comes with 3.5 SP1 (a warning on the installer saying its already installed would give us a better clue)

After some poking around we found a MS hot fix...a reg key is missing on the 3.5 SP1 of the R2.

Request the fix to support: http://support.microsoft.com/?scid=kb;en-us;975567&x=14&y=13

Please stay around for more CS2009 info and also check my colleague Marco's Silva blog, for it will have soon more CS2009 goddies ;)

Annoying error Saving Page Content, and Compatibility View

noreply@blogger.com (Pedro Mateus) — Wed, 11 Nov 2009 17:36:00 +0000

There are some annoying things while we work, Saving Page Content is one of them:

Its easy to get rid of: Advanced Settings, disable "Enable native XMLHTTP support".

Original Source: http://www.chakkaradeep.com/post/2009/07/11/IE8-to-SharePoint-e28098Are-you-sure-you-want-to-navigate-away-from-this-pagee28099.aspx

Another thing i didnt understand was i didnt had compability view enabled in IE8 and i didnt understand why, here are the reasons:

Sometimes the Compatibility View button isn’t displayed. The button is located on the address bar next to the ‘stop’ and ‘refresh’ buttons. There are a few cases where there’s no action for a user take and, thus, the Compatibility View button will not show:

If you're viewing an internal-to-Internet Explorer page (such as about:InPrivate)
If you're viewing a page that has declared it's "ready" for Internet Explorer 8 through use of the versioning tag / HTTP header (it doesn’t matter if this tag triggers Quirks, IE7 Standards, or IE8 Standards, the button won’t be displayed)
If you're viewing an intranet page and you have the ‘Display intranet sites in Compatibility View’ checkbox selected
If you're viewing any webpage and you have the ‘Display all websites in Compatibility View’ checkbox selected
If you're viewing a webpage that is included on the Microsoft-supplied compatibility view updates list and you have the ‘Include updated website lists from Microsoft’ checkbox selected
If you've toggled either the ‘Document Mode’ or ‘Browser Mode’ settings via the Developer Toolbar

Original Source: http://blogs.msdn.com/ie/archive/2009/02/16/just-the-facts-recap-of-compatibility-view.aspx

Extensions

noreply@blogger.com (Pedro Mateus) — Thu, 22 Oct 2009 13:13:00 +0000

Just found out about a nice feature unknowed by me atleast...Extensions!

Just create something like:

public static class Extensions
{
bool MYMETHOD(this int value)
{
return whatever;
}

This will cause an extension to the int32 class, so in every int you will be able to call MYMETHOD, like this:

int n = 4;
if(n.MYMETHOD())
do something;

Maybe alot of you already know this but i didnt...pretty usefull.

Another tool for BDC

noreply@blogger.com (Pedro Mateus) — Fri, 18 Sep 2009 14:20:00 +0000

Just found out about a new tool from Simego for BDC Application Definition Files, MOSS BDC Design Studio($200) is cheaper than Metaman($1200) and it seems that it does some things Metaman doesnt.

More reviews here and here.

PS: I'm on a small project working with BI, SSAS and SRS with SharePoint, mostly setting up the envorinment and found out the value of SQL Profiler ;)

Oh and its nice to work with Reports inside Sharepoint, real fun.

Also designing some simpler than Visual Studio Workflows on SPD, a bit weird at first but after you get it its pretty straight forward.

Sharepoint & Reporting Services

noreply@blogger.com (Pedro Mateus) — Thu, 17 Sep 2009 14:59:00 +0000

When installing and configuring Sharepoint with Reporting Services please refer to this fine link: http://blah.winsmarts.com/2007-12-SharePoint_and_SQL_Server_Reporting_Services.aspx

Over and out

Unattended Quiet SQL Express Installation

noreply@blogger.com (Pedro Mateus) — Thu, 06 Aug 2009 10:40:00 +0000

It might be a little bit difficult to find the right params to install SQLEXPR32.exe in unattended mode so here it, if i need it again:

SQLEXPR32.EXE /Q /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity SQLAUTOSTART=1 INSTANCENAME=WHATSUP SQLACCOUNT="NT AUTHORITY\SYSTEM" COLLATION="SQL_Latin1_General_CP1_CI_AS" INSTALLSQLDIR="%Install_Dir%" INSTALLSQLDATADIR="%Install_Data_Dir%"

GOT IT AT : http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/87a3bd56-7269-4d0f-8f29-1090edb6b8d5/

FBA Management in SP

noreply@blogger.com (Pedro Mateus) — Fri, 24 Jul 2009 11:41:00 +0000

If you have FBA in your Farm, with data on SQL it can be a pain to manage the users, and the client will want a nice way to manage them.

Well, this guy did it :)

FBA in SharePoint

noreply@blogger.com (Pedro Mateus) — Thu, 23 Jul 2009 14:41:00 +0000

Just for my own internal record: http://msdn.microsoft.com/en-us/library/bb975136.aspx

Forms Authentication in SharePoint Products and Technologies (Part 1): Introduction
Summary: Explore several new features for authentication and authorization in Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 that make it easier to develop and deploy solutions in Internet-facing and extranet environments. This article is part 1 of 3. (26 printed pages)

Steve Peschka, Microsoft Corporation
Published: December 2007
Updated: June 2009
Applies to: Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0

Cant upload big files in 2008

noreply@blogger.com (Pedro Mateus) — Wed, 22 Jul 2009 15:49:00 +0000

If you have changed the file size limit in CA, and then it doesnt work, check if you have win2008 since there's an knowed issue.

Found solution here. KB here.

Good resource on large files and Sharepoint: Paul Gavin.

Sharepoint Training

noreply@blogger.com (Pedro Mateus) — Wed, 22 Jul 2009 14:19:00 +0000

Office SharePoint Server 2007 Training download.

Maybe the best training road map for sharepoint:
http://blogs.msdn.com/neilth/pages/office-sharepoint-server-2007-training-material-roadmap.aspx

But 2010 is coming :)

Backup and restore, content types disappear

noreply@blogger.com (Pedro Mateus) — Wed, 22 Jul 2009 13:26:00 +0000

If you try to backup a site collection and restore it, everything looks fine but when you try for example to create a page you might receive a nice 'content type not found' error.

Not even the default content types are 'restored'. A google search pointed me to this site.

Marvelous, just run the SharePoint Products and Technologies Configuration Wizard and you should be back in business. Real simple solution.

My First Microsoft Certification

noreply@blogger.com (Pedro Mateus) — Mon, 22 Jun 2009 11:29:00 +0000

I passed today in MS exam 70.541. Of course im quite happy but it was a little bit easy, i have maybe 1,5years experience with MOSS mostly and with most of the question out there in the internet it was a 'walk in the park'.

One question intrigued me..i was sure it was wrong but Internet questions keep saying it was right...grrrr...but i didnt want to test my persistance so i checked the 'wrong' right one on the exam :D

So, maybe a next exam who knows... At least i can read other stuff...maybe BI

Cannot start microsoft office outlook. Cannot open the outlook window

noreply@blogger.com (Pedro Mateus) — Tue, 02 Jun 2009 12:53:00 +0000

I got this error today, i thought it was strange since i hadnt done anything unusual. My collegue told to repair with Office Cd, ok no problem i can keep on work so... Then he asked me to reboot and i didnt liked it and after the reboot the problem persisted. Damn.

I found a MS Kb about a similar error, saved my REG just in case and changed it, no go.

Another google and i got into this post and this solved the problem. Three simple words, 1 command. Hope it helps you.

Run outlook.exe /resetnavpane

Once upon a time, there was SPGridView

noreply@blogger.com (Pedro Mateus) — Wed, 20 May 2009 16:17:00 +0000

About SPGridView Filtering and Grouping check out this posts:

http://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx

http://blogs.msdn.com/powlo/archive/2007/05/15/using-spgridview-filter-properties.aspx

And did you knew that SPGridView had a bug?

http://blogs.msdn.com/valdon/archive/2009/03/11/how-to-work-around-bugs-in-the-spgridview-control.aspx

(this for my own future reference since i wasted more than 5min looking for this pages...hope it helps you)

SPUtility

noreply@blogger.com (Pedro Mateus) — Fri, 24 Apr 2009 11:49:00 +0000

The other day i discovered SPUtility, while browsing i found out some nice methods, check them out :-)

· SPUtility.SendEmail(web, false, false, "someone@somewhere.com", subject, body);

· string featurePath =SPUtility.GetGenericSetupPath("template\\features");

// returns C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES

Redirect to the SharePoint Error Page.
This is a nice way of handling errors cleanly and consistently.

    try
    {
        // some code that might fail
    }
    catch (SPException ex)
    {
        SPUtility.TransferToErrorPage("An error occurred.\n" + ex.Message);
    }

4. Redirect to any page.
I find this really handy as you can provide flags that let you redirect relative to the layouts directory (if you have some custom layout pages)

// send user to login page
SPUtility.Redirect("login.aspx", SPRedirectFlags.RelativeToLayoutsPage,HttpContext.Current);

Original: http://www.trinkit.co.nz/blog/archive/2007/04/30/programming-in-wss-use-sputility.aspx

Great CAML IntelliSense

noreply@blogger.com (Pedro Mateus) — Sat, 21 Feb 2009 11:36:00 +0000

This is intellisense using the default XSD right?

Well John Holliday did some extension that enhances the CAML.NET IntelliSense Experience, download it here. It has some nice time saving potencial right?

DevDays

noreply@blogger.com (Pedro Mateus) — Sat, 21 Feb 2009 11:12:00 +0000

DevDays is the big Microsoft event in Portugal, like TechDays, but at a Portuguese scale, so a bit small but still pretty cool, this year presented in IST at Tagus Park. I went to the first day and had a great time, learn a lot about BI, something that was almost unknowned to me (i didn't knew MDX so...) and now since PerformancePoint is going to sit on top of SharePoint i thought i would be nice to learn something about it. I really liked Nelson Luciano and Rui Quintino (co worker at DevScope :) stuff on BI, the first one was very introductory but very wide, Rui's presentation was much more advanced and very informative. The new stuff from .NET 4.0 was pretty interesting and Nuno Godinho is a good&fun speaker. Parallels Extension was also very good, those work units that can scale for N cores is really great we hope more on that in the future. Too bad the SharePoint session was canceled and went to day 2 which i didn't go to. I also had time to learn a bit about Scrum and TFS in a Tiago Pascoal session that was also good.