4.10_UpgradeScripts Could not find stored procedure 'dbo.temp_generate_sename'.

Hello
4.10 UpgradeScripts

......
(1 row affected)

(1 row affected)
Msg 2812, Level 16, State 62, Line 3547
Could not find stored procedure 'dbo.temp_generate_sename'.
Msg 515, Level 16, State 2, Line 3560
Cannot insert the value NULL into column 'Slug', table 'dbname.dbo.UrlRecord'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2812, Level 16, State 62, Line 3576
Could not find stored procedure 'dbo.temp_generate_sename'.

(1 row affected)

(1 row affected)
....

On line 3433 is a CREATE PROCEDURE [temp_generate_sename]
check to see if it also has errors

New York wrote:

is it a problem?

It's only a problem if you see errors after it tries to create the stored procedure.  If it fails to create the procedure, then any attempt to execute it later will fail.

Hi

Guys I have same issue when i upgrade from 4.0 to 4.1 please help to solve

it giving following 2 errors

Could not find stored procedure 'dbo.temp_generate_sename'.


Cannot insert the value NULL into column 'Slug', table 'DB_xxxx.dbo.UrlRecord'; column does not allow nulls. INSERT fails.

any solution or reason for this? I ended up with this exact issue.

are your existing database objects that you are planning to upgrade created under the schema .dbo?  or something else?

mr.mourya wrote:

I had the same issue.

just removing [dbo]. before the SP name fixed the issue for me. Hope helps someone else.