Saturday, March 15, 2014

Migrating Traveler to HA Error

Today was the day I made the leap to migrate our production Traveler server from running on the Derby database to an SQL database.  While we are not taking full advantage of HA with multiple servers, I wanted to at least get us migrated to a more robust database.  Having walked through the migration steps at this link in our test environment, I felt pretty confident with the task ahead.  
After the server restarted and Traveler launched, the migration process began.  But not too long after the migration started, I started to see errors like this:
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28452947 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28452947 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28884237 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28884237 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28884237 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28884237 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:29766495 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:29766495 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:29766495 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:29766495 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:14930891 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:14930891 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:14930891 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:14930891 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:27175522 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:27175522 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:27506501 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:27506501 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28452947 
[2144:00D2-1518] 03/15/2014 07:40:54 AM  Notes Traveler: WARNING USER NAME[migration] GUDEX:28452947 

and lots of them for lots of different users.  Of course this didn't show up when I migrated the test environment and I feared the worst.  I opened a severity 1 PMR with IBM just to be sure.  I quickly heard back from them and was informed that:
For the GUDEX warning, it is just a warning and indicates previous data issues.  Traveler has two database tables (GUD and GUDEX (ex =          
extended)).  If the data is too large to fit in GUD, it gets put in GUDEX.  This warning means that data exists in GUDEX that isn't        
referenced by GUD.  The data is essentially orphaned.  It can't be migrated because there is no GUD reference to it, so it is effectively getting cleaned up/fixed as part of the migration.  The warning is just there in case we need to refer back to it and is part of a general path that could have other warning messages.  But this particular WARNING is not a concern.   
So there you have it.  Nothing to get overly concerned about.  At least as far as I've seen.  Didn't see this error message anywhere else after multiple Google's, so I wanted to share out the info in case someone else comes across it.