IBM Support

"Initial Publish failed" with " java.lang.OutOfMemoryError : Java heap space" error, caused by large xdbtrickle table

Troubleshooting


Problem

Customer performs a FAP initial publish. This fails. Looking in the FAP "error.log", there is a message indicating out of memory.

Symptom

FAP Client (Logs section)

Initial publish failed
Initial publish for facts/comments failed

Scheduler "Error.log" (by default, here: C:\Program Files\ibm\cognos\ccr_64\server\FAP\error.log):
ERROR RetryInterceptor - Trial 1 failed for method populateFactTable java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) at java.lang.reflect.Method.invoke(Method.java:620) at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:45) at com.ibm.cognos.fap.service.persistence.dao.facts.FactsFAPDaoMSSqlServer$$EnhancerByCGLIB$$db1d8cee.populateFactTable(<generated>) at com.ibm.cognos.fap.service.dimension.facts.BaseFactsHandler.populateFactsTable(BaseFactsHandler.java:191) at com.ibm.cognos.fap.service.dimension.facts.CompositeFactsHandler.populateFactsTable(CompositeFactsHandler.java:180) at com.ibm.cognos.fap.service.dimension.facts.Facts$Transformer.run(Facts.java:123) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:483) at java.util.concurrent.FutureTask.run(FutureTask.java:274) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627) at java.lang.Thread.run(Thread.java:798)

Caused by: java.lang.OutOfMemoryError : Java heap space at com.microsoft.sqlserver.jdbc.Parameter . setValue ( Parameter.java

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg22012743

Page Feedback