C4W4 CapStone2: "ErrorMessage": "AnalysisException: Insufficient Lake Formation permission(s) on de_c4w4a2_silver_db (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: 5064fe94-f23e-4f65-84d1-677b694925a7; Proxy: null)",

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
22

Hello @eadgc5,

Just to make sure, are you still geting the same message for de_c4w4a2_silver_db because of that error message, if it was fixed you should have been notified from the Lab Issue Report before.

If you get reconnecting message in step 2.3 is not something that the form can fix, it happened in other labs and there are workarounds. Afterwards there will be existing resources you can delete them manually or try the following:

  1. Wait for a new lab session and try the same commands:
    use instead of terraform apply:
terraform apply -target=module.extract_job -no-color 2> errors.txt
terraform apply -target=module.transform_job -no-color 2> errors.txt
terraform apply -target=module.serving -no-color 2> errors.txt

  1. If it continues ask for a lab refresh since it clears those resources 100% but if it disconnects again and the lab reboots they will appear again.

  2. I suggest following those instructions to refresh your workspace and hopefully those apply commands will finish with apply complete. Hope it helps

23

same issue. Please help fix

24

Hello @Mubsi,

It seems @eadgc5 had his lab refreshed and still getting the same error (Insufficient Lake Formation). Could you please check his lab since he submitted the form and waits for a notification. Thanks

1 Like
25

Hi @eadgc5,

I don’t see anything submitted by you in the form currently. Can you please fill the form ? I shall take a look.

Thanks,
Must

26

Submitted
But today I cant seem to get this running either
source scripts/setup.sh

An error occurred (InvalidClientTokenId) when calling the DescribeDBInstances operation: The security token included in the request is invalid.

Indicated so on the form.

Please let me know if you need anything else.

27

Hi @eadgc5,

I have refreshed your account. You had exceeded your budget.

Please try again now (and you can ignore the notification about this which you’ll recieve later).

Thanks,
Mubsi

28

terraform apply for module.serving → Stuck in Reconnect Now.

I have spent 3+ weeks trying to resolve this and is standing in the way of me completing my certification

29

image
image790×487 20.4 KB

30

Opened ticket for the 3rd time. Still getting “Reconnect Now” error.
terraform apply -target=module.transform_job -no-color 2>> errors_tranform.txt;
Please check my prev tickets.

CAN YOU PLEASE GIVE ME MY CERTIFICATE BASED ON ALL THE OTHER LABS SUBMITTED SO FAR??? I CANT WASTE MORE TIME.