[Bug]: Fatal Error coping a report

[edersong]

Verified issue does not already exist?

• I have searched and found no existing issue

Is this related to GoCardless, Simplefin or another bank-sync provider?

• I have checked my server logs and could not see any errors there
• I will be attaching my server logs to this issue
• I will be attaching my client-side (browser) logs to this issue
• I understand that this issue will be automatically closed if insufficient information is provided

What happened?

When coping a report changing date range from last month to this month, Actual Server crashed with the following error:

By clicking at Restart app didn't solve.

What error did you receive?

By clicking at the show error button, it reports the following:

RangeError: Invalid time value at ke
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:114:99862) at sf 
 (https://actual.whatever.com/static/js/ReportRouter.mLx3JUh2.chunk.js:65:32413) at Kx  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:56:19539) at gI  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:58:44045) at fI  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:58:39777) at Q4  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:58:39705) at Mh  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:58:39557) at L0  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:58:35921) at uI  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:58:34870) at E  
 (https://actual.whatever.com/static/js/index.MAk9r4yg.js:43:1552)  

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome

Operating System

Linux

[Sal-Romano]

Same issue with the same install/environment parameters listed above. I'm unable to get into the reports tab without it crashing and the last action taken was duplicating a custom report.

[carkom]

Do either of you have reports with "static" dates you've created in the last 2 weeks? If so, delete those reports and remake them after this fix has been merged. #2556

[edersong]

Yes, I had static date reports from three last months and when I copied last month to create a new one for the current month, it crashed

[Sal-Romano]

I can confirm that the issue occurs when you set the Date Filter to "Static", click "Update report" in the top right, and then refresh the /reports endpoint.

I was able to unbrick my custom reports tab by manually modifying the database. I changed each record in the custom_reports table to have a 0 value in the "date_static" column.

[carkom]

Anyone else with this issue can go to /reports/custom and choose the offending graph and delete it. No need to edit the db.

[carkom]

Fixed by #2556

[edersong]

Why it was closed?
I'm not able to go to Reports section since it's crashing when entering, as explained before.
No way to delete report created.

[carkom]

Why it was closed?
I'm not able to go to Reports section since it's crashing when entering, as explained before.
No way to delete report created.

Don't click the reports link in the sidebar. Type "/reports/custom" on the end of your actual address to access the graphs and delete the offending reports.

Its closed because it's not something we can change from the code. You have a saved report with a bug in it. It's a localized issue.

If that doesn't work then you have to manipulate the sqlite db file (as explained above).

[edersong]

Thank you!!