E1: MOBJ: File Attachment Retrieval is Slow when using FTP with Huge Number of Files in HTMLUpload Folder
Last updated on APRIL 17, 2018
Applies to:JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.
After upgrading the tools release to 220.127.116.11 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 18.104.22.168 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 22.214.171.124, LIST was performed for a specific file but in 126.96.36.199, list is performed on htmlupload folder and not on specific file. See below log entries:
Upgraded the html instance to 188.8.131.52
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