SAP Knowledge Base Article - Preview

2505448 - ASE Error SQL589 Invalid role string received and SQL7332 The untyped variable ? is allowed only in in a WHERE clause - SAP ASE for BS

Symptom

  • After Solution Manager upgrade from 7.1 to 7.2, Error SQL589/SQL7332 happen when it connects to some remote managed/monitored system and checks user permission/role.
  • The involved sql statement is "SELECT has_role( ? ,1)":
      
          C  ERROR: -1 in function DescribeLobTable (SQLDescribeParam) [line 48303]
          C  (7332) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]The untyped variable ? is allowed only in a WHERE clause or the SET clause of an UPDATE statement or the VALUES list of an INSERT statement
     
          C  ERROR: -1 in function DescribeLobTable (SQLDescribeParam) [line 48303]
          C  (30094) [HY000] [SAP][ASE ODBC Driver]The data type or the function is not supported.
          C  sql statement is ==> SELECT has_role( ? ,1)
          C  /* R3:CL_SQL_STATEMENT==============CP:500 T:notable M:300 */
      
          C  ERROR: -1 in function StartSelect (execute) [line 25488]
          C  (589) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Invalid role string received.
      
          C  sql statement is ==> SELECT has_role( ? ,1)
          C  /* R3:CL_SQL_STATEMENT==============CP:500 T:notable M:300 */
     
  • The managed/monitored systems are not running any SAP applications. They are CMS (Central Management Service), the main database for Business Objects application.
  • Upgrading SAP ASE ODBC driver and DBSL to the latest version does not fix the problem;
  • On the remote managed system database, there is no ASE sap_adm and sap_mon role;
     


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.2
  • Business Objects System 4.1 SP6 PL4
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions ; SAP Solution Manager 7.2

Keywords

SQL30094, 30094,SQL7332,7332,SQL589,589, sap_adm, sap_mon , 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.