How To Fix DAAG_PARTITIONING036 - Partitioning objects and groups are displayed based on the assigned roles

SAP Error Message - Details

• Message type: E = Error

• Message class: DAAG_PARTITIONING - Message Class for Partitioning

• Message number: 036

• Message text: Partitioning objects and groups are displayed based on the assigned roles

What causes this issue?

The roles are not displayed for the data aging object because:
+,,The role is not assigned to the user
+,,The user profile is not configured correctly

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

The system displays only the roles that are assigned to the user.

How to fix this error?

You can use the transaction PFCG to maintain values of the authorization
object S_DAGPTM in the role assigned to the user. A single sample role
(SAP_DAAG_ADMIN) is provided for administrators.
The SAP R/3 system uses the authorization object S_DAGPTM to perform an
authorization check for partitioning objects or partitioning groups. The
defined fields listed below should be maintained in the PFCG transaction
for the authorization object:
o,,Activity (ACTVT) - This field defines which general access
authorizations the user has. For example:
,,
Authorizations for S_DAGPTM,,
Authorization,,Value,,
Execute,,,,16,,
Display,,,,03,,
o,,Partition Type (PT_TYPE) - This field defines whether the
authorization is to be applied to a partitioning object or
partitioning group.
o,,Partition ID (PARTITION) - This field provides the name or ID of the
partitioning object or partitioning group to which the user has access.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DAAG_PARTITIONING036 - Partitioning objects and groups are displayed based on the assigned roles ?

  The SAP error message DAAG_PARTITIONING036 indicates that partitioning objects and groups are displayed based on the assigned roles. This message typically arises in the context of SAP BW (Business Warehouse) or SAP HANA, where partitioning is used to improve performance and manageability of large datasets.
  Cause:
  The error message is not necessarily an error in the traditional sense but rather an informational message indicating that the visibility of partitioning objects and groups is restricted based on the user's assigned roles. This means that if a user does not have the appropriate authorization or role assigned, they will not be able to see certain partitioning objects or groups in the system.
  Solution:
  To resolve this issue, you can take the following steps:
  
  
  Check User Roles and Authorizations:
  
  Ensure that the user experiencing the issue has the necessary roles assigned that grant access to the relevant partitioning objects and groups.
  You can do this by navigating to the user management area in SAP (Transaction code: SU01) and reviewing the roles assigned to the user.
  
  
  
  Assign Appropriate Roles:
  
  If the user lacks the necessary roles, you may need to assign the appropriate roles that include access to the partitioning objects. This may involve working with your SAP security team to ensure that the user has the correct authorizations.
  
  
  
  Review Role Configuration:
  
  If you are responsible for role management, review the configuration of the roles to ensure they include the necessary authorizations for accessing partitioning objects and groups.
  
  
  
  Testing:
  
  After making changes to roles or authorizations, have the user log out and log back in to see if the issue is resolved.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for more detailed information on partitioning and authorization management.
  
  
  
  Related Information:
  
  Partitioning in SAP BW/HANA: Partitioning is a technique used to divide large tables into smaller, more manageable pieces, which can improve query performance and data management.
  Authorization Objects: In SAP, authorization objects control access to various functionalities and data. Understanding how these work is crucial for managing user access effectively.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as SU01 (User Maintenance), PFCG (Role Maintenance), and RSUSR003 (User Comparison) for managing user roles and authorizations.
  
  If the issue persists after checking roles and authorizations, consider reaching out to your SAP Basis or security team for further assistance.