Frédéric Mauroy

Wednesday, December 16, 2009

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:

Thursday, December 3, 2009

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

Wednesday, November 4, 2009

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...

Wednesday, September 30, 2009

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:

Tuesday, September 22, 2009

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.

Tuesday, September 1, 2009

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: