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
CA API Gateway 10.x , OTK 4.6
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:
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.
After upgrading the OTK db the errors in question are no longer observed within the gateway ssg logs.