Results 1 to 3 of 3

Thread: Reading FlatFiles from Amazon S3 Bucket

  1. #1

    Reading FlatFiles from Amazon S3 Bucket

    Hi

    Customer uses the Amazon S3 buckets ( .csv / .txt) to store bank files. We need to read and upload them in JDE. I tried to used the FetchNextLineFromFlatFile (B76B0220) function but it fails. Checked the debuglog and it gives the 3003 error code (Open of File Unsuccessful). The files / S3 buckets have all the permissions required to read the files. Am I missing anything?


    Release : 9.2.0.3

    Thanks!!

    Feb 10 12:56:21.194009 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 1] <Item>: szFlatFileName <type>: STRING <Value>: [https://s3.us-east-2.amazonaws.com/t...r/Tesfile.csv]
    Feb 10 12:56:21.194010 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 2] <Item>: idFilePtr <type>: ID <Value>: [0]
    Feb 10 12:56:21.194011 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 3] <Item>: szFlatFileRecord <type>: STRING <Value>: []
    Feb 10 12:56:21.194012 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 4] <Item>: mnRecordLength <type>: MATH_NUMERIC <Value>: [500]
    Feb 10 12:56:21.194013 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 5] <Item>: cSuppressErrorMessage <type>: CHAR <Value>: []
    Feb 10 12:56:21.194014 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 6] <Item>: cErrorCode <type>: CHAR <Value>: [2]
    Feb 10 12:56:21.194015 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 7] <Item>: szErrorMessageID <type>: STRING <Value>: [3003]
    Feb 10 12:56:21.194016 - 3124/2236 WRK:Starting jdeCallObject

  2. #2
    The easiest approach would be to use the storage gateway, from AWS, to access the data.

  3. #3
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,114
    You're missing your configuration. If you're on a AS/400 that could be an issue.
    Larry Jones
    E1 9.1 - TR 9.1.5 on Win 2012 R2. Oracle DB 11.2.04
    WebLogic 12.1.3, Wintel, BI Publisher

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.