Prepare error in phase : SHDINST_DB_PREP

[Former Member]

Hi, in the phase SHDINST_DB_PREP I've an error. In the log file

MSSSHDCRE.LOG I've :

Creating Login dbo_shd

New login created.

Granted database access to 'dbo_shd'.

'dbo_shd' added to role 'db_owner'.

Granted database access to 'dbo_shd'.

'dbo_shd' added to role 'db_ddladmin'.

Msg 208, Level 16, State 11, Server SAPTEST\UVD, Line 2

Invalid object name 'dbo.sap_upg_getrelease'.

Execution completed successfully

I've tru to execute manually :

osql -S saptest\UVD -E -d UVD -i E:\usr\sap\put\bin\MSSSHDCRE.SQL

but the error is the same.

[Former Member]

Hi Francesc,

Were you able to solve this problem? I'm having it too at the moment and was wondering if you had solution.

Thanks,

Martin

[Former Member]

That's the answer by SAP :

Please could you delete store procedure sap_upg_getrelease and run the

script mssupgsps.sql again. This time use "setuser 'uvd'" at the very

beginning of it.

Regards

Francesc

[Former Member]

Thanks Francesc!

The problem was not that the user was incorrect, but that the stored procedure was not created at all. Running the script mssupgsps again created the sp and I was able to continue.

Kind regards,

Martin