Reading FlatFiles from Amazon S3 Bucket

AlanParsons

Member
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/tempfolder/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
 
The easiest approach would be to use the storage gateway, from AWS, to access the data.
 
You're missing your configuration. If you're on a AS/400 that could be an issue.
 
Back
Top