Save dolphins!

Take part too: www.takepart.com/thecove

Synology - Master Your Data

A cool video about the Synology NAS. I have 2 of these great boxes :-)





See more here: http://www.synology.com/

Open Jazz Festival - 5 mars 2010

L'Open Jazz Festival 2010 s'est déroulé du 3 au 11 mars à Louvain-la-Neuve.

J'ai eu la chance de rencontrer le Roméo Swing Quartet/Quintet ainsi que les Escargots du Dimanche, le vendredi 5 mars. Voici un résumé en photo, et en vidéo:



Vidéos ici: Open Jazz Festival

Aperçus:

Open Jazz Festival: Les Escargots du Dimanche from Frédéric Mauroy on Vimeo.

Open Jazz Festival: Roméo Swing Quintet from Frédéric Mauroy on Vimeo.

Concert de Jean-François MALJEAN

Concert de Jean-François MALJEAN, ce samedi 27 février 2010, à Gelbressée, avec, en première partie, Jasmine Daoud et Manon Vincent.

Les photos sont ici:


Vidéos:

Gelbressée: Jean-François Maljean from Frédéric Mauroy on Vimeo.

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.