Analysis of Common Errors in rational Portfolio Manager 7.1

An error occurred while stopping the database.

Error Message:'Error occurred during the shutdown of RPM database.'

Analysis: DB2 was not started before the RPM database was installed. Therefore, the installation script view fails to stop DB2.

Solution: Start DB2 and run the installer again.

 

An error occurred while creating the buffer pool.

Error Message:'Error occurred during buffer pool creation.'

Analysis:
Check the log file and find it in bufferpools. log. An error is prompted:

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL1024N A database connection does not exist. SQLSTATE=08003

Check usr_connect.log, and an error is displayed:

SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

Solution: Confirm the user name and password of the DB2 instance and run the installer again.

DB2 environment variable undefined

Error Message:'Error occurred during the creation of RPM CQ Integration default attributes.'
'Error occurred during the creation of RPM default records for custom pivots.'

Analysis:
Check the log file and find it in cq_atr_insert.log. An error is prompted:

SQL0444N Routine "DB2ADMIN.SP_I_ATR" (specific name "SQL071102185959600") is implemented with code in library or path "FUNCTION/IBMRPM", function "SP_I_ATR" which cannot be accessed. Reason code: "4". SQLSTATE=42724

Look at bindall. log again, with the prompt:

Error: not defined

Therefore, check CSP/bindall. BAT and find that the original environment variable db2tempdir is missing from DB2. This variable records the installation path of DB2. If this variable is not defined, the installation of the rational Portfolio Manager database will fail.

Solution: Add variables in Windows:

Name: db2tempdir value: C:/program files/IBM/sqllib/

An error occurred while deleting the stored procedure.

Error Message:'Error occurred during the deletion of RPM store procedures and/or UDFs.'

Analysis:
View the log file and find it in dropsp. log. An error is prompted:

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0204N "DB2ADMIN.PMO_OTFCDY1" is an undefined name. SQLSTATE=42704

This operation is performed before the stored procedure is created. If the stored procedure does not exist, it is normal to receive a warning.

Solution: Ignore.

Unable to connect to RPM Server

Error Message:

“You are unable to connect to the database, possible reasons: …”

Analysis:
If the installation process of your rational Portfolio Manager is correct, it is likely that the connection configuration of the client is incorrect. Check server name (localhost: 9080/ibmrpm ):

1. No "http: //" prefix
2. Port Number acquisition
3. No "/" suffix

Solution: After confirming that the connection information is correct, connect again.