IO14311: LS CONFIGURATION FAILED WITH RC=129 WHEN UPGRADE TO 8.4.3, WHEN IT'S MULTIPLE LANGUAGE ENVR.

APAR status

• Closed as unreproducible.

Error description

• LS configuration failed with the error below when upgrade CM
  envr with multi-language to 8.4.3 .
  
  ERROR ->Fail to execute:
  
       INSERT INTO ICMSTNLSKEYWORDS (KEYWORDCLASS,
  LANGUAGECODE,
  KEYWORDCODE, KEYWORDNAME, KEYWORDDESCRIPTION)     SELECT 1,
  LANGUAGECODE,        (SELECT MAXKEYWORD FROM ICMSTMAXKEYWORD
  WHERE
  KEYWORDCLASS=1), 'ICM$NAME',        CASE WHEN LANGUAGECODE='ENU'
  THEN ''
  ELSE '*' END || 'ICM hierarchical name'     FROM
  ICMSTNLSLANGUAGES A
  WHERE NOT EXISTS (SELECT 1 FROM ICMSTNLSKEYWORDS B        WHERE
  B.LANGUAGECODE = 'ENU' AND B.KEYWORDCLASS = 1 AND B.KEYWORDNAME
  =
  'ICM$NAME')
  
  com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-811,
  SQLSTATE=21000, SQLERRMC=null, DRIVER=3.53.95
  
  
  Return code:  129
   Message code: DBU01330E
   Message: Failed to complete necessary action on the file
  F:\Programs\IBM\db2cmv8\config\icmplsdml.ddl.
   Exception: DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000,
  SQLERRMC=null,
  DRIVER=3.53.95
   Exception stack trace:
  com.ibm.cm.dbutil.ICMDBUtilsException: DB2 SQL Error:
  SQLCODE=-811,
  SQLSTATE=21000, SQLERRMC=null, DRIVER=3.53.95
   at
  com.ibm.cm.dbutil.ICMConfigureDB.executeSQL(ICMConfigureDB.java:
  2107)
   at
  com.ibm.cm.dbutil.ICMUpgradeLSDB.doInstall(ICMUpgradeLSDB.java:1
  576)
   at
  com.ibm.cm.dbutil.ICMUpgradeLSDB.performUpgrade(ICMUpgradeLSDB.j
  ava:1123
  )
   at
  com.ibm.cm.dbutil.ICMUpgradeLSDB.start(ICMUpgradeLSDB.java:2845)
   at
  com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:226)
   at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:376)
   at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:514)
  

Local fix

• 1. backup the icmplsdml.ddl in the installationimage\config
  directo
  2. modify the following line icmplsdml.ddl
  
  modify
  
  INSERT INTO ICMSTNLSKEYWORDS (KEYWORDCLASS, LANGUAGECODE,
  KEYWORDCODE, KEYWORDNAME, KEYWORDDESCRIPTION) SELECT 1,
  LANGUAGECODE, (SELECT MAXKEYWORD FROM ICMSTMAXKEYWORD WHERE
  KEYWORDCLASS=1), 'ICM$NAME', CASE WHEN LANGUAGECODE='ENU' THEN
  ''
  ELSE '*' END || 'ICM hierarchical name' FROM ICMSTNLSLANGUAGES A
  WHERE NOT EXISTS (SELECT 1 FROM ICMSTNLSKEYWORDS B WHERE
  B.LANGUAGECODE = 'ENU' AND B.KEYWORDCLASS = 1 AND B.KEYWORDNAME
  =
  'ICM$NAME')
  
  to
  
  INSERT INTO ICMSTNLSKEYWORDS (KEYWORDCLASS, LANGUAGECODE,
  KEYWORDCODE, KEYWORDNAME, KEYWORDDESCRIPTION) SELECT 1,
  LANGUAGECODE, (SELECT MAXKEYWORD FROM ICMSTMAXKEYWORD WHERE
  KEYWORDCLASS=1 AND LANGUAGECODE='ENU'), 'ICM$NAME', CASE WHEN
  LANGUAGECODE='ENU' THEN ''
  ELSE '*' END || 'ICM hierarchical name' FROM ICMSTNLSLANGUAGES A
  WHERE NOT EXISTS (SELECT 1 FROM ICMSTNLSKEYWORDS B WHERE
  B.LANGUAGECODE = 'ENU' AND B.KEYWORDCLASS = 1 AND B.KEYWORDNAME
  =
  'ICM$NAME')
  
  3/ re-run the 8.4.3 upgrade program.
  

Problem summary

• During an update of IBM Content Manager Enterprise Edition to
  version 8.4.3 on a multiple language environment, the error
  "SQLCODE=-811" is received.
  

Problem conclusion

• This problem is fixed in the Content Manager EE Version 8.4.3
  revised updater.
  

Temporary fix

Comments

APAR Information

• 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