Error message 'Statement that is supposed to always return result return empty resultset' when contacting APS controller from endpoint.
Modified on: Fri, 17 Nov 2023 12:07 PMOriginal Publishing Date:
2020-01-22
2020-01-22
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)