script error upgrading from 4.0 to 4.1 - Query completed with errors

Hi

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

it is 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.

Hello any help appreciated

Was there another error?  Because the script creates that temp sp on line 3451:

--update [sename] column for product tags
IF EXISTS (
        SELECT *
        FROM sysobjects
        WHERE id = OBJECT_ID(N'[temp_generate_sename]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
DROP PROCEDURE [temp_generate_sename]
GO
CREATE PROCEDURE [temp_generate_sename]
...


(What tool are you using to run the script?)

This error: Could not find stored procedure 'dbo.temp_generate_sename'. occurs for some people because the procedure is not necessarily created using the default schema.

This code in the upgrade.sql:

CREATE PROCEDURE [temp_generate_sename]

Should be:

CREATE PROCEDURE [dbo].[temp_generate_sename]

From this line onwards the procedure is referance as

[dbo].[temp_generate_sename]

In my case the procedure was generated under a local user schema because of my sql setup.