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.