My Oracle Support Banner

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 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.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.