SAP Knowledge Base Article - Preview

2020689 - SWPM error: "FASTFIRSTROW" is not a recognized table hints option on MS SQL Server 2012

Symptom

  • When installing target system on Windows Server 2012 with MS SQL Server 2012 using System copy option of SWPM Tool (SAP Note 1680045) inc. WIN OS -and DB-Upgarde, the following error occurs:

5-22-2014 1-20-54 PM.jpg

An error occurred while processing option SAP NetWeaver 7.0 including Enhancement Package 1
Support Release 1 > Software Life-Cycle Options > System Copy > MS SQL Server > Taret
System Installation > Central System > Based on AS ABAP > Central System(Last error reported
by the step: Errors when executing sql command: [Microsoft][ODBC SQL Server Driver][SQL
Server]"FASTFIRSTROW" is not a recognized table hints option. If it is intended as a parameter to
a table-valued function or to the CHANGETABLE function, ensure that your database compatibility
mode is set to 90. [Microsoft][ODBC SQL Server][SQL Server]Incorrect syntax near the
keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a
change tracking context clause, the previous statement must be terminated with a 
semicolon.
Solution: If this message is displayed as a warning, you can ignore it. If this is an error, contact
SAP support.
). You can now:
      - Choose Retry to repeat the current step.
      - Choose Log Files to get more information about the error.
      - Stop the option and continue with it later.

Log files are written to <Drive>:\Program
<Directory>
  • In sapinst_dev.log, the following trace and error can be seen:
TRACE      
MSSTRC: Checking for fixes: sap_check_if_sick on SQL11 with CVERS == 700.0015
TRACE      
t_MssMessages.remove(WHERE 1=1)
ERROR      2014-05-21 13:44:45.024 [iaxmcsql.cpp:116]
           iastring CIaMssSqlConnect::executeSQL(args_t const& _args)
MDB-05053  Errors when executing sql command: [Microsoft][ODBC SQL Server Driver][SQL Server]"FASTFIRSTROW" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. 


Read more...

Environment

  • All SAP systems based on SAP NetWeaver 7.0# and higher, which are supported on Windows Server 2012/MS SQL Server 2012 according the "Product Availability Matrix" (PAM)
  • Software Provisioning Manager (SWPM)

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

Software Provisioning Manager, SWPM, MSSQL , KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.