So, I’ve tried to update the data collection stack, still KO, i’ve tried to remove the support cases and healths events modules and then re install them, still KO. I have this issue with only two dashboards, the other one are working fine. And i also confirm that the table “health_events_detail_data” or the “support_cases_data” are not existing into the Athena database “optimization_data”. The stepfunctions related to theses modules are working fine. But each time i’m trying to deploy the health events or support cases dashboard (with cli or through the cloud formation template) i’m facing the same issue.
“{‘type’: ‘athena’, ‘query’: “SELECT DISTINCT table_schema FROM information_schema.columns WHERE table_name = ‘health_events_detail_data’”, ‘error’: ‘This means that prerequisites for the dashboard are not found. Please make sure you have the needed table: Data Collection installed, needed module is configured and Step Function runs correctly.’, ‘default’: ‘optimization_data’, ‘description’: ‘Enter the name of the data collection database’, ‘global’: True}}”
As you’re only encountering this issue with a select few dashboards but have gotten to work on others, I wonder if this may be in result to a bug as opposed to something you’re doing in the process.
I would suggest creating a support ticket to get more direct assistance relating to your account and setup:
Just checking back in since we haven’t heard from you in a bit. Were you able to see Brett’s reply and/or find a solution yourself in the meantime? If you still have any additional questions related to your initial post, please feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
Hello, yes i just got a reply yesterday from the CID Team. I’ve checked the related lambda to this stack so that one => CID-DC-health-events-Lambda and in checking the logs, i’ve found this => “Error: An error occurred (SubscriptionRequiredException) when calling the DescribeEventsForOrganization operation:”
I understood that it doesn’t work because we’ve suscribed to a developper support plan on our accounts so we don’t reach the requirements to use this dashboard (and the same for the support cases one)