I couldn't find any where in the portalSettings or HostSettings table which has Null or text instead of a number.

I'm including the data of portalSettings or HostSettings table, so you can take a look at the table values and if you find the issue.

Portal Settings Table:

Host Settings Table values:

I don't think it is settings.

In the original exception it reports...

RawURL: /?ctl=profile&userId=&pageno=3

In the code for SecurityRoles.asc.cs the userId is parsed out of the QueryString. This QueryString has no value for userId. The current code (7.4.0) has a check to handle that, but the OP is running an older version. I don't fully know what the code looked like then. I do know that there was a commit last August that looks like it better checks the userId before using it.

Fixes: - Identify who is accessing the site with this invalid QueryString and stop them. Or upgrade to a version that has last August's fix in it.

---

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk