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
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.
SAP Knowledge Base Article - Preview