Broadcom API Gateway - Unable to load search result from external IDP. Policy Manager returns "The system reported an error during search"

Products

• CA API Gateway

Issue/Introduction

While querying an external IDP, after hitting the Search button, Policy Manager returns the following error:

Environment

Release : CA API Gateway 10.1+

Cause

As part of the troubleshooting, we can generate more information by using the Report button. In this specific case, the log shows an issue in retrieving the search results:

org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a];  SQL state [HY000]; error code [1021]; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException:  could not extract ResultSet

Further analysis, leaded to a disk space issue. The "tmp" partition where IDP's search results are temporarily stored is 100% full.

Caused by: java.sql.SQLException: Disk full (/var/tmp/#sql_a87_3); waiting for someone to free some space... 
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) 
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)

Resolution

Delete unnecessary files from the target tmp folder/partition