App: [Internal:292669] Users LHN not loading after sign-in

If you haven’t already, check out our contributing guidelines for onboarding and email contributors@expensify.com to request to join our Slack channel!

Action Performed:

Download the NewDot app
Sign in as jules@expensify.com or sonia@expensify.com

Expected Result:

User is able to sign - in

Actual Result:

For certain users, the app won’t load after sign-in

Workaround:

Unknown

Platforms:

Which of our officially supported platforms is this issue occurring on?

Android / native
Android / Chrome
iOS / native
iOS / Safari
MacOS / Chrome / Safari
MacOS / Desktop

Version Number: 1.3.45.2 Reproducible in staging?: y Reproducible in production?: y If this was caught during regression testing, add the test name, ID and link from TestRail: Email or phone of affected tester (no customers): Logs: https://stackoverflow.com/c/expensify/questions/4856 Notes/Photos/Videos: Any additional supporting documentation

IMG_9585 (1)

Expensify/Expensify Issue URL: Issue reported by: @mallenexpensify Slack conversation: https://expensify.slack.com/archives/C049HHMV9SM/p1690204559608079

View all open jobs on GitHub

Upwork Automation - Do Not Edit

Upwork Job URL: https://www.upwork.com/jobs/~01b851a413dd654c19
Upwork Job ID: 1686302515143319552
Last Price Increase: 2023-08-01

About this issue

Original URL
State: closed
Created a year ago
Comments: 48 (42 by maintainers)

Most upvoted comments

Next Auth deploy will contain a Log that should help us to track down the troublesome reportID for me and Sonia. Then we can take a close look at the report data

Julesssss on Aug 1, 2023

God damn it.

Julesssss on Aug 1, 2023

Good point. Let’s leave both open then, as the app issue prevents more dupes from being reported.

Julesssss on Aug 1, 2023

flo@db1.lax:~$ sudo readdb.sh  "select * from reports where reportID IN ('28501663496784', '1591164149233781', '1740055458673635');"
created              submitted  approved  reportID          accountID  managerID  reportName   state  total  currency  cachedData                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  status
-------------------  ---------  --------  ----------------  ---------  ---------  -----------  -----  -----  --------  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  ------
2023-06-21 11:08:15                       28501663496784    0                     Chat Report  0      0      USD       {"submitted":"","submittedTo":"","approved":"","unapproved":"","reimbursed":"","shared":"","type":"chat","retracted":"","expensify_policyID":"F8B4A7879EDA483B","policyLastModified":1681915927035045,"isSmartReport":false,"cacheComputedBy":8572718,"inbox":{"violations":[],"policyType":"personal","firstSubmittedDate":"","wasComputedInReportCache":true},"reimburserEmail":"__fake__","queuedForAutoExport":{"queued":false,"connections":[],"exportFailed":false,"failedConnections":[]},"hasBeenExportedToIntegration":false,"wasReimbursedViaACH":false,"statementCardID":null,"statementBank":null,"statementPeriodEndDay":null,"isWaitingOnBankAccount":false,"isABAReimbursed":false,"expectedReimbursementDate":null,"canMarkReimbursementReceived":true,"hasReimbursableTotal":false,"hasTransactions":false,"hasBillableTransactions":false,"reportOwners":[],"managerOnVacation":"","isSmartReportOnFile":false,"invoiceID":0,"billID":0}  0     
2023-05-18 19:42:35                       1591164149233781  0                     Chat Report  0      0      USD       {"submitted":"","submittedTo":"","approved":"","unapproved":"","reimbursed":"","shared":"","type":"chat","retracted":"","expensify_policyID":"F38EA6C07CC57AC2","policyLastModified":1689843167331370,"isSmartReport":false,"cacheComputedBy":3472167,"inbox":{"violations":[],"policyType":"personal","firstSubmittedDate":"","wasComputedInReportCache":true},"reimburserEmail":"__fake__","queuedForAutoExport":{"queued":false,"connections":[],"exportFailed":false,"failedConnections":[]},"hasBeenExportedToIntegration":false,"wasReimbursedViaACH":false,"statementCardID":null,"statementBank":null,"statementPeriodEndDay":null,"isWaitingOnBankAccount":false,"isABAReimbursed":false,"expectedReimbursementDate":null,"canMarkReimbursementReceived":true,"hasReimbursableTotal":false,"hasTransactions":false,"hasBillableTransactions":false,"reportOwners":[],"managerOnVacation":"","isSmartReportOnFile":false,"invoiceID":0,"billID":0}  0     
2023-08-02 10:31:03                       1740055458673635  0                     Chat Report  0      0      USD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   0     
flo@db1.lax:~$

flodnv on Aug 2, 2023

You can’t close a BugBot, it will get reopened as long as it happens 😄

flodnv on Aug 1, 2023

The vid is the same as the screenshot, with the chats blank and loading. Going to chat with @danieldoglas tomorrow to see if we can debug in person. I’ve un/reinstalled many times with the same bug. My only thought is that I deleted an IOU report in Classic and that might have ‘set things off’, when I log into www.expensify.com now I get an error each time (GH for that somewhere)

https://github.com/Expensify/App/assets/22508304/6d1fc268-1102-41bb-87e8-6400093fb443

Removed you as BZ Sophie since nobody besides me is dealing with this issue so it’s makes sense (to me, at least) to be BZ

mallenexpensify on Aug 1, 2023