IBM Support

FAP publish fails with "Caused by: java.lang.OutOfMemoryError" caused by APAR PM66330 (in Controller 8.5.1571 or earlier)

Troubleshooting


Problem

Attempt to publish data to TM1 using FAP., fails. The below error is recorded in the retry.log (.. cognos\c8\server\FAP\retry.log)

Symptom

Retry.log contents

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method at sun.reflect.NativeMethodAccessorImpl.invoke

(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:599)

at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor ntercept(RetryInterceptor.java:50)

at com.ibm.cognos.fap.common.persistence.dao.

DatamartDaoMSSqlServer$$EnhancerByCGLIB$$c2107ad8.loadActiveDatamart <generated>)

at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java 48)

at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java 38)

at java.lang.Thread.run(Thread.java:735)

Caused by: java.lang.OutOfMemoryError

at org.apache.xmlbeans.QNameCache.getName(QNameCache.java:97 at org.apache.xmlbeans.impl.store.Locale$DefaultQNameFactory.getQNam Locale.java:3679)

at org.apache.xmlbeans.impl.store.Locale.makeQualifiedQName(Locale ava:1613)

at org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElemen Locale.java:3198)

at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo avError happened xxxx

Trial 1 failed for method loadFactsFromXdbTrickleat org.apache.xmlbeans mpl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)

at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java 400)

at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714 at org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java 439)

at org.apache.xmlbeans.impl.store.Locale.parse(Locale.java:706 at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java 90)

at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java 77)

at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.pars SchemaTypeLoaderBase.java:208)

at com.ibm.cognos.fap.metadata.MartDefDocument$Factory.parse(Unknow ource)

at com.ibm.cognos.fap.common.persistence.dao.DatamartDao.loadDatamart DatamartDao.java:86)

at com.ibm.cognos.fap.common.persistence.dao.DatamartDao.

loadActiveDatamarts(DatamartDao.java:118)

... 9 more

Error happened xxxx

Trial 1 failed for method xxxx

Cause

Defect (APAR PM66330) in Controller 8.5.1571 or earlier.

This is triggered when the xdbtrickle table in the Controller database holds too much data. This data cannot be loaded into memory on the application server.

Environment

Controller 8.5.1571 or earlier.

Resolving The Problem

Fix.

Upgrade to Controller 8.5.1573 or later 8.5.x release.

Workaround:

Perform a reset sequence to re-synchronise with TM1:

  • For full details of how to do this, see separate IBM Technote #1661294.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21591585