Included patch files
This V3.0 SP11 release contains three files:
- K-300SP11NEWR.SAR
- _NEWR_DATA_PROVIDERV3.11.SAP
- _NEWR_COLLECTION_MANAGER.SAP
Implementation procedures
Service pack installation and configuration
- Where to install: Deploy this service pack to client 000 of your Central Monitoring System.
- Configuration location: Perform all subsequent configuration tasks in the business client of your Central Monitoring System.
- Complete instructions: For step-by-step installation procedures, consult Installation Guide V3.0 (Appendix VIII: Install Service Pack) or Admin Guide V3.0 (Section: Install Service Pack).
Updates in this patch
BTP monitoring related updates
NR_BTP_UDM: Provides SAP Usage Data Management events for SAP BTP. Gathers, stores, and makes usage information available for all services and applications across all regions in a cloud deployment for central analysis, reporting, and license auditing (Data Provider Type: Event).NR_CLOUD_CONNECTOR: Enhanced to include a new numerical attributeDAYS_TO_EXPIREfor the event tableNR_CLOUD_CONNECTOR_CERT. This attribute identifies remaining days before certificate expiration in Cloud Connector.- API-based data providers: Added certificate expiration checks in
/NEWR/API_DATA_COLLECTORdata provider function module. Compiles all certificates available in STRUST (under SSL Client Standard or SSL Client Anonymous) and matches them against the target host of the respective RFC destination. When a match is found, the valid-to date is checked. An error is thrown stating "The certificate is expired for the host <host_name>" when an expired certificate is detected during data provider execution.
S/4 HANA and ECC related updates
- HANA DB data providers: Enhanced
/NEWR/AGENT_HDBand/NEWR/AGENT_HDB_EVENTfunction modules to handle query statements that use aliases for table names. - Background RFC Q data provider: New data provider
NR.SAP.BGRFC.Qfor monitoring background RFC queues. - IDoc data provider: Updated
NR_SAP_IDOCto include partner IDoc ID. - System memory data provider: Updated
NR.SAP.SYSTEM.MEMORY.HEAP_USAGE- changed parameterMTE_CLASStoR3MemMgmtHeapAct. - Connection issue handling: Protection triggered by temporary connection issues no longer requires manual intervention to clear.
- HANA Sidecar support: Bug fix allows HANA Sidecar to be added as a monitored system without specifying the RFC destination.
- New Relic account parameter: Bug fix ensures the
NR_ACCIDparameter in New Relic data providers is not overridden when new monitored system configuration is generated.
Updated HANA data providers
NR.SAP.HDB.METRICS: Enhanced to include two new data points:
NUM_CONNECTIONS: Shows number of connections by statusTHREADCNT: Shows active thread counts
New HANA data providers
NR_SAP_HDB_BACKUP_BROKEN: Captures HANA backup history broken information (Event)NR_SAP_HDB_BLKED_TRANS: Provides snapshots of HANA blocked transactions (Event)NR_SAP_HDB_LICENSES: Monitors HANA license information (Event)NR_SAP_HDB_LONG_TRANS: Tracks long running transactions (Event)NR_SAP_HDB_PWD_EXPIRE: Shows users with expiring passwords (Event)NR_SAP_HDB_THREADS: Captures long running thread information (Event)
Bug fixes
- RFC check program: Updated
/NEWR/REGISTRY_RFC_CHECKwith improved functionality. - Payload data gap: Fixed bug causing data gaps in payload data for data provider
NR_SAP_ABAP_WS. - Expensive statement traces: Fixed issue where expensive statement spans were not shown in New Relic traces for programs accessing HANA database.
Manual configuration updates
Upgrade from SP10 to SP11 with existing CloudALM data providers
If CloudALM-based data providers are configured in SP10, add a new CALM_LMS system to monitored systems after upgrading to SP11. During upgrade, after completing "Copy Template Tables from Client 000", proceed to "Define the Monitored Systems" and add:
Field | Value |
|---|---|
SAP System ID | CALM_LMS |
Client | Leave blank |
Destination | RFC Destination used for CALM data provider authentication |
Software Component | Leave blank |
Database Vendor | Leave blank |
DB Connection | Leave blank |
New Relic Account ID | New Relic account to send data to |
API Host | API host used for CALM data providers |
Important
Select Monitoring Group CALM_LMS for this monitored system.
New RFC check program
The RFC check program has been updated with a maximum wait time to receive responses from each destination.
Results now include latency measurements from each destination.
Authorization role updates
Authorization role /NEWR/DATA_PROVIDER
Authorization role /NEWR/DATA_PROVIDER has been updated to add access to the following function:
SREL_GET_NEXT_NEIGHBORS
Authorization role /NEWR/COLLECTION_MANAGER
This role is created specifically for the batch user on the central monitoring system to run collection manager jobs.
New data providers for ABAP business systems
NR_SAP_HDB_BACKUP_BROKEN
Captures HANA DB backup broken history events.
Configuration:
- Data Provider Function:
/NEWR/AGENT_HDB_EVENT - Finisher Function:
/NEWR/EVENTS_FINISHER - Monitoring Group:
HANA_DB - DP Period: 1 Hour
This data provider comes pre-activated. Required parameters:
Parameter | Description | Default Value | Attribute |
|---|---|---|---|
| Database Connection | No | |
| Monitored System RFC Destination | ||
| Collection Time Period | ||
| Monitored System ID | Yes |
Output attributes:
Attribute | Description |
|---|---|
| The unique ID of the broken backup history entry |
| The local time at which the broken backup history was detected |
| The UTC time at which the broken backup history was detected |
| The persistence volume ID |
| The host name |
| The type of database service |
| The redo log position of the broken backup history entry |
| The reason for the broken backup history |
| Additional message for backup broken history |
NR_SAP_HDB_BLKED_TRANS
Captures blocked transactions in HANA DB events.
Configuration:
- Data Provider Function:
/NEWR/AGENT_HDB_EVENT - Finisher Function:
/NEWR/EVENTS_FINISHER - Monitoring Group:
HANA_DB - DP Period: 5 Minutes
This data provider comes pre-activated. Required parameters:
Parameter | Description | Default Value | Attribute |
|---|---|---|---|
| Database Connection | No | |
| Monitored System RFC Destination | ||
| Collection Time Period | ||
| Monitored System ID | Yes |
Output attributes:
Attribute | Description |
|---|---|
| Blocking starting time |
| Blocking end time |
| Site ID |
| Host name |
| Internal port |
| Type of lock: Record, Table, Metadata |
| Lock mode: SHARED, EXCLUSIVE |
| The name of the schema on which the lock is currently placed |
| The name of the object on which the lock is currently placed |
| The ID of the record on which the lock is currently placed |
| The connection ID associated with the blocked write transaction |
| The write transaction ID of the write transaction waiting for the lock |
| Hash code for the statement being blocked |
| The connection ID associated with the write transaction holding the lock |
| The write transaction ID of the write transaction holding the lock |
| The client host for the lock owner |
| Process ID for the lock owner |
| Application source for the lock owner |
| Lock owner's statement |
| Hash code for the lock owner statement |
NR_SAP_HDB_LICENSES
Captures HANA DB license information events.
Configuration:
- Data Provider Function:
/NEWR/AGENT_HDB_EVENT - Finisher Function:
/NEWR/EVENTS_FINISHER - Monitoring Group:
HANA_DB - DP Period: 5 Minutes
This data provider comes pre-activated. Required parameters:
Parameter | Description | Default Value | Attribute |
|---|---|---|---|
| Database Connection | No | |
| Monitored System RFC Destination | ||
| Collection Time Period | ||
| Monitored System ID | Yes |
Output attributes:
Attribute | Description |
|---|---|
| The hardware key of the SAP HANA installation |
| The system identifier (SID) |
| The installation number |
| The system number |
| The license ID for the software product |
| The name of the licensed software product |
| The description of the licensed software product |
| The allowed product usage as specified by the license in bytes (e.g., main memory) |
| Description of allowed product usage |
| The peak product usage value during last 13 months, measured periodically, in bytes |
| The interval of license measurement, in hours |
| The date of the first installation of the license |
| The start date of the license validity period |
| The expiration date of the validity period of the license |
| The latest date on which the license was successfully checked and found valid |
| Displays TRUE if the license is permanent and FALSE if the license is temporary |
| Indicates whether the license is valid or not: TRUE/FALSE |
| Indicates whether the license is a memory-enforced license or not: TRUE/FALSE |
| Indicates whether the system is locked down due to license status: TRUE/FALSE |
| Indicates whether the license is a local database license: TRUE/FALSE |
NR_SAP_HDB_LONG_TRANS
Captures long running transactions in HANA DB events.
Configuration:
- Data Provider Function:
/NEWR/AGENT_HDB_EVENT - Finisher Function:
/NEWR/EVENTS_FINISHER - Monitoring Group:
HANA_DB - DP Period: 5 Minutes
This data provider comes pre-activated. Required parameters:
Parameter | Description | Default Value | Attribute |
|---|---|---|---|
| Database Connection | No | |
| Monitored System RFC Destination | ||
| Collection Time Period | ||
| Monitored System ID | Yes |
Output attributes:
Attribute | Description |
|---|---|
| The connection ID |
| The transaction object ID |
| The transaction start time |
| Elapsed time in seconds |
| User name |
| Client host |
| Connection status |
| Statement string for the transaction |
NR_SAP_HDB_PWD_EXPIRE
Captures expiring user password events.
Configuration:
- Data Provider Function:
/NEWR/AGENT_HDB_EVENT - Finisher Function:
/NEWR/EVENTS_FINISHER - Monitoring Group:
HANA_DB - DP Period: 1 day
This data provider comes pre-activated. Required parameters:
Parameter | Description | Default Value | Attribute |
|---|---|---|---|
| Database Connection | No | |
| Monitored System RFC Destination | ||
| Collection Time Period | ||
| Monitored System ID | Yes |
Output attributes:
Attribute | Description |
|---|---|
| User name |
| Password valid until this date |
| Number of days remaining before password expiration |
NR_SAP_HDB_THREADS
Captures long running threads in HANA DB events.
Configuration:
- Data Provider Function:
/NEWR/AGENT_HDB_EVENT - Finisher Function:
/NEWR/EVENTS_FINISHER - Monitoring Group:
HANA_DB - DP Period: 5 Minutes
This data provider comes pre-activated. Required parameters:
Parameter | Description | Default Value | Attribute |
|---|---|---|---|
| Database Connection | No | |
| Monitored System RFC Destination | ||
| Collection Time Period | ||
| Monitored System ID | Yes |
Output attributes:
Attribute | Description |
|---|---|
| Host name |
| Internal port |
| Connection ID |
| The ID of the statement being executed |
| The thread ID |
| The thread type |
| The thread state |
| The thread method |
| The internal name of the lock |
| The thread detail |
| The IP of the client machine |
| The client process ID |
| The service that called the thread |
| The service called by the thread |
| Whether the thread is active |
| The SQL user name |
| The name of the application |
| The application user name |
| The transaction ID |
| The thread duration in milliseconds |
| The active CPU time of the thread in microseconds |
| The active CPU time of the thread and its associated children in microseconds |
| The statement thread limit |
| The statement memory limit |
| The name of the workload class |
BTP monitoring new data providers
NR_BTP_UDM
Provides SAP Usage Data Management events for SAP BTP. Gathers, stores, and makes usage information available for all services and applications across all regions in a cloud deployment. This information supports central analysis, reporting, and license auditing.
Prerequisite:
RFC destination must be configured to handle authentication. Uses BASIC authentication based on Client ID and Client Password.
Configuration:
- Type: Event (API)
- Data Provider Function Module:
/NEWR/API_DATA_COLLECTOR - Finisher Function Module:
/NEWR/BTP_UDM_FINISHER - Monitoring Component:
BTP_UDM
This data provider comes pre-activated. Required parameters:
Parameter | Description | Default Value | Attribute |
|---|---|---|---|
| UDM data extraction host | No | |
| UDM data extraction path | No | |
| UDM data extraction query | No | |
| An integer value determining the collection period. If set as 1, details for last month will be collected. If set as 2, details for last 2 months will be collected. | No | |
| Authentication destination for UDM | No | |
| New Relic platform account number | No | |
| Monitored System ID | Yes |
Setup instructions:
To get details for API_HOST, Authentication URL, Client ID, and Password:
- Create a Service Instance for Usage Data Management Service with plan
reporting-ga-admin. - Create a service key - it will contain the necessary details.
- Base URI format:
https://uas-reporting.cfapps.<landscape domain>/reports/v1