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