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