3209103 - "SELECT BUILTIN permission denied..." returned by SAP_COLLECTOR_PERFMON_RSDOOS_MSC - SAP ASE for Business Suite

• Solution Manager is reporting red traffic light for the job SAP_COLLECTOR_PERFMON_RSDOOS_MSC, returning error in the Job Log (SM37):
  
  • "Error while executing request tm/dbms_grp/syb/sync_extended_props; step_id=DRS_ABIFNK23RUPOPHG4SDPKFRNA7M, rc=10386,[ASE Error SQL10386]SELECT BUILTIN permissio         /STMC/CR_MSG "
    
    
• From developper trace file you can see before the error a connection is done to a remote SAP ASE database and a long query reported without a "From" clause but assigning values to columns like this:
  
  • C  ERROR: -1 in function StartSelect (execute) [line 34746]
    C  (10386) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]SELECT BUILTIN permission deni
    C  ed on builtin asehostname, owner system administrator
    C
    C  sql statement is ==> ( SELECT 'THIS' AS TM_SYS_TYPE,
    C           'THIS' AS TM_SYS_SUBTYPE,
    C           'T
    C  HIS' AS TM_TECHNICAL_ID,
    C           'TM/TECHNICAL_ID' AS PROPERTY_ID,
    C           C
    C  AST( ( rtrim(db_name()) || '|' ||
    C                   @@servername || '|' ||
    C
    C               'xxxxx.xxxxx.xxx' ) AS VARCHAR(128)) AS PROPERTY_VAL
    C  UE,
    C           'P' AS PROPERTY_KIND,
    C           '' AS SYNC_FLAGS )
    C   UNION
    ....
    ....
    ....
    C   UNION
    C  ( SELECT 'GLOBAL' AS TM_SYS_TYPE,
    C           'GLOBAL' AS TM_SY
    C  S_SUBTYPE,
    C           'GLOBAL' AS TM_TECHNICAL_ID,
    C           'TM/IS_AUTH_APPL' AS
    C   PROPERTY_ID,
    C           CASE
    C             WHEN OBJECT_ID('@DATABASE_NAME@.@OBJECT
    C  _OWNER@.E070') > 0 THEN 'Y'
    C             ELSE 'N'
    C           END AS PROPERTY_VALUE
    C  ,
    C           'S' AS PROPERTY_KIND,
    C           '' AS SYNC_FLAGS )
    C   UNION
    C  ( SELECT
    C   'THIS' AS TM_SYS_TYPE,
    C           'THIS' AS TM_SYS_SUBTYPE,
    C           'THIS' AS
    C  TM_TECHNICAL_ID,
    C           'DB/SYB/RELEASE_SUPPORTED' AS PROPERTY_ID,
    C
    C  CASE
    C              WHEN  (((SELECT @@sbssav) >= '15.7.0.139') AND ((SELECT @@sbss
    C  av) <= '15.9.9.999' )) OR (((SELECT @@sbssav) >= '16.0.02.06') AND ((SELECT @@sb
    C  ssav) <= '16.9.99.99' ))
    C               THEN 'Y'
    C               ELSE 'N'
    C
    C   END AS PROPERTY_VALUE,
    C           'P' AS PROPERTY_KIND,
    C           'COPY_PROP_TO_
    C  CHLD_LVLS=DBMS' AS SYNC_FLAGS )  -- TMC ( P43, DR-DB, TMS_ABIFNP3UTAPOZG6BEQ7DBL
    C  GK6E, TMC#ABIFNP3UTAPNZDUGI73LWPXMTM, tm/dbms_grp/syb/sync_extended_props )
    C  dbdssyb: DBSL99 SQL10386
    C  [ASE Error SQL10386]SELECT BUILTIN permission denied on builtin asehostname, owner system administrator
    B  ***LOG BY2=> sql error 10386 performing OPC [dbds         447]
    B  ***LOG BY0=> [ASE Error SQL10386]SELECT BUILTIN permission denied on builtin asehostname, owner system administrator [dbds         447]

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Solution Manager (SOLMAN) 7.2

SQL10386, asehostname, builtin, TMC, solman , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem