Soirée de Noël

Les photos de la soirée de Noël chez Lucie et Jean sont ici:

Vidéos:

Noël chez Lucie from Frédéric Mauroy on Vimeo.

Commémoration de la bataille des Ardennes

Commémoration de la bataille des Ardennes, il y a 65 ans, à Bastogne, le dimanche 13 décembre 2009.

Photos ici:

Just geeks: Adding Regular Expressions (Regex) to SQL Server 2005

Excellent post on how to add Regular Expressions to SQL Server 2005:

Just geeks: Adding Regular Expressions (Regex) to SQL Server 2005

Oracle WCI: Warning: couldn't access subscriber X, continuing;

All of a sudden, our Saved Search Mailer scripts stopped working, after several years without a glitch.

The error I could find in the log files was this one:
Warning: couldn't access subscriber X, continuing
I spent the day trying to figure this out, as I couldn't find any clue using the PTSpy tool, nor in the million other log files... I had to decompile the Java classes of the "externaloperations.jar" library to find out what the process was doing before spitting out that error message.

Here is the code where that error message is shown:

void prepareSubscriberList()
{
 int userIds[] = m_ptSearch.RetrieveSubscribedUsers();
 if(userIds == null)
  throw new RuntimeException("Saved Search object failed to retrieve subscribers");

 IPTProfileManager ptPM = (IPTProfileManager)m_ptSession.OpenGlobalObject(58, false);
 m_subscribers = new Vector();
 for(int i = 0; i < userIds.length; i++)
 {
  int userId = userIds[i];
  try
  {
   IPTUserInfo ptUI = ptPM.GetUserInfo(userId);
   String email = ptUI.GetEmail();
   if(email == null)
    throw new RuntimeException("no email");

   String name = ptUI.GetFullName();
   if(name == null)
   {
    IPTUser ptU = (IPTUser)m_ptSession.GetUsers().Open(userId, false);
    name = ptU.GetName();
    if(name == null)
     name = ptU.GetLoginName();
    if(name == null)
     name = "User";
   }
   if(ptUI != null)
    m_subscribers.addElement(new Subscriber(userId, name, email));
  }
  catch(Exception e)
  {
   Log.println((new StringBuilder()).append("Warning: couldn't access subscriber ").append(userId).append(", continuing.").toString());
  }
 }
}

So, I guessed there was an issue with the email address received from the Remote API service. I checked the "User Profile Manager" admin tool, under "User Information - Property Map" and found that the "Email Address" property was mapped to the "IMUser" attribute, instead of the usual "Email" attribute. I changed it back to the normal value and everything returned to normal :-) This also "repaired" a lot of Collaboration Server errors, stating that the email address was not passed to the portlet.

I still have no idea why this value was changed...

Commémoration de la libération de Lessines

Les photos de la commémoration de la libération de Lessines, ce samedi 26 septembre 2009, sont disponibles ici:

Error in ALUI Collaboration Server when subscriptions contain deleted users

Recently, we encountered a problem when a user wanted to register other users in Collaboration Server for notifications. The error message was not very helpful, and I could not find a lot of info in collaboration.log nor in the PTSpy trace. The Oracle support helped me find the culprit: there was a discrepancy between the subscribed users in the CNS database, and the current users in the Portal DB. Apparently, when a user is deleted from the portal, there are items that remain in the collab and notification databases, and they cause Collab to crash...

To clean the leftovers in this case:

DELETE FROM SUBSCRIBEDACCOUNT WHERE SUBSCRIBERID NOT IN
(SELECT UUID FROM Plumtree.dbo.PTMIGRATION)

This script is run on the CNS database, Plumtree is the name of the portal DB, and dbo is the owner of the table.

Joyce & Jérôme

Mariage de Joyce & Jérôme, des amis à Marie-Eve, le samedi 29 août 2009. Mais cette fois, je n'étais pas photographe, juste invité...

Mes photos sont ici:


En cadeau bonus, une petit vidéo lors du lancer de colombes...

Joyce & Jérôme - Lancer de colombes from Frédéric Mauroy on Vimeo.

Senda & Vincent

Les photos du mariage de Senda & Vincent, qui s'est déroulé le samedi 15 août 2009, sont en ligne ici:

Mariage de Maude et Frédérick

Noc en Nob 2009

Concerts du vendredi 26 juin 2009:

Photos:


Videos:

Taliesyn @ Noc en Nob 2009
par eDonan

Xaman-Ek et les enfants de Nobressart
par eDonan

Autres vidéos: Noc en Nob 2009 - Dailymotion