APAR status
Closed as program error.
Error description
This APAR removes a syntax error in the SQL script that upgrades parts of the JCR database domain on DB2 for z/OS. . Affected users: Customers migrating from Portal 6.0 to Portal 6.1 and having the JCR domain on DB2 for z/OS.
Local fix
Problem summary
This APAR removes a syntax error in the SQL script that upgrades parts of the JCR database domain on DB2 for z/OS. The APAR is needed if this error message can be observed: [sqlproc] CREATE TABLE L25DBADM.APPROLE_LOD ( [sqlproc] APPROLE_OID CHAR(18) FOR BIT DATA NOT NULL, [sqlproc] LOCALE VARCHAR(64) NOT NULL, [sqlproc] TITLE VARGRAPHIC(255) NOT NULL, [sqlproc] DESCRIPTION VARGRAPHIC(1024), [sqlproc] CONSTRAINT PK2235 PRIMARY KEY (APPROLE_OID, LOCALE), [sqlproc] CONSTRAINT FK2235 FOREIGN KEY (APPROLE_OID) REFERENCES L25DBADM.APPLICATION_ROLE (OID) ON DELETE CASCADE [sqlproc] ) [sqlproc] Error during statement execution! [sqlproc] com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -879, SQLSTATE: 53095, SQLERRMC: L25DBADM.APPROLE_LOD;EBCDIC [sqlproc] at com.ibm.db2.jcc.c.kh.c(kh.java:1660) [sqlproc] at com.ibm.db2.jcc.c.kh.d(kh.java:1648) [sqlproc] at com.ibm.db2.jcc.c.kh.b(kh.java:1159) [sqlproc] at com.ibm.db2.jcc.b.db.h(db.java:219) [sqlproc] at com.ibm.db2.jcc.b.db.b(db.java:46) [sqlproc] at com.ibm.db2.jcc.b.t.b(t.java:40) [...]
Problem conclusion
Corrections in the corresponding SQL scripts. SQL script will be replaced. Failing Module(s): Database Affected Users: Migration from 6.0 to 6.1 and JCR domain on DB2 for z/OS Version Information: Portal Version(s): 6.1.0.0 Pre-Requisite(s): Co-Requisite(s): --- Platform Specific: This fix applies to all platforms. A fix is available from Fix Central: http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde r?apar=PK70174&productid=WebSphere%20Portal&brandid=5 You may need to type or paste the complete address into your Web browser.
Temporary fix
Comments
APAR Information
APAR number
PK70174
Reported component name
WEBSPHERE PORTA
Reported component ID
5724E7600
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-08-06
Closed date
2008-11-20
Last modified date
2008-11-20
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
WEBSPHERE PORTA
Fixed component ID
5724E7600
Applicable component levels
R610 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
21 December 2021