When trying to navigate through catalog after importing catalog.zip I get YSOD with the message:
Could not find stored procedure 'mdpsp_avto_CatalogNode_Get'.
This results in dojo error 500 that gets stuck in 'opening' catalog node in the UI manager extension for CMS, although that worked till last Friday.
I was fiddeling with the catalog.zip content last week in order to get the full understanding how thing were working and every time I could navigate through the catalog structure.
Since YSOC I have also tried to upgrade nugets for epi commerce and did updata-epidatabase yet that procedure is still not present in the commerce DB. I susptect that even finding the body of procedure and scripting it into DB will just fix that issue and that the next one will emerge.
Should I run some nuget to restore this missing stored procedure?
It should not call to that stored procedure, as it should not even exist. I don't know what happened to your database, but I suspect it is in bad state.
One thing you can do is to run this
in SQL Server Management Studio to recreate all stored procedures used by MetaDataPlus. But that might not solve your problem if you have faulty metaclass/metafield definition.
Yes, I suspect that it's the later case.