SAP Knowledge Base Article - Preview

3315883 - OPC Errors 102 Incorrect syntax near 'HINT'

Symptom

An error occurs in transaction DB02 (or transaction DBACOCKPIT) when entering screen Space -> Largest Tables

C Fri Mar 10 06:18:23:283 2023
C  ERROR: -1 in function StartSelect (execute) [line 17738]
C  (102) [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'HINT'.
C  Error 99 (dbcode 102) in StartSelect
C  StartSelect: stmt of NULL_STMTID
C  -- sap_get_top_tables RAT procedure to deliver the top largest or top
C  -- most modified tables, in one or all schemas.
C  -- Replaces sap_get_top_n_tables.
C  
C  declare @number      int
C  declare @order       nvarchar(1)
C  declare @schema_name sysname
C  declare @db_name     sysname 
....
C    set @cmd = @cmd +#
C      N'OPTION (USE HINT (''FORCE_LEGACY_CARDINALITY_ESTIMATION''));'#
C    set @cmd = @cmd + N' /*sap_get_top_tables*


Read more...

Environment

SAP Netweaver

Product

SAP ERP all versions ; SAP NetWeaver all versions

Keywords

Incorrect syntax near 'HINT' dbcode 102 sap_get_top_tables FORCE_LEGACY_CARDINALITY_ESTIMATION , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , 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.