SAP Knowledge Base Article - Preview

2748805 - Database error 102 Incorrect syntax near ','.

Symptom

  • In SystemLog (transaction sm21):

            APPLSERVER DIA 001 100 MRS @5C\Qvery high priority@ BY2 Database error 102 at OPC
            APPLSERVER DIA 001 100 MRS @SR\Qinformation@ BY0 > Incorrect syntax near ','.

  • In work process trace file (dev_w<nr>):

           B Connect to TESTCONNECTION as SID_SAPMonitor with OBJECT_SOURCE=SAPMonitor MSSQL_DBNAME=SID MSSQL_SERVER=SQLSERVER
           C Thread ID:0000
           C ODBC Driver chosen: SQL Server non-native
           C Server Version: 13.00.4446.00
           C DB release numbers: (13,0,44446,0)
           C EditionID: 1872460670 EngineEdition: 3
           C comm. rd. spid 100
           C unc. rd. spid 101
           B Connection 2 opened (DBSL handle 1)
           C ERROR: -1 in function StartSelect (execute) [line 16595]
           C (102) [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','.
           C Error 99 (dbcode 102) in StartSelect
           C StartSelect: stmt of NULL_STMTID
           C =======================================================================#


Read more...

Environment

  • SAP NetWeaver system on SQL Server Database
  • Remote connection to SQL Server Database from SAP Solution Manager

Product

SAP NetWeaver all versions ; SAP Solution Manager all versions

Keywords

database, error, 102, incorrect , syntax, odbc , driver, sql server, non-native, Database error 102 at OPC, msodbcsql.msi, SET_SINGLE_PARA  , 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.