SAP Knowledge Base Article - Preview

2621321 - Error SQL10386 and SQL567 in SM21 and dev traces for SAP ASE for BS

Symptom

Frequent errors 10386 and 567 in SM21 system log:

From dev_* trace:

B  ***LOG BY2=> sql error 10386 performing EXE [dbds         296]
B  ***LOG BY0=> [ASE Error SQL10386][SAP][ASE ODBC Driver][Adaptive Server Enterprise]SELECT BUILTIN permission denied on builtin as

C ERROR: -1 in function StartSelect (execute) [line 24412]
C  (567) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]You must have the following ro
C  le(s) to execute this command/procedure: 'sa_role'. Please contact a user with t
C  he appropriate role for help.

Database error 10386 at EXE
[ASE Error SQL10386][SAP][ASE ODBC Driver][Adaptive Server
Enterprise]SELECT BUILTIN permission denied on builtin
asehostname, owner system administrator

Database error 567 at OPC
[ASE Error SQL567][SAP][ASE ODBC Driver][Adaptive Server
Enterprise]You must have the following role(s) to execute
this command/procedure: 'sa_role'. Please contact a user wit
the appropriate role for help. [ASE Error SQL567][SAP][ASE
ODBC Driver][Adaptive Server Enterprise]You must have the
following role(s) to execute this command/procedure:
'oper_role'. Please contact a user with the appropriate role
for help.

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2

Keywords

10386, 567, SQL10386, SQL567, SM21 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.