APAR status
Closed as program error.
Error description
Environment: TEPS, Install, Configuration DB2 or Oracle database AIX, Linux Customer found problem in ITM 6.2 FP1 and in ITM 6.2.1 Latest patches did not cause this problem. Problem Description: Since passwords are encrypted in the configuration files and are masked in the RAS1 trace los and also in the install and configure trace logs, the problem is difficult to diagnose. The issue shows as a connection failure to the WAREHOUSE database. The problem is not specific to either DB2 or Oracle. When the password for the Warehouse user contains a $, the parsing of thecq.ini file has an error which causes a bad datasource string to be generated. A bad datasource string for the TEPS database can also occur if the DB2 user password contains a $. Enter a password which contains a $ while configuring the TEPS will cause this problem. Detailed Recreation Procedure: 1) Make sure that there are two different IDs that can be used to access the Warehouse DB. 2) Change the login password of the first ID (WH1) to abc$:.123 3) Change the login password of the first ID (WH2) to abc:.123 4) Install the TEPS and Warehouse Proxy Agent 5) Configure the TEPS and specify WH2 and the password with no $ as the Warehouse user id and password. 6) Configure the WPA and specify WH2 and the password with no $ as the Warehouse user id and password. 7) Start the TEPS and WPA and generate some history. 8) Wait a day ( or use an existing Warehouse DB with history older than one day) 9) Verify that you can access the history from the Warehouse DB which is older than one day. 10) Stop the TEPS and WPA 11) Configure the TEPS and specify WH1 and the password with a $ as the Warehouse user id and password. 12) Start the TEPS and WPA and generate some history. 14) Verify that you can NOT access the history from the Warehouse DB which is older than one day. which is older than one day. NOTE: You can run these test with the following tracing set if you wish to verify that have entered the correct ID and PW for each case. This can be confirmed by adding at least "ERROR (UNIT:ctsql IN,ER,DET)" tracing, so that you can see the decrypted user / password from the data sources referenced within the TEPS RAS1 log. For example, for the TEPS datasource, you normally see something like this: (494D7073.0006-9:ctsqlconnectionodbc.cpp,426,"CTSQLEvaluatorODBC _i::Conn ection::establishConnection") connectionString: DSN=TEPS;UID=itmuser;PWD=ibmdb2;CONNECTION_TYPE=DB2;CONNECTION_L IMIT=100
Local fix
remove $ from password
Problem summary
When the password for the warehouse database user ID contains a dollar symbol($), the parsing of the cq.ini file causes a bad datasource string to be generated. A bad datasource string for the portal server database can also occur if the DB2 user password contains a dollar symbol.
Problem conclusion
The code was changed to handle the dollar symbol in a database user ID password. The fix for this APAR is contained in the following maintenance packages: | interim fix | 6.2.0.3-TIV-ITM-IF0001
Temporary fix
If possible, avoid using the dollar symbol for database user ID passwords.
Comments
APAR Information
APAR number
IZ43731
Reported component name
OMEG DIST INSTA
Reported component ID
5608A41CI
Reported release
620
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-12
Closed date
2009-06-30
Last modified date
2009-07-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
OMEG DIST INSTA
Fixed component ID
5608A41CI
Applicable component levels
R620 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTFXA","label":"Tivoli Monitoring"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"620","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 November 2022