APAR status
Closed as program error.
Error description
Apache rediscovery errors with: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.64.106 ApacheServerSessionSeeds in support of rediscovery is failing due to seed size exceeding DB BLOB storage column size. A lighter copy of seed can be stored by removing unnecessary extra runtime process list information as has been done for WeblogicServerSeed. log shows: 2017-01-19 09:14:06,028 TopologyManager [RMI TCP Connection(4608)-11.222.333.444] com.collation.platform.model.discovery.profile.ObjectRediscovery Info DEBUG topomgr.ModelObjectPersister - isIncorrectXMLException for e: javax.jdo.jdodatastoreexception: insert of object "com.collation.topomgr.jdo.discovery.profile.objectrediscoveryin fojdo@34 c1e4ec" using statement "insert into taddmusr.objrdisc (description_x,xa_x,seed_x,bidiformat_x,agentconfigurationguid_x ,osgiplu ginid_x,cmdbsource_x,adminstate_x,guid_x,deleted_x,runid_x,sourc etoken_x ,lastmodifiedby_x,hierarchy type_x,version_x,xd_x,displayname_x,bidiflag_x,createdby_x,agent configur ationname_x,contextip_x,cdmsource_x,objguid_x,serverid_x,locatio ntag_x,a ttrprios_x,laststoredtime_x,objecttype_x,hierarchydomain_x,label _x,lastm odifiedtime_x,priority_x,addressscope_x,pk_x,jdolockx,jdoclassx) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,? )" failed : db2 sql error: sqlcode=-302, sqlstate=22001, sqlerrmc=null, driver=3.64.106 failedobject:com.collation.topomgr.jdo.discovery.profile.objectr ediscove ryinfojdo@34c1e4ec nestedthrowables: com.ibm.db2.jcc.am.sqldataexception: db2 sql error: sqlcode=-302, sqlstate=22001, sqlerrmc=null, driver=3.64.106 2017-01-19 09:14:06,029 TopologyManager [RMI TCP Connection(4608)-11.222.333.444] com.collation.platform.model.discovery.profile.ObjectRediscovery Info WARN jdo.BaseJdo - Top(6F8BE6F0A85237CC9ED9767349996265-0) failed, no replacement found out of DB javax.jdo.JDODataStoreException: Insert of object "com.collation.topomgr.jdo.discovery.profile.ObjectRediscoveryIn foJdo@34 c1e4ec" using statement "INSERT INTO TADDMUSR.OBJRDISC (DESCRIPTION_X,XA_X,SEED_X,BIDIFORMAT_X,AGENTCONFIGURATIONGUID_X ,OSGIPLU GINID_X,CMDBSOURCE_X,ADMINSTATE_X,GUID_X,DELETED_X,RUNID_X,SOURC ETOKEN_X ,LASTMODIFIEDBY_X,HIERARCHYTYPE_X,VERSION_X,XD_X,DISPLAYNAME_X,B IDIFLAG_ X,CREATEDBY_X,AGENTCONFIGURATIONNAME_X,CONTEXTIP_X,CDMSOURCE_X,O BJGUID_X ,SERVERID_X,LOCATIONTAG_X,ATTRPRIOS_X,LASTSTOREDTIME_X,OBJECTTYP E_X,HIER ARCHYDOMAIN_X,LABEL_X,LASTMODIFIEDTIME_X,PRIORITY_X,ADDRESSSCOPE _X,PK_X, JDOLOCKX,JDOCLASSX) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,? )" failed : DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.64.106 FailedObject:com.collation.topomgr.jdo.discovery.profile.ObjectR ediscove ryInfoJdo@34c1e4ec at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusEx ception( NucleusJDOHelper.java:311) at org.datanucleus.jdo.JDOPersistenceManager.jdoMakePersistent(JDOP ersisten ceManager.java:661) at org.datanucleus.jdo.JDOPersistenceManager.makePersistent(JDOPers istenceM anager.java:681)
Local fix
disable re-discovery
Problem summary
**************************************************************** * USERS AFFECTED: * * TADDM User * **************************************************************** * PROBLEM DESCRIPTION: * * The following error is encountered on Apache server * * re-discovery: * * com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: * * SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.64.106 * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is contained in the following maintenance packages: | Fix Pack | 7.3.0-TIV-ITADDM-FP0004
Temporary fix
Comments
APAR Information
APAR number
IV95455
Reported component name
APP DEPENDENCY
Reported component ID
5724N5500
Reported release
730
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-04-26
Closed date
2017-10-09
Last modified date
2017-10-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
999
Fix information
Fixed component name
APP DEPENDENCY
Fixed component ID
5724N5500
Applicable component levels
R730 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":"730","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
09 October 2017