Release Notes › Policy Server Release Notes › Defects Fixed in SiteMinder Releases › Defects Fixed for 6.0 SP3 › User Lookup With DB2 User Store May Not Work Correctly (31451)

Previous Topic: Policy Server on Red Hat Enterprise Linux Advanced Server Could Hang when Using a DB2 User Store (31501)

Next Topic: Fix Entering Incorrect AD/ADAM User Directory Information in Policy Server User Interface (31504)
User Lookup With DB2 User Store May Not Work Correctly (31451)

The Policy Server cannot retrieve custom user attributes when using a DB2 user store. Error messages such as the following are recorded in the smps.log file:

[4212/3536][Tue Jun 08 2004 13:53:09] [SmDsOdbcProvider.cpp:738][ERROR] Database Error executing query ( 'select rtrim(Disabled),rtrim(UserID) from SmUser where Name = 'user1''). Error: Internal Error:Database error. Code is -4007 (DBMSG: <<<State = HY000 Internal Code = -440 - [DataDirect][ODBC DB2 Wire Protocol driver][DB2]No function or procedure was found with the specified name (RTRIM) and compatible arguments.>>>) .

[4212/3536][Tue Jun 08 2004 13:53:09][SmDsOdbcProvider.cpp:738][ERROR] Database Error executing query ( 'select rtrim(Disabled),rtrim(UserID) from SmUser where Name = 'user1''). Error: Internal Error: Database error. Code is -4007 (DBMSG: <<< State = HY000 Internal Code = -440 - [DataDirect][ODBC DB2 Wire Protocol driver][DB2]No function or procedure was found with the specified name (RTRIM) and compatible arguments.>>>).