The "object reference" is a very generic error. Are you on DXP? Can you check Application Insight and check failed request and see telemetry. it will give you a hint of what the website is trying to get from the database.
if you are not on DXP then you can use Sql profiler.
Hi,
I'm investigating an error, that happens when he try to load a page with product data. A database rollback previously solved the issue, but now it's back.
And the exception:
Any help is appreciated :)