Symptoms
I'm trying to contact APS controller to get resources from endpoint but I'm getting this error:
{
"code": 500,
"type": "APS::Util::Exception",
"message": "Statement that is supposed to always return result return empty resultset. ' SELECT app_instance_id FROM aps_application_instances WHERE uuid = ?'"
}
Cause
Certificate that is used for authentication belongs to an instance of application that was already removed from POA.
Resolution
Create a new application instance, APS controller will send the new certificate in headers (if you are using APS PHP runtime it will be placed for you in config
folder)