User get 500 error when create a new project

[koonchaya]

Original post: https://rfcx.slack.com/archives/C03FD1WD02J/p1714588923511519 @carlybatist

User cannot create a new project and got error 500.

When I try to set up a new project I am getting the error "Failed! Request failed with status code 500" I have attached a screenshot as well of what I have actually added to the project in case I have made any mistakes. I also tried with giving the project an end date and I got the same issue.

[koonchaya]

Additional detail from Art investigation It is missing project id from core after the project created.

[grindarius]

I dug up the logs using this expression to find integration/projects route by querying in Loki like this {pod =~ "arbimon-.+"} |= "integration/projects" which find all pods that starts with arbimon- and contains string integration/projects.

I found this log part

This indicates that the failure comes from legacy. After some digging of the logs I found that the error log is

Which errors from this line of code https://github.com/rfcx/arbimon-legacy/blob/26760f885c5d0ef654479dac72e934cac9c7aafb/app/model/users.js#L611

It turned out there could be some differences between user's email and the token. The user issues the request with email louisa.mamalis@york.ac.uk which is tied to auth0 user id google-oauth2|105159195017878662308. This is valid. You can check it on jwt.io. There are 3 bearer tokens that this user have used to try to create the project. I listed one here because they all have the same value, just a bit difference in time.

eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IlF6UTROakpHTkRVd01UTTJSVGREUmpRMVFqazROa001UVVFMU1URTJSREl5T1VJME9VRkVOQSJ9.eyJhdXRoMF91c2VyX2lkIjoiZ29vZ2xlLW9hdXRoMnwxMDUxNTkxOTUwMTc4Nzg2NjIzMDgiLCJodHRwczovL3JmY3gub3JnL2FwcF9tZXRhZGF0YSI6eyJhdXRob3JpemF0aW9uIjp7InJvbGVzIjpbImFwcFVzZXIiXX0sImd1aWQiOiI2N2RlN2YzMC1iMzc5LTRmMWEtYjdkYS02YmY1ZmNjZDJmMDciLCJsb2dpbnNOdW1iZXIiOjV9LCJndWlkIjoiNjdkZTdmMzAtYjM3OS00ZjFhLWI3ZGEtNmJmNWZjY2QyZjA3IiwibG9naW5zTnVtYmVyIjo1LCJnaXZlbl9uYW1lIjoiTG91IiwiZmFtaWx5X25hbWUiOiJNYW1hbGlzIiwibmlja25hbWUiOiJsb3Vpc2EubWFtYWxpcyIsIm5hbWUiOiJMb3UgTWFtYWxpcyIsInBpY3R1cmUiOiJodHRwczovL2xoMy5nb29nbGV1c2VyY29udGVudC5jb20vYS9BQ2c4b2NLd2YyLXZSMGx2VTk1RkxiRFoxMUo0bzRwTk5TbG1CNWg3aVR2QmlHZFNiazJDUzFndXpBPXM5Ni1jIiwibG9jYWxlIjoiZW4tR0IiLCJ1cGRhdGVkX2F0IjoiMjAyNC0wNS0wMVQxNjoxMzowMy41ODZaIiwiZW1haWwiOiJsb3Vpc2EubWFtYWxpc0B5b3JrLmFjLnVrIiwiZW1haWxfdmVyaWZpZWQiOnRydWUsImlzcyI6Imh0dHBzOi8vYXV0aC5yZmN4Lm9yZy8iLCJhdWQiOiJMaW9qZHZOVXNlckduQ2FMajhja2N4ZUdQSE9LaXRPYyIsImlhdCI6MTcxNDU3OTk4NiwiZXhwIjoxNzE3MTcxOTg2LCJzdWIiOiJnb29nbGUtb2F1dGgyfDEwNTE1OTE5NTAxNzg3ODY2MjMwOCIsImF1dGhfdGltZSI6MTcxNDU3OTk4Mywic2lkIjoiXzVyRVhwckdhRFV3RkZrOTBmNDdwVmlUWHJaUFNtSHEiLCJub25jZSI6IlRFRXdRMk5LWlM1TVVVOWFlVVV1UmpSSFZqQkRWemd5WlhSdU5IWnhZbGs1VEVkV1EybFlXSFpXUmc9PSJ9.LZwLc2AKEqrNatO1uHidlsNq8Cy__gsn7_0iq9SOY-_M6eGPXdieHa-4Hh5NZOVCbsQUDLnR9_lneSKKhnxGckaZtvtpZPe-geoSl13IdE6-ZxTsnOYkUTfBxSb5yxz5MbF3Uwifg7GKyPFwt9DGTgrjJGwSl9P0OKJhT6xzzPqDFFAm2ZzX6BvvrGzVJ70gZi9YSthWkZqU1GkUzvJfaCf3F0BkAe2OQUtidFajMtdmcC25qp8Hsta24xejK4HQPLc1ooHZUoGzriAFwIA9BJqkIdBWIDILnYDXfVHpAUxUAFiqAgaaH8BkeAmeP5woePhSSwmLUTKmzZn_G10MiA

The email that's associated with the account is louisa.mamalis@york.ac.uk with auth0 id of google-oauth2|105159195017878662308. But on legacy, the addressed auth0 id is already tied to the user with email lcm566@york.ac.uk. I've looked over all 3 databases and found that only insights (arbimon) have both users listed.

data/db	insights	legacy	core
louisa.mamalis@york.ac.uk	✅	❌	❌
lcm566@york.ac.uk	✅	✅	✅

The auth0 id google-oauth2|105159195017878662308 is tied to email lcm566@york.ac.uk and exists on all 3 databases. That causes the error because the data listed inside the json key is not valid when compared to the user tables.

I think a fix is to find source of truth somewhere and change all places to be the same as that one.

[grindarius]

I think it could be related to this https://en.wikipedia.org/wiki/Email_alias

[antonyharfield]

I've merged the two users louisa.mamalis@york.ac.uk and lcm566@york.ac.uk. Her user account is now louisa.mamalis@york.ac.uk. Please tell her to logout and login again with this user and try creating a project.