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 filename 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.
Clicking on the link in the email takes you to a listing of the zip files on the web
server.
You may click 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 a
textual stack trace (even though it is identified as a zip file), which you can read
with a text editor (such as Notepad or vi) rather than WinZip or other unzip tools.