E1: MOBJ: File Attachment Retrieval is Slow when using FTP with Huge Number of Files in HTMLUpload Folder

(Doc ID 2323195.1)

Last updated on OCTOBER 31, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

After upgrading the tools release to 9.2.1.5 media object file fetch operation is slow when using ftp and when files are stored in the file server and not in database.

Depending on the number files in the htmlupload folder, the slowness will vary. For about 500K files , it is delayed by around 30 seconds. Same issue does not happen in 9.2.1.4 tools release. Upon reviewing the jas debug log from both the tools releases, it is observed that there is a change in FTP LIST operation. In 9.2.1.4, LIST was performed for a specific file but in 9.2.1.5, list is performed on htmlupload folder and not on specific file. See below log entries:

 

Changes

Upgraded the html instance to 9.2.1.5

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms