BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Alok_Pal
Quartz | Level 8

Hi there,

 

Last night out system generated an high priority alerts for Data Mart APM ETL Availability going below 50%. This morning when I monitored the health and availability it was back up at 100%. I do checked the APM overnight processing and it seemed to be ran just fine. But I have no clue what could have caused the availability to go below 100%. Is there any log file or any other resources that I can look into in order to do the root cause analysis? any thoughts/ suggestions are always welcome.

 

Thank in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
JuanS_OCS
Amethyst | Level 16

Hello @Alok_Pal,

 

 

This alert is created under the resource Browse › YOUR_SERVERl SAS Environment Manager Data Mart 9.4 › APM ETL Processing.

 

If you click on the Inventory, you will see that the resource ( config/Lev1/Web/SASEnvironmentManager/emi-framework/bin/master_apm_etl.sh ) runs nightly  and it gives a warning if runs for more than 30 min, and an error if more than 1 hour.

 

In your case, the nightly process has run probably more than 30 min and the availability went down to 50%.

I would not be too concerned about it, but perhaps also it is a signal that it will need a review sooner or later.

 

To know more on what is going on, I would recomment you to run the same command manually and see what is going on:

master_apm_etl.sh -dv (optionally, you can also include the parameter --evdebug LEVEL)

 

http://support.sas.com/documentation/cdl/en/evug/69029/HTML/default/viewer.htm#p0y1q4ja8r14d1n1j2yzp...

http://support.sas.com/documentation/cdl/en/evug/69029/HTML/default/viewer.htm#n0ejv8qtopfvman1v14k1...

 

 

 

 

 

View solution in original post

2 REPLIES 2
JuanS_OCS
Amethyst | Level 16

Hello @Alok_Pal,

 

 

This alert is created under the resource Browse › YOUR_SERVERl SAS Environment Manager Data Mart 9.4 › APM ETL Processing.

 

If you click on the Inventory, you will see that the resource ( config/Lev1/Web/SASEnvironmentManager/emi-framework/bin/master_apm_etl.sh ) runs nightly  and it gives a warning if runs for more than 30 min, and an error if more than 1 hour.

 

In your case, the nightly process has run probably more than 30 min and the availability went down to 50%.

I would not be too concerned about it, but perhaps also it is a signal that it will need a review sooner or later.

 

To know more on what is going on, I would recomment you to run the same command manually and see what is going on:

master_apm_etl.sh -dv (optionally, you can also include the parameter --evdebug LEVEL)

 

http://support.sas.com/documentation/cdl/en/evug/69029/HTML/default/viewer.htm#p0y1q4ja8r14d1n1j2yzp...

http://support.sas.com/documentation/cdl/en/evug/69029/HTML/default/viewer.htm#n0ejv8qtopfvman1v14k1...

 

 

 

 

 

Alok_Pal
Quartz | Level 8
Thanks JuanS_OCS, that was really helpful and a good start I believe. Thanks again 🙂

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1196 views
  • 4 likes
  • 2 in conversation