SAP Knowledge Base Article - Preview

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

Symptom

In SystemLog (transaction sm21):

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

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

B Tue Jan 01 00:00:00 2020
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 =======================================================================#
C C
C reate table function sap_tf_tlist#
C (C) SAP Labs, 2001, 2002, 2003, 2008, 2009
C , 2010, 2011#
C ===============================================================
C ========#
C #
C SET NOCOUNT ON#
C DECLARE @objname varchar(64) new parameter i
C n 731, dematerialized#


Read more...

Environment

SAP NetWeaver system

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 , 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.