Fixes are available
Rational Asset Manager Fix Pack 2 (7.5.2.2) for 7.5.2
Rational Asset Manager Fix Pack 3 (7.5.2.3) for 7.5.2
Rational Asset Manager Fix Pack 4 (7.5.2.4) for 7.5.2
Rational Asset Manager 7.5.3
Rational Asset Manager 7.5.3.1
Rational Asset Manager 7.5.3.2
Rational Asset Manager 7.5.3.3
Rational Asset Manager 7.5.4
Rational Asset Manager 7.5.4.1
Rational Asset Manager 7.5.4.2
Rational Asset Manager 7.5.4.3
Rational Asset Manager 7.5.4.4
Rational Asset Manager 7.5.4.5
Rational Asset Manager 7.5.4.6
Rational Asset Manager 7.5.4.7
Rational Asset Manager 7.5.4.9
Rational Asset Manager 7.5.4.8
Rational Asset Manager 7.5.4.10
APAR status
Closed as fixed if next.
Error description
When attempting to install/setup Rational Asset Manager 7.5.2 and setup an SQL Server database for Rational Asset Manager (RAM) or Rational Team Concert (RTC) database login errors are encountered. The RAM Information Center does not document that Windows Authentication is not supported. SystemOut.log in WebSphere Application Server (WAS) v8.5.x shows SQL Server login errors when doing RAM Setup for the SQL Server 2008 database for RAM and RTC. "... ************ Start Display Current Environment ************ WebSphere Platform 8.5.5.2 [BASE 8.5.5.2 cf021414.01] running with process name HPESSDCPFQ01VNode01Cell\HPESSDCPFQ01VNode01\server1 and process id 1300 Host Operating System is Windows Server 2008 R2, version 6.1 Java version = 1.6.0, Java Compiler = j9jit26, Java VM name = IBM J9 VM was.install.root = C:\Program Files (x86)\IBM\WebSphere\AppServer user.install.root = C:\Program Files (x86)\IBM\WebSphere\AppServer\profiles\RAM Java Home = C:\Program Files (x86)\IBM\WebSphere\AppServer\java\jre ... .. . com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864) [5/27/14 11:34:59:751 PDT] 000000b9 SystemOut O 11:34:59,751 [WebContainer : 0] ERROR com.ibm.ram.repository.setup.web - CRRAM703I: Database - CRRAM3004E - In the server setup application, an error occurred with the message Login failed for user 'sdrb\ibm.jazz.adm'. ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db, SQLSTATE=S0001, and SQL Error code=18,456. For more information, see Rational Asset Manager help system. com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sdrb\ibm.jazz.adm'. ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db at.... .." The following RAM 7.5.2 documentation items fail to state Windows Authentication is not supported with the Microsoft SQL Server database: - Creating a database for assets in Microsoft SQL Server http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.ibm.r am.installguide.doc/topics/configuring_SQL2005.html - Creating databases for asset lifecycles in Microsoft SQL Server http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.ibm.r am.installguide.doc/topics/t_database_RTC_lifecycle_MsSQL.html Under the section "Before you begin", it should state * Windows Authentication (== Windows Integrated Security) is not supported by RAM or RTC setup. Use SQL Server Authentication available as part of Mixed mode ( Windows Authentication and SQL Server Authentication). References: - RTC APAR PI18955: [WI 233472] DOCUMENT THAT "INTEGRATED AUTHENTICATION" IS NOT SUPPORTED https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI18955 - The Support Authority: Resolving connection errors between WebSphere Application Server and SQL Server http://www.ibm.com/developerworks/websphere/techjournal/1011_sup auth/1011_supauth.html
Local fix
Use SQL Server Authentication.
Problem summary
**************************************************************** * USERS AFFECTED: * * none * **************************************************************** * PROBLEM DESCRIPTION: * * When attempting to install/setup Rational Asset Manager * * 7.5.2 * * and setup an SQL Server database for Rational Asset Manager * * (RAM) or Rational Team Concert (RTC) database login errors * * are * * encountered. The RAM Information Center does not document * * that * * Windows Authentication is not supported. * * * * SystemOut.log in WebSphere Application Server (WAS) v8.5.x * * shows * * SQL Server login errors * * when doing RAM Setup for the SQL Server 2008 database for * * RAM * * and RTC. * * * * "... * * ************ Start Display Current Environment ************ * * WebSphere Platform 8.5.5.2 [BASE 8.5.5.2 cf021414.01] * * running * * with * * process name * * HPESSDCPFQ01VNode01Cell\HPESSDCPFQ01VNode01\server1 * * and * * process id 1300 * * Host Operating System is Windows Server 2008 R2, version 6.1 * * Java version = 1.6.0, Java Compiler = j9jit26, Java VM name * * = * * IBM J9 VM * * was.install.root = C:\Program Files * * (x86)\IBM\WebSphere\AppServer * * user.install.root = C:\Program Files * * (x86)\IBM\WebSphere\AppServer\profiles\RAM * * Java Home = C:\Program Files * * (x86)\IBM\WebSphere\AppServer\java\jre * * ... * * .. * * . * * ¶ * * com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) * * ¶ ¶ at * * com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864) * * [5/27/14 11:34:59:751 PDT] 000000b9 SystemOut ¶ ¶ O * * 11:34:59,751 * * [WebContainer : 0] ERROR com.ibm.ram.repository.setup.web * * ¶ ¶ ¶ - CRRAM703I: Database - CRRAM3004E - In the server * * setup * * application, an error occurred with the message Login failed * * for * * user * * 'sdrb\ibm.jazz.adm'. * * ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db, * * SQLSTATE=S0001, and SQL Error code=18,456. For more * * information, * * see * * Rational Asset Manager help system. * * com.microsoft.sqlserver.jdbc.SQLServerException: Login * * failed * * for user * * 'sdrb\ibm.jazz.adm'. * * ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db * * ¶ ¶ at.... * * .." * * * * The following RAM 7.5.2 documentation items fail to state * * Windows Authentication is not supported with the Microsoft * * SQL * * Server database: * * * * - Creating a database for assets in Microsoft SQL Server * * http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.i * * bm.r * * am.installguide.doc/topics/configuring_SQL2005.html * * * * - Creating databases for asset lifecycles in Microsoft SQL * * Server * * http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.i * * bm.r * * am.installguide.doc/topics/t_database_RTC_lifecycle_MsSQL.ht * * ml * * * * Under the section "Before you begin", it should state * * * * * Windows Authentication (== Windows Integrated Security) is * * not * * supported by RAM or RTC setup. * * Use SQL Server Authentication available as part of Mixed * * mode ( * * Windows Authentication and SQL Server Authentication). * * * * * * References: * * - RTC APAR * * PI18955: [WI 233472] DOCUMENT THAT "INTEGRATED * * AUTHENTICATION" * * IS NOT SUPPORTED * * https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI189 * * 55 * * * * - The Support Authority: Resolving connection errors between * * WebSphere Application Server and SQL Server * * http://www.ibm.com/developerworks/websphere/techjournal/1011 * * _sup * * auth/1011_supauth.html * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PI22444
Reported component name
RATL ASSET MGR
Reported component ID
5724R4200
Reported release
752
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-07-21
Closed date
2015-03-10
Last modified date
2015-03-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R752 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUS84","label":"Rational Asset Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"752","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
28 April 2022