TypeError: e is null

[Sophie Vos]

Hi everyone,

I am a master's student Computer Science and am currently writing my thesis about energy efficiency in the public cloud. I would like to run an experiment using the CCF tool, but I did not manage to couple it to my AWS account.

Running the code with mocked data works for me. And running yarn start does not give an error in the terminal but provides the ambiguous error "TypeError: e is null" on the local host. Attached are some screenshots.

Thank you for the tool and hopefully someone has some experience with this error because I am a bit stuck... :)

Best,

Sophie

[Sophie Vos]

could it be because some data is missing in my billing table?

[Cloud Carbon Footprint]

Hi Sophie, 

Thanks for messaging about this! 

Just to confirm, you are seeing this data when you attempt to run with your AWS account information entered in the .env file in the api package? And running `yarn start` from the root?

Which browser are you attempting this with?

Could you please also confirm that you are entering the following variables?:
AWS_ATHENA_DB_NAME
AWS_ATHENA_DB_TABLE
AWS_ATHENA_REGION
AWS_ATHENA_QUERY_RESULT_LOCATION
AWS_BILLING_ACCOUNT_ID
AWS_BILLING_ACCOUNT_NAME
AWS_USE_BILLING_DATA=true
AWS_AUTH_MODE=default

Thanks,

Cam

[Sophie Vos]

Thanks for replying.

Yes, whenever I run yarn start-with-mock-data everything works.

I followed the steps on https://www.cloudcarbonfootprint.org/docs/aws to connect CCF to my AWS account.

Indeed I altered the variables in the packages/api/.env file and ran yarn start afterward.

The browser I use is Firefox but I do not think that is the issue as the mocked data works in Firefox.

Moreover, CCF links correctly to Athena as I received an error message earlier that the column product_vcpu was not present in my database.

After I added this column manually in Athena this error went away and I received the error that I forwarded in my question.

So I do think my billing/usage data is in the wrong format somehow but unsure how I can solve this.

In my AWS account, I only have S3 instances and no compute instances so maybe that could cause a problem?

And I have quite some empty columns in the billing table.

Thanks a lot.

Best,

Sophie

--
You received this message because you are subscribed to the Google Groups "Cloud Carbon Footprint" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cloud-carbon-foot...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cloud-carbon-footprint/ba5b6213-898c-470f-b934-85806cff3096n%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Wojtek Kubiak]

I have similar issue and waiting for response.

Athena DB was created using default CF stack createdy by AWS in my S3 output bucket

Data are present in S3 and Athena can browse them without problem

When trying to launch an application I got: "Column 'product_vcpu' cannot be resolved."

BR

/Wojtek

[Arelys Alvarez]

Hi Wojtek, 

Thank you so much for reaching out and bringing this issue to our attention. We were in conversations with Sophie and I think she was able to solve the issue herself, maybe she could help you with this. 

@sophie.o...@gmail.com could you please provide instructions on how to manually add that column to the database?

Thank you, 

Arelys

On Oct 30, 2021, at 4:33 AM, Wojtek Kubiak <wtku...@gmail.com> wrote:

I have similar issue and waiting for response.

Athena DB was created using default CF stack createdy by AWS in my S3 output bucket

Data are present in S3 and Athena can browse them without problem

When trying to launch an application I got: "Column 'product_vcpu' cannot be resolved."

BR

/Wojtek

środa, 23 czerwca 2021 o 10:44:04 UTC+2 sophie.o...@gmail.com napisał(a):

Thanks for replying.

Yes, whenever I run yarn start-with-mock-data everything works.

I followed the steps on https://www.cloudcarbonfootprint.org/docs/aws to connect CCF to my AWS account.

Indeed I altered the variables in the packages/api/.env file and ran yarn start afterward. 

The browser I use is Firefox but I do not think that is the issue as the mocked data works in Firefox.

Moreover, CCF links correctly to Athena as I received an error message earlier that the columnproduct_vcpu was not present in my database.

To view this discussion on the web visit https://groups.google.com/d/msgid/cloud-carbon-footprint/8cb4bb68-9d16-4009-965a-2099de4a596cn%40googlegroups.com.

[Wojtek Kubiak]

hi

I managed to solve it.

The best option was to launch small ec2 just before starting the CUR. Than AWS produce correct CloudFormation stack and column vcpu exists.

BR
Wojtek