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

2 years ago
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)
....
2 years ago
On line 3433 is a CREATE PROCEDURE [temp_generate_sename]
check to see if it also has errors
2 years ago
New York wrote:
On line 3433 is a CREATE PROCEDURE [temp_generate_sename]
check to see if it also has errors


is it a problem?
2 years ago
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.
1 year ago
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.
2 months ago
any solution or reason for this? I ended up with this exact issue.
2 months ago
are your existing database objects that you are planning to upgrade created under the schema .dbo?  or something else?

mr.mourya wrote:
any solution or reason for this? I ended up with this exact issue.