Page 2 of 2

Re: API Key Error

PostPosted: Wed Jan 15, 2020 9:47 am
by SBarnes
On trying to do the file transfer I am getting Response: 550 Cannot STOR. No permission.

The file is 21GB

Re: API Key Error

PostPosted: Wed Jan 15, 2020 9:50 am
by Scott.Pearce
Just tested using the uploads/uploads account and worked OK. Maybe try breaking up the 21GB file into smaller pieces using WinRAR or similar?

Re: API Key Error

PostPosted: Wed Jan 15, 2020 10:14 am
by SBarnes
Thanks Scott

Looks like your ftp must have a maximum limit when split into three files of approximately 7GB its actually now working, where as before the process wouldn't even start.

Re: API Key Error  Topic is solved

PostPosted: Fri Jan 17, 2020 11:55 am
by Mike.Sheen
The problem is the Jiwa database login function not parsing the ExpiryDateTime of API Keys correctly. The debtor which fails for you has a debtor API Key with an expiry date set, the other debtor API Key which works does not.

Logged as DEV-8010. Work around is to set the ExpiryDateTime of the API Key to NULL via SQL:

Code: Select all
UPDATE DB_APIKey SET ExpiryDateTime = NULL

Re: API Key Error

PostPosted: Fri Jan 17, 2020 12:21 pm
by SBarnes
Well the good news is that fixes it, even for custom routes that are added in a secondary plugin.