While querying an external IDP, after hitting the Search button, Policy Manager returns the following error:
Release : CA API Gateway 10.1+
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)
Delete unnecessary files from the target tmp folder/partition