API Key Error  Topic is solved

Discussions relating to the REST API of Jiwa 7.

Re: API Key Error

Postby SBarnes » Wed Jan 15, 2020 9:47 am

On trying to do the file transfer I am getting Response: 550 Cannot STOR. No permission.

The file is 21GB
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: API Key Error

Postby Scott.Pearce » Wed Jan 15, 2020 9:50 am

Just tested using the uploads/uploads account and worked OK. Maybe try breaking up the 21GB file into smaller pieces using WinRAR or similar?
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: API Key Error

Postby SBarnes » Wed Jan 15, 2020 10:14 am

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.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: API Key Error  Topic is solved

Postby Mike.Sheen » Fri Jan 17, 2020 11:55 am

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
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: API Key Error

Postby SBarnes » Fri Jan 17, 2020 12:21 pm

Well the good news is that fixes it, even for custom routes that are added in a secondary plugin.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Previous

Return to REST API

Who is online

Users browsing this forum: No registered users and 1 guest

cron