APARs fixed in IBM Content Manager Version 8.4.3.2

Content

APAR IO14472

Abstract: Some of the Japanese PDF documents are not being returned from Content Manager Text search query.

Error Description: Some of the Japanese characters in the PDF form fields are not fully extracted correctly.
As a result, documents that contain these characters cannot be found using a query.

Local fix: N/A


Problem conclusion: The problem is now fixed in Content Manager Version 8.4.3 Fix Pack 2.

Temporary fix: N/A

Comments: None

========================================================================================

APAR IO14731

Abstract: Privilege error LS RC=7215 , reason code 140 occurs when opening a system-assigned worklist.

Error Description: When you try to open a system-assigned worklist, you might intermittently get the following error, even if you are a Content Manager system administrator with super user privilege:

Failed to retrieve next item in workbasket: DGL3688A: The user [ICM Super System Administrator] does not have the general privilege needed to perform this operation, the required privilege is [ItemGetWork].; ICM7215: The user does not have the privilege required to perform the requested operation, or the ACL does not include the user with the required privilege. The privilege code is contained in the reason code returned from the library server. (STATE) : [LS RC = 7215, LS reasonCode = 140, SQL state = 4] [ItemGetWork/ItemGetAssignedWork]" returnCode="0"

Local fix: N/A

Problem summary: This problem occurs only on Content Manager Version 8.4.2 Fix Pack 3 when a 64-bit library server is used.

Problem conclusion: The problem is now fixed in Content Manager Version 8.4.3 Fix Pack 2.

Temporary fix: N/A

Comments: None

===============================================================================================

APAR IO15007

Abstract: Objects bigger than 100 MB intermittently failed to replicate.

Error Description: When the resource manager tries to replicate an object with size of 100 MB or above,
you might get the following error in the resource manager log:

ICMRM:WARN 2011-09-19 13:53:19.254000 context: [WorkManager.icmrm_RMWorkManager : 31] - ICM9798: Error calling library server stored procedure. RC = 7015 Reason = -103 ExtRC = 0 ExtReason = 0 - updateRMObject(ALibraryServerConnectionSP.java:594) ICMRM:DEBUG 2011-09-19 13:53:19.254000 context: [WorkManager.icmrm_RMWorkManager : 31] - Failed to update LS Metadata. Setting replication task to: REPLICATION_COMPLETED_PENDING_LS_UPDATE for itemID: A1001001A11C31B90111G44335 LS Return Error Code: 7015 - updateObjectMetadata(RemoteReplicationWorker.java:464)

In the library server log, you might find following error:

ICMADMIN SQL ERROR: SQL0103N The numeric literal "277871944.000000A1001001A11H29B03634B03714" is not valid. SQLSTATE=42604 <SQL0103N The numeric literal "277871944.000000A1001001A11H29B03634B03714" is not valid. SQLSTATE=42604 > <SQLSTATE 42604: An invalid numeric or string constant has been detected. >

Local fix: N/A

Problem summary: The problem was due to a mishandling of a float number in library server.

Problem conclusion: The problem is now fixed in Content Manager Version 8.4.3 Fix Pack 2.

Temporary fix: N/A

Comments: None

===============================================================================================

APAR IO15442

Abstract: The library server table ICMSTITEMSTODELETE keeps increasing in size.

Error Description: The size of the library server ICMSTITEMSTODELETE table keeps increasing.

Analysis shows that one of the SQL statements in the library server has an inefficient access plan that causes table scans and runs very slowly. If the item delete operations are running faster than the asynchronous process, the ICMSTITEMSTODELETE table will keep increasing in size until the disk is full.

Local fix:
Create the new index:

1. Do db2 create INDEX INDEX1 ON ICMSTITEMSTODElETE(RMCODE,
   SMSCOLLCODE).
2. Run db2 runstats, and rebind.
   

Problem summary: Asynchronous delete process is running slow.

Problem conclusion: The problem is now fixed in Content Manager Version 8.4.3 Fix Pack 2 by adding a new index to ICMSTITEMSTODELETE table to enhance the performance.

Temporary fix: N/A

Comments: None

===============================================================================================

APAR IO15507

Abstract: Error "LS RC = 7123, SQL RC = 100" occurs during retrieve document.

Error Description: During the retrieval of a document, you might get the "LS RC = 7123, SQL RC = 100" error.

In the library server log, you might find following error:

ICMPLSGD ICMGETDOCTOC                     01071 11/02 12:58:26.303 GMT       
;02125738745755 d9:13361d5349b:X666a HSVAS Input                             
   ACLBindLevel    2                                                         
   lACLPrivCode    121                                                       
   pszItemID       <A1001001A11J24B22012I97692>                              
   sVersionID     1                                                          
ICMPLSGD ICMGETDOCTOC                     01378 11/02 12:58:26.303 GMT       
;02125738745755 d9:13361d5349b:X666a HSVAS ICM_ACLBINDING_COMBINED           
   ItemTypeClass 2                                                           
   ItemACLFlag   0                                                           
ICMPLSGD ICMGETDOCTOC                     01392 11/02 12:58:26.303 GMT       
;02125738745755 d9:13361d5349b:X666a HSVAS ACLBinding_Combined               
   plITViewID   1073                                                         
ICMPLSGD ICMGETDOCTOC                     01431 11/02 12:58:26.303 GMT       
;02125738745755 d9:13361d5349b:X666a HSVAS                                   
Unexpected error. Incorrect ITEMID A1001001A11J24B22012I97692 or Item        
Type Base/Sub ViewID 1073.                                                   
No record returned from following SQL:                                       
 SELECT B.ACLCODE, C.ITEMLEVELACLFLAG                                        
   FROM ICMSTITEMS001001 A,                                                  
        ICMSTITVIEWDEFS B,                                                   
        ICMSTITEMTYPEDEFS C                                                  
  WHERE A.ITEMID = 'A1001001A11J24B22012I97692' AND                          
        A.ITEMTYPEID = B.ITEMTYPEID AND                                      
        B.ITEMTYPEID = C.ITEMTYPEID AND                                      
        B.ITEMTYPEVIEWID = 1073                                              
                                                                             
ICMPLSGD ICMGETDOCTOC                     00439 11/02 12:58:26.303 GMT       
;02125738745755 d9:13361d5349b:X666a HSVAS Error - PRIV_ITEM_SQL_SELECT      
failed.                                                                      
ICMPLSGD ICMGETDOCTOC                     00440 11/02 12:58:26.303 GMT       
;02125738745755 d9:13361d5349b:X666a HSVAS Exit rc=7123 reason=0             
extrc=100 extreason=0 LCT =2011/11/02 06:58:26.303 PID=7592                  


Local fix:

Problem summary: The problem is caused by the orphaned items in the library server table icmstitems001001. The orphaned items most likely are the result of mishandling of the DB2 error in library server.

Problem conclusion: The problem is now fixed in Content Manager Version 8.4.3 Fix Pack 2 by correcting the handle of DB2 errors in library server.

Temporary fix: N/A

Comments: None

======================================================================================

APAR IO15642

Abstract: The Content Manager Enterprise Edition 8.4.3 information center contains an incorrect command for stopping the library server monitor.

Error Description: The Content Manager Enterprise Edition Version 8.4.3 information center incorrectly documents /etc/rc.cmlsproc -stop as the command to stop the library server monitor in a UNIX environment.

Local fix: N/A

Problem summary: The Content Manager Enterprise Edition Version 8.4.3 information center incorrectly documents /etc/rc.cmlsproc -stop as the command to stop the library server monitor.

Problem conclusion: The correct command to stop the library server monitor is: /etc/rc.cmlsproc -shutdown

Temporary fix: N/A

Comments: None

=========================================================================================