Hybrid Integration 10.2 | Integrating On-Premises Applications | Integration Server Built-In Services | OAuth Folder | pub.oauth:removeExpiredAccessToken
 
pub.oauth:removeExpiredAccessToken
WmPublic. Removes expired OAuth access tokens from the database.
Input Parameters
maxRows
String Optional. Maximum number of rows containing expired tokens to be deleted from the database, where each row contains a single expired access token. If you specify 0 or do not specify a value, the service removes all of the rows containing expired tokens from the database.
The maxRows parameter applies to Oracle or DB2 databases only. The maxRows parameter is ignored for all other database types, such as MySQL, SQL Server, or Derby. Instead, the service deletes all of the rows containing expired tokens.
Output Parameters
None.
Usage Notes
To improve the performance of the pub.oauth:removeExpiredAccessTokens service, create the following two database indexes:
*Create index idx_oauth_tmp_idx on IS_OAUTH_ACCESSTOKEN(TOKEN_ID);
*Create index idx_oauth_tmp_idx2 on IS_OAUTH_REFRESHTOKEN(TOKEN_ID);

Copyright © 2015- 2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release