SBL-DAT-00338: Change password failed. %1

Applies to:

Siebel System Software - Version: 7.0.4 [14068] - Release: V7
Microsoft Windows 2000
IBM AIX Based Systems (64-bit)
IBM AIX 4.3 Based Systems (64-bit)
Sun Solaris SPARC (64-bit)
HP-UX Itanium
Sun Solaris SPARC (32-bit)
Area(s):Security/Authentication
Release(s):V7 (MidMarket), V7 (Enterprise)
Database(s):DB2, Microsoft, Oracle
App Server OS(s):AIX, HP-UX, Solaris, Windows 2000
Latest release tested against:V7 (Enterprise)
Keywords:database authentication, change password, failed, pooling, SBL-DAT-00338

This document was previously published as Siebel Alert 754.

Description

After enabling DB Connection Pooling as per Document 476830.1, which discusses how to configure the Siebel Object Manager in Siebel 7, some users were unable to change their passwords. When they attempted to do so, the following error message was displayed:

 

SBL-DAT-00338: Change password failed.  %1

 

Change Request 12-EVGG0W has been logged to address this product defect.

 

This Alert is not applicable for Siebel version 7.7.x, since the Password field is disabled for Siebel Web Clients.

Likelihood of Occurrence

This behavior occurs when DB Connection Pooling is enabled with database authentication. It does not occur if Security Adapter authentication is in use. It was found that when DB Connection pooling was enabled, user X may be connected to the database as user Y. However, user X's attempts to change the password are rejected by the database server because user Y does not have the required privileges to change the password of user X.

 

More detailed information on Shared Database Connection Pooling can be found in Siebel Bookshelf version 7.5.3 > Performance Tuning Guide > Tuning the Siebel Application Object Manager for Performance > Best Practices for AOM Tuning > Configuring Shared Database Connection Pooling > Configuring Parameters for Shared Connection Pooling.

Possible Symptoms

Users get the following message when attempting to change their password by logging into the Siebel Client, navigating to the application-level menu, and choosing View > User Preferences.

 

SBL-DAT-00338: Change password failed.  %1

Workaround or Resolution

The workaround is to disable DB Connection Pooling in the appropriate Siebel Object Manager by setting the DB Connection Pooling parameters back to -1, in other words:

 

• DB Multiplex - Min Number of Dedicated DB Connections

 

• DB Multiplex - Max Number of Shared DB Connections

 

• DB Multiplex - Min Number of Shared DB Connections

 

These parameter settings can be updated using the srvrmgr utility or through the Siebel Client. Below are examples of both options for the Siebel eEnergy Object Manager:

 

Srvrmgr Utility

 

Change param MaxSharedDbConns = -1 for comp eEnergyObjMgr

Change param MinTrxDbConns = -1 for comp eEnergyObjMgr

Change param MinSharedDbConns = -1 for comp eEnergyObjMgr

 

Siebel Client

 

1. Navigate to Site Map > Server Administration > Components.

 

2. In the Components list, select the relevant Siebel Object Manager server component.

 

3. In the lower view tab, select the Component Parameters view.

 

4. In the Parameter field, query for the records that start with DB*. Ensure the value in the “Value on Restart” field is set to -1 for each of the DB Multiplex parameters.

 

NOTE: The Siebel Server will need to be restarted in order for these new parameter settings to take effect.

Maintenance Release Number

Fix Request 12-FO6371 has been released for Change Request 12-EVGG0W, which has been fixed in Siebel Fix Pack version 7.0.4.306. The latest Fix Pack version should be applied to Siebel Maintenance Release 7.0.4.

 

This behavior has been fixed in the Siebel Maintenance Releases 7.0.5 and 7.5.3.

 

NOTE: If you are encountering this behavior in Siebel version 7.5.2.x, you should apply Siebel Maintenance Release 7.5.3.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3.4 [16180]
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Microsoft Windows 2000 Server SP 3

This document was previously published as Siebel SR 38-2650712621.

Symptoms

SBL-DAT-00338

The Change Password functionality is not working for users of eService. We are getting an error of Change password failed. <?>(SBL-DAT-00338).

Solution

Message 1

For the benefits of other users:

Customer using database authentication and encounters “Change password failed. <?>(SBL-DAT-00338)” error when attempt to change password for users of eService.

Solution:

The issue was related to the ODBC DSN and MS SQL server setting. After changing the ODBC Authentication mode to SQL Server Authentication with the SQL Server setting (SQL Server Properties > Security > Authentication) set to Mixed Mode (SQL Server and Windows) resolved the issue.

Thank you,
Siebel Technical Support

Applies to:

Siebel CRM - Version: 7.7.2.6 [18372] - Release: V7
Information in this document applies to any platform.

Symptoms

After activating Oracle database password verification function, the end-user may receive the following messages when typing an invalid password:

[1] SBL-SEC-10001: An internal error has occurred within the authentication subsystem for the Siebel Application.
Please contact your system administrator for assistance.
[2] SBL-SEC-10001: An internal error has occurred within the authentication subsystem for the Siebel Application.
Please contact your system administrator for assistance.
[3] SBL-SEC-10018: Change password failed.
<?>(SBL-DAT-00338)
ORA-28003: password verification for the specified password failed
ORA-20003: password should contain at least one \
digit, one character and one punctuation

These are not user-friendly error messages. After clicking the OK button and retyping a valid password, the end-user may receive the following messages:

[1] Wrong field values or value types detected in field Verify Password. Please re-enter your field values. If you need additional assistance, please refer to the documentation.(SBL-UIF-00299)
[2] Invalid operation while not in update mode.(SBL-DAT-00474)

Cause

Bug <<12-1NSKPOP>> has been logged requesting user-friendly error messages on this situation

Bug <<12-1NSKPPJ>> has been logged for additional error messages being displayed when typing a valid password in the second try

Solution

The end-user needs to read all messages to understand an invalid password has been typed.

During the second try, the end-user needs to undo the operation using Edit > Undo Record [Ctrl+U] before retyping a new password.