OFSAA Data Model Upload / Upload.sh Fails After Installing OFSAAI 8.0.4.2.0 Patch (Doc ID 2373281.1)

Last updated on MARCH 10, 2023

Applies to:

Symptoms

After upgrading to Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 8.0.4.2.0 (Patch 27367416), the data model upload is broken.  You cannot execute the user interface upload or the upload.sh.

When you try to run the model upload from the 'Data Model Maintenance' screen, nothing happens and your Upload definition is not listed in the Summary screen.  The following error exists in the web server's nohup.out:

Weblogic:

java.lang.NoSuchMethodError: etl.upload.ClsUEntFile.setDdlFlag(Z)V
       at com.ofs.reveleus.modelUpload.handlers.ModelUploadHandler.startModelUpload(ModelUploadHandler.java:377)
       at com.ofs.reveleus.modelUpload.handlers.ModelUploadHandler.handleAction(ModelUploadHandler.java:118)
       at com.ofs.reveleus.modelUpload.servlet.ModelUploadServlet.service(ModelUploadServlet.java:192)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
       at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
       Truncated. see log file for complete stacktrace

Tomcat (from localhost.xxx.log):

17-Mar-2018 16:54:13.674 SEVERE [http-nio-<port>-exec-6] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [ModelUploadServlet] in context with path [/ofsaa80] threw exception [Servlet execution threw an exception] with root cause
java.lang.NoSuchMethodError: etl.upload.ClsUEntFile.setDdlFlag(Z)V
       at com.ofs.reveleus.modelUpload.handlers.ModelUploadHandler.startModelUpload(ModelUploadHandler.java:377)
       at com.ofs.reveleus.modelUpload.handlers.ModelUploadHandler.handleAction(ModelUploadHandler.java:118)
       at com.ofs.reveleus.modelUpload.servlet.ModelUploadServlet.service(ModelUploadServlet.java:192)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at com.iflex.fic.filters.FilterServlet.doFilter(FilterServlet.java:1026)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at com.iflex.fic.filters.EncodingFilter.doFilter(EncodingFilter.java:97)
       etc.

When you try to run the model upload using the upload.sh in $FIC_APP_HOME/common/FICServer/bin, the following error occurs:

LIBJARS Set as /opt/ofsaa/ofsa/ficapp/common/FICServer/lib/FICServer.jar:/opt/ofsaa/ofsa/ficapp/common/FICServer/lib/dateent.jar:/opt/ofsaa/ofsa/ficapp/common/FICServer/lib/UploadModelUtil.jar:/opt/ofsaa/ofsa/ficapp/common/FICServer/lib/JSON_parser.jar
Executing Process...
Picked up JAVA_TOOL_OPTIONS: -Xss2M
[JSPInitBean] Error while initializing Services
java.lang.Exception: Services file not found at FALSE/conf/DynamicServices.xml
       at com.iflex.fic.newservice.DynamicServiceManager.initializeServiceMaster(DynamicServiceManager.java:74)
       at com.iflex.fic.ficml.JSPInitBean.defaultInitialize(JSPInitBean.java:224)
       at UploadModel.UploadDataModel.main(UploadDataModel.java:131)
Welcome to Model Upload
Number of args is 17
The FIC_HOME path is FALSE
Please Set Proper Arguments... 0.DSNName 1.ErwinFilePath 2.username 3.UploadChoicecode 4. ModelUploadType 5.startsFilter 6.containsFilter 7. endsfilter 8.runSQLScripts 9. constaintNoValidate 10. considerCustomization 11. Object Registration Mode 12.$FIC_HOME

You entered the correct parameters in the upload.sh, including values for the new parameters:

<DatabaseXMLFlag>
<DDLMigrationFlag>
<DDL Logs Flag>

But the error continues to occur.

Cause

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