When I proceed with upgrade from 4.8.3 to 5.2.3 I'm getting errors on all script executions and HTML module v5.2.0.

The error states: System.Data.SqlClient.SqlException: Cannot find the object 'ProcessByCompany', because it does not exist or you do not have permission.

And the same for the second object as well.

Those two object names I recognized from 4 years ago, but they shouldn't have been in the DB. When I run

select *
from sysobjects
where name like '%bycompany%'

on the SQL Server (the db was moved from Server v2000 to v2005 by restoring) I get those two objects listed, and xtype shows 'IF' which means In-lined table-function (I couldn't figure out what it is though).

Any idea how to remove those two objects? And why would they come up as an issue, they have nothing to do with DNN core, less with HTML module.

Thanks,

Val

Sebastian,

Thanks for pointing me the right direction. I didn't have any timeouts, but regardless, it took care of the errors I was experiencing.

The blog post by Cathal, addressing the workaround, is is found here.

Thank you,

Val