cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade SQL 2000 to SQL 2005 ---> schema conversion error

Former Member
0 Kudos

Hi, I execute an upgrade from MSSQL 2000 to MSSQL 2005 and everything executed succesfully. Then i download the "SAP Tools for MSSQL Server"

to execute the schema conversion of the database. But i get an error when a step tries to create the stored procedures in the db. Specifically i get the error in the sap_blocked_procccess store procedure with the following error:

ERROR 2006-12-07 10:19:57

FCO-00011 The step ExeProcs with step key |SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssProcs|ind|ind|ind|ind|4|0|ExeProcs was executed with status ERROR .

ERROR 2006-12-07 10:19:57

MDB-05053 Errors when executing sql command: <p nr="0"/> If this message is displayed as a warning - it can be ignored. If this is an error - call your SAP support.

INFO 2006-12-07 10:30:00

An error occured and the user decided to retry the current step: "|SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssProcs|ind|ind|ind|ind|4|0|ExeProcs".

ERROR 2006-12-07 10:30:29

FCO-00011 The step ExeProcs with step key |SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssProcs|ind|ind|ind|ind|4|0|ExeProcs was executed with status ERROR .

I didn't find any note or something else.

Do you have any idea about this problem?

Best Regards,

Thanasis

Accepted Solutions (1)

Accepted Solutions (1)

clas_hortien
Active Contributor
0 Kudos

Hi,

can you please send me the zipped sapinst_dev.log from the STM installation directory to

clas dot hortien at sap dot com.

Regards

Clas

clas_hortien
Active Contributor
0 Kudos

Hello,

please ensure that the Database compatibility level for all databases is 90 by

running

exec sp_dbcmptlevel 'master',90

exec sp_dbcmptlevel 'model',90

exec sp_dbcmptlevel 'msdb',90

exec sp_dbcmptlevel 'tempdb',90

exec sp_dbcmptlevel 'EA5',90

Then rerun the STM tools.

Regards

Clas

Former Member
0 Kudos

Hello guys,

I'm getting the same problem after attaching database from sql2000 SP3 A to SP4.

Is there a solution for me ?

Please advise,

Dimitry Haritonov

Former Member
0 Kudos

Can you check what authentication SQL server is using. We had this issue sometime back. By changing to Windows authentication, this issue was resolved.

Reward points if helpful!!!

Fahad

Former Member
0 Kudos

Hello Farad,

The problem is solved.

After putting SAPINST_MSS_LOG in the enviroment variable, I run the

DATABASE->COPY again and his time it rote that <sid> user is invalid

in 'model' database.

So I've created the <sid> user in model and the copy process finished.

Dimitry Haritonov

Former Member
0 Kudos

Hi, &#304; tried to Pruduction system copy into Test system. But when i was executing Sap Tools i recieved this error that discussed above on Create ;Sap stored procedures step. How can i solve this?.

Former Member
0 Kudos

hello abdullah,

did you try to add the env. variable and check the msslog.log file ?

Dimitry

Former Member
0 Kudos

hi dimitry

How can i add env. variable?. i have checked msslog but i couldn't see a noticable thing

Abdullah

note

ERROR 2007-01-16 11:49:18

FCO-00011 The step ExeProcs with step key |SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssProcs|ind|ind|ind|ind|4|0|ExeProcs was executed with status ERROR .

Former Member
0 Kudos

I had the same error when running SAP Tools MSSQL after attaching DB from PRD to QAS. The problem has been solved after I had stopped all services connected with SAP and SQL, and restarted Sapinst. Hope it helps generally..

Answers (0)