TABLE OR VIEW DOES NOT EXIST

Products

• CA API Gateway
• CA API Gateway

Issue/Introduction

We are seeing the following error within our gateway ssg log and would like to know the root cause:

com.l7tech.server.jdbc.JdbcQueryingManagerImpl: Failed to perform querying since ORA-00942: table or view does not exist

Environment

CA API Gateway 10.x , OTK 4.6

Cause

It was determined that OTK had just been upgraded within this particular environment to 4.6.

Upon looking at the otk database we could see that the following tables were missing:

oauth_device_initiate
oauth_token_revocation_list

 

 

Resolution

We needed to follow all of the required steps to complete the OTK upgrade which includes upgrading the OTK database by executing the required database scripts as outlined within our documentation.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-management-oauth-toolkit/4-6/upgrade-the-otk.html

 

After upgrading the OTK db the errors in question are no longer observed within the gateway ssg logs.