TAO Dashboard deployment failed (table `ta_organizational_view_reports` doesn't exist)

0

I'm trying to create a TAO Dashboard following the steps in TAO DASHBOARD DEPLOYMENT - Option 3: CloudFormation Deployment.

I'm executing the CloudFormation template from Terraform, and I get the following error:

"The following resource(s) failed to create: [taoQuickSightDataSet]. Rollback requested by user." 
"Resource handler returned message: \"SYNTAX_ERROR: line 3:6: Table awsdatacatalog.athenacurcfn_billing_cur_report_definition.ta_organizational_view_reports does not exist [Execution ID:..."

The DB athenacurcfn_billing_cur_report_definition already exists (it was created some time ago, during the deployment of CID & CUDOS dashboards).

The table ta_organizational_view_reports does not exist. However, in the lab instructions it's stated:

6. Update your Athena Database Name with the name of the CUR Athena Database where you want to deploy table for TA reports. Leave default if you are not sure which database name provide

I understand the table will be created by the CloudFormation template (tao.cfn.yml).

Is my understanding wrong?

2 個答案
2

Hello,

Currently the TA Orginizational view is only supported in the Manual report generation method, as mentioned in the previous step for Create and uploading the Trusted Advisor Report under the " Trusted Advisor Organizational View" dropdown

Please attempt to re-deploy your TA Orginizational report by using the manual deployment method.

AWS
支援工程師
已回答 2 年前
AWS
專家
已審閱 2 年前
1
已接受的答案

Problem turned out to be in the template itself. I've been using the template found in:
https://aws-well-architected-labs.s3.us-west-2.amazonaws.com/Cost/Labs/200-cloud-intelligence-dashboards/tao.cfn.yml
As indicated in lab:
https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/trusted-advisor-dashboards/dashboards/3_deployment/#option-3-cloudformation-deployment

Later I used the template located in GitHub repository:
https://github.com/aws-samples/aws-cudos-framework-deployment/ Specifically, the release 0.2.3.

This template is exactly the same than the other one, but it changes the table name:
Old: Name: ta_organizational_view_reports.
New: Name: !Join [ '' , [ !FindInMap [ "Definitions", "taoAthenaTable", "Value" ] , !Ref taoSuffix ] ].

With this template, TAO dashboard was deployed successfully.

profile picture
Omar
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南