Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024567
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalalways2013-08-23 03:002013-08-23 12:13
ReporterpjuvaraView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP24.2SCM revision 
Review Assigned Todmitry_mezentsev
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024567: Zoho Reports integration fails as it runs out of authorization tokens

DescriptionZoho has recently changed the security model to use authorization tokens and a new version of the integration module (versions 0.1.7 and 0.1.8) has been published to use the new paradigm.

The new version initially works but very quickly starts failing with the error EXCEEDED_MAXIMUM_ALLOWED_AUTHTOKENS.

The issue is that authorization tokens are permanent and therefore limited. Each installation is supposed to acquire an authorization token upon the first usage and continue to reuse it.
Instead Openbravo requests an authorization token every time the integration module is run.

You can look at the documentation that clearly states that tokens are permanent: https://zohoreportsapi.wiki.zoho.com/Prerequisites.html [^]

If you have an integration which is schedule to run every 15 minutes, you will run out of authorization tokens very quickly.

In my case, I have the synchronization schedule to run every hour and I run out in 12 days.
Steps To ReproduceHere is an example of the error log you get:

2013-08-22 04:02:00.064 - Getting hql for csv importation
2013-08-22 04:02:00.082 - Generating csv file
2013-08-22 04:02:03.475 - CSV file stored in /opt/OpenbravoERP/zoho-imports/Cash Balance-20130822-040200.csv.zip
2013-08-22 04:02:03.475 - Importing to Zoho Reports
2013-08-22 04:02:03.475 - Getting zoho auth token
2013-08-22 04:02:03.603 - Error importing: EXCEEDED_MAXIMUM_ALLOWED_AUTHTOKENS
Proposed SolutionThe integration module should acquire an authorization token upon the first usage and store it for subsequent reuse.
A new token should be requested only if the previous token has expired.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0024413 closedcaristu EXCEED_MAXIMUM_ALLOWED_AUTHTOKENS error in Zoho Module 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2013-08-23 03:00 pjuvara New Issue
2013-08-23 03:00 pjuvara Assigned To => dmiguelez
2013-08-23 03:00 pjuvara Modules => Advanced Payables and Receivables Mngmt
2013-08-23 03:00 pjuvara Triggers an Emergency Pack => No
2013-08-23 12:13 dmitry_mezentsev Review Assigned To => dmitry_mezentsev
2013-08-23 12:13 dmitry_mezentsev Relationship added duplicate of 0024413
2013-08-23 12:13 dmitry_mezentsev Status new => closed
2013-08-23 12:13 dmitry_mezentsev Resolution open => duplicate

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker