MDB Publish Remains in Ongoing State With Implementation Class Not Found Errors for com.ofs.fsapps.alm.mdb.MDBPaymentPattern (Doc ID 2853148.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

On OFSAA 8.1.1.1, MDB Publish is not getting completed and it remains in ongoing state. In the MD publish log, the log ends with the below message:

ERROR

[11-09-21 10:02:44 AM][INFO ] [MDBPublishImpl][publish]---------------------- Calling implementation class [com.ofs.fsapps.alm.mdb.MDBPaymentPattern] for [2501] ---------------------- ----------------------

MDB publish gets stuck here and in the User Interface the status remains in ongoing state.

ALM is not being implemented, only FTP.

As a workaround to publish other apps metadata, did the below:
1) Stop all the OFSAA services along with webserver.
2) Update mdb_publish_execution_dtl set status ='C' , publish_end_time=sysdate where status ='O';
commit;
3) Update MDB_POP_IMPL_LIST set include ='N' where class_name like '%alm%';
commit;
4) re-trigger MDB publish.

The issue can be reproduced at will with the following steps:
1. Navigate to metadata browser screen and trigger MDB publish by selecting the infodom.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.