APAR status
Closed as program error.
Error description
In verify-tool log you can find: generator.DuplicatesVerificationGenerator - Executing sql: select DOMNAMCT.guid_x, DOMNAMCT.displayname_x, DOMNAMCT.jdoclassx, DOMNAMCT.lastmodifiedtime_x, DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X, DOMNAMCT.CONTEXTNO_X from DOMNAMCT where DOMNAMCT.deleted_x = 0 and (concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a'))) in (select concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) from DOMNAMCT where DOMNAMCT.deleted_x = 0 and jdoclassx in ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte xtJdo') and DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X is not null and DOMNAMCT.CONTEXTNO_X is not null group by concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) having count(guid_x) > 1) and DOMNAMCT.jdoclassx in ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte xtJdo') ORDER BY 5, 6, 4 DESC 2014-06-24 01:01:19,790 [main] DEBUG generator.DuplicatesVerificationGenerator - com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=CONCAT;FUNCTION, DRIVER=3.63.75 at com.ibm.db2.jcc.am.fd.a(fd.java:679)
Local fix
Problem summary
In verify-tool log you can find: generator.DuplicatesVerificationGenerator - Executing sql: select DOMNAMCT.guid_x, DOMNAMCT.displayname_x, DOMNAMCT.jdoclassx, DOMNAMCT.lastmodifiedtime_x, DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X, DOMNAMCT.CONTEXTNO_X from DOMNAMCT where DOMNAMCT.deleted_x = 0 and (concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a'))) in (select concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) from DOMNAMCT where DOMNAMCT.deleted_x = 0 and jdoclassx in ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte xtJdo') and DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X is not null and DOMNAMCT.CONTEXTNO_X is not null group by concat('a', concat(DOMNAMCT.PK__PARENTDOMINOTEXT_824275E5X , 'a')), concat('a', concat(DOMNAMCT.CONTEXTNO_X , 'a')) having count(guid_x) > 1) and DOMNAMCT.jdoclassx in ('com.collation.topomgr.jdo.topology.app.lotus.DominoNamingConte xtJdo') ORDER BY 5, 6, 4 DESC 2014-06-24 01:01:19,790 [main] DEBUG generator.DuplicatesVerificationGenerator - com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=CONCAT;FUNCTION, DRIVER=3.63.75 at com.ibm.db2.jcc.am.fd.a(fd.java:679)
Problem conclusion
The fix for this APAR is contained in the following maintenance packages: | Fix Pack | 7.2.1-TIV-ITADDM-FP0007 | Fix Pack | 7.2.2-TIV-ITADDM-FP0003 Check the IBM Software Support web site for availability of the above maintenance packages.
Temporary fix
Comments
APAR Information
APAR number
IV61984
Reported component name
APP DEPENDENCY
Reported component ID
5724N5500
Reported release
721
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-06-26
Closed date
2014-11-27
Last modified date
2014-11-27
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
APP DEPENDENCY
Fixed component ID
5724N5500
Applicable component levels
R721 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSPLFC","label":"Tivoli Application Dependency Discovery Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"721","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
27 November 2014