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 , Business Suite on Adaptive Server Enterprise , 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.