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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0024567

Openbravo ERP

09. Financial management

public

2013-08-23 03:00

2013-08-23 12:13

Reporter

pjuvara

Assigned To

dmiguelez

Priority

normal

Severity

critical

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

3.0MP24.2

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

dmitry_mezentsev

OBNetwork customer

Web browser

Modules

Advanced Payables and Receivables Mngmt

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

Zoho 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 Reproduce

Here 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 Solution

The 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.

Additional Information