Snapshots Not Running

[Former Member]

I am trying to figure out how to get a snapshot to run from within the S&OP Excel Add-In, but so far I can't see any indications that anything is happening if I run a snapshot immediately or schedule one to run in the near future. The snapshots listed below have been "started" over the past several days (which is hard to see because no dates are listed):

I don't see much showing up in my HANA log files either. Any ideas what might be wrong or any pointers on how to troubleshoot this problem?

Thanks!

[Former Member]

I have learned that this the snapshots are not working because there are some cron jobs that need to be installed on the HANA instance where S&OP is installed. Since, I am using a system managed by someone else, a ticket was submitted to address this issue. However, I believe the scripts are the ones found in the file attached to this work document called bgframework.zip. The directions aren't super clear in my opinion, but I believe you will want to unzip this folder in your instance's admin user's home directory and put crontab entries for each of the four scripts like so:

crontab -e
*/2 * * * * /usr/sap/HD5/HDB05/bgframework_new/bg_dataintegration.sh >/dev/null 2>&1 */2 * * * * /usr/sap/HD5/HDB05/bgframework_new/bg_operator_group.sh >/dev/null 2>&1 */2 * * * * /usr/sap/HD5/HDB05/bgframework_new/bg_operator.sh >/dev/null 2>&1 */2 * * * * /usr/sap/HD5/HDB05/bgframework_new/bg_scenario.sh >/dev/null 2>&1

You will need to edit each of the scripts likely to point to your SOPBGADMIN's hdbuserstore's key and probably change the non-standard location of hdbsql. Here's a couple quick helper bash scripts:

find . -name "*.sh" -print | xargs sed -i 's/\/usr\/sap\/LM1\/HDB02\/exe\/hdbsql/\/usr\/sap\/hdbclient\/hdbsql/g'
find . -name "*.sh" -print | xargs sed -i 's/lm1key/BGD05/g'

Here I changed the given key of "lm1key" to "BGD05". Also, in case you wanted to confirm that the cron jobs are running, you can temporarily omit the ">/dev/null 2>&1" to allow the results to go to your user's mail. You can check the mail with just "mail" from bash or look at /var/mail/.