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
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.