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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

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