Symptom
During system copy the SWPM tool returns the following or similar error message:
ERROR 2016-10-04 18:00:03.679 (JADCOP\CTANJT) [csistepexecute.cpp:1106] id=controller.stepExecuted errno=FCO-00011
The step MoveSchema with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_MSS_DB|ind|ind|ind|ind|mss|0|MssSysCopy|ind|ind|ind|ind|mssSysCopy|0|MssSchemaMove|ind|ind|ind|ind|mssSchemaMove|0|MoveSchema was executed with status ERROR ( Last error reported by the step: Errors when executing sql command: [Microsoft][ODBC SQL Server Driver][SQL Server]Column "sid" is not allowed in this context, and the user-defined function or aggregate "sid.get_mssql_session_id" could not be found.
[Microsoft][ODBC SQL Server Driver][SQL Server]Column "sid" is not allowed in this context, and the user-defined function or aggregate "sid.get_mssql_session_id" could not be found.
[Microsoft][ODBC SQL Server Driver][SQL Server]Column "sid" is not allowed in this context, and the user-defined function or aggregate "sid.get_mssql_session_id" could not be found.
[Microsoft][ODBC SQL Server Driver][SQL Server]Column "sid" is not allowed in this context, and the user-defined function or aggregate "sid.get_mssql_session_id" could not be found.
<p> SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support. </p>).
Read more...
Environment
- SAP NetWeaver 7.0 Application Server for ABAP or Higher
- SQL Server 2005 or higher
Product
SAP enhancement package 2 for SAP NetWeaver 7.0
Keywords
KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview