IBM Support

"Initial publish failed ... Initial publish for facts/comments failed ... " caused by 'db2fmp64.exe' crashing (on the DB2 server)

Troubleshooting


Problem

User launches the FAP client, and stars to run an Initial Publish. User then clicks on the tab 'Logs' to see how the publish is progressing. After a while, there is an error.

 

Symptom

Screen error:

image-20181206125332-1

Initial publish failed

Initial publish for facts/comments failed

 

Entry inside 'Error.log' file: (by default, here: C:\Program Files\ibm\cognos\ccr_64\server\FAP\error.log):

08:18:20,855 | ERROR [common.persistence.retry.RetryInterceptor] [pool-4-thread-9], Trial 1 failed for method populateFactTable
java.lang.reflect.InvocationTargetException
 at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
 at java.lang.reflect.Method.invoke(Method.java:508)
<.............................>

<.............................>
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
 at java.lang.Thread.run(Thread.java:811)
Caused by:
com.ibm.cognos.fap.common.exception.LoggedException: Could not populate facts table f_md_FAP
 at com.ibm.cognos.fap.service.persistence.dao.facts.FactsFAPDao.populateFactTable(FactsFAPDao.java:147)
 ... 13 more
Caused by:
com.ibm.db2.jcc.am.qo: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=<user_name>.F_MD_FAP, DRIVER=3.58.68
 at com.ibm.db2.jcc.am.ed.a(ed.java:676)
 at com.ibm.db2.jcc.am.ed.a(ed.java:60)
<.............................>

<.............................>
 at com.ibm.db2.jcc.am.tm.addBatch(tm.java:2266)
 at org.apache.commons.dbcp.DelegatingPreparedStatement.addBatch(DelegatingPreparedStatement.java:172)
 at com.ibm.cognos.fap.service.persistence.dao.facts.FactsFAPDao.populateFactTable(FactsFAPDao.java:142)
 ... 13 more

 

Event Viewer (application log) on DB2 (database server):

Log Name:      Application
Source:        Application Error
Date:          12/5/2018 8:16:44 AM
Event ID:      1000
Task Category: (100)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      DB2SVR1
Description:
Faulting application name: db2fmp64.exe, version: 10.5.800.381, time stamp: 0x57cb86b6
Faulting module name: ntdll.dll, version: 6.3.9600.19153, time stamp: 0x5b93ffa7
Exception code: 0xc0000005
Fault offset: 0x000000000002dc62
Faulting process id: 0x2da0
Faulting application start time: 0x01d48c72c463880a
Faulting application path: C:\Program Files\IBM\SQLLIB\BIN\db2fmp64.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: 19a78fb5-f866-11e8-80d3-06200b79c5f4
Faulting package full name:
Faulting package-relative application ID:

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"FAP","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.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:
09 May 2025

UID

ibm10744477

Page Feedback