Background Zip File Processing

If you are uploading a large zip file, you may want to process your zip file in the background and be notified via email when processing completes. You can then pull your "results" zip file using the "ZipFileDownloadServlet".

Note: If you submit through the web UI a large request that takes more than a minute or so to process and do not background it, you will receive a timeout error from the load-balancing proxy in front of your Transportation and Global Trade Management Cloud application server. Your request may not have failed in this case; it may simply still be running but the proxy timed-out waiting for it to complete. However, if your control file does not contain the email notification command described below, you will never be informed as to where the results zip file is located when and if the request completes.

For example, this is a “request” zip file whose name specifies that background processing is desired: test1.bg.zip. Notice that the file name ends with “bg.zip” rather than just “.zip”. This naming convention indicates that background processing is desired. Here is a sample csvutil.ctl file that illustrates how to have an email sent out when processing completes:

-dataFileName activity.csv -command i
-dataFileName activity2.csv -command i
-mailTo customername@example.com -mailFrom customername@example.com -subject zipFileProcessDone -message Hello -smtpHost mail-server.example.com

Note: The last line does not contain the -command parameter, as it is not a database operation, but an email operation to notify you that the CSV operations are complete. It is strongly recommended to put the -mailTo parameter and its related parameters at the last line of the csvutil.ctl file, although they can also be placed earlier to report progress indications. The csvutil.ctl file is executed in the order of the lines within it, so a database operation listed after a -mailto command will not have yet been executed when the email is sent.

Note: Note that the -mailFrom parameter must match one of the registered Mail Sender addresses for your Oracle Transportation Management cloud server, and (if specified) the -smtpHost parameter value must match the value specified for the glog.mail.smtp.external.host property (if a 3third party email service is used instead of Oracle Cloud Infrastructure email); the -smtpHost parameter should not be specified if you are using Oracle Cloud Infrastructure email service.

Selecting on the link in the email takes you to a listing of the zip files on the web server.

You may select on the desired zip file to download it to your local workstation. The zip files ending in "result.zip" are the "results" or "output" zip files.

If things go wrong during background processing, your results zip file will contain error output, which you can read with a text editor rather than WinZip or other unzip tools.