Recently there is an requirement to to send schedule reports from SAP BO 4.1 SP7 to two different SFTP locations.<\/p>\n
For configuring SFTP, you requires fingerprint. There are multiple ways to generate, you can get more details from here \u2013<\/p>\n
https:\/\/blogs.sap.com\/2015\/07\/23\/sftp-destination-for-sap-businessobjects-bi-platform-41\/<\/p>\n
This can be achieved by configuring SFTP destination in Servers \u2013 Adaptive Job Server \u2013 Destinations.<\/p>\n
You can configure 1 SFTP destination at a time in Adaptive Job Server \u2013 Destination & for second SFTP destination you need to create a clone of Job Server & configure with second SFTP destination.<\/p>\n
Now if you schedule the Job for Webi Reports, fill the SFTP destination field. it will pick the server automatically as given option \u2013 Use the first available server.<\/p>\n
The problem on this scenario is, I am getting success in sending the report to first SFTP destination but for second SFTP destination, it\u2019s continuously failing with sftp error as SFTP destination is different as compare to configure in Job Server.<\/p>\n
My challenge to give Second Job Server for sending the reports to my second SFTP destination. While scheduling you cannot select the Job Server however there is an option to select Job Server Group.<\/p>\n
To achieve this, I have created a Job Server Group in CMC \u2014 Servers with the name Job Server & assign the second Adaptive Job Server to this Group.<\/p>\n
I have suggested now to schedule the report again & choose option \u2013 Give preference to servers in selected group.<\/p>\n
This time it will pick the job server assigned to this group & it will send the data to second SFTP destination successfully.<\/p>\n
A major drawback of this configuration is, if a job server assigned to this group get stopped then it will stop sending data to SFTP destination & job also start getting failed.<\/p>\n","protected":false},"excerpt":{"rendered":"
Recently there is an requirement to to send schedule reports from SAP BO 4.1 SP7 to two different SFTP locations. For configuring SFTP, you requires fingerprint. There are multiple ways to generate, you can get more details from here \u2013 https:\/\/blogs.sap.com\/2015\/07\/23\/sftp-destination-for-sap-businessobjects-bi-platform-41\/ This can be achieved by configuring SFTP destination in Servers \u2013 Adaptive Job Server […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[733,732,731,729,606,730,734],"class_list":["post-806","post","type-post","status-publish","format-standard","hentry","category-sap-updates","tag-adaptive-job-server","tag-business-objects","tag-cmc","tag-job-server","tag-sap-bo","tag-sftp","tag-webi-reports"],"_links":{"self":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/comments?post=806"}],"version-history":[{"count":1,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/806\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/posts\/806\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/media?parent=806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/categories?post=806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adilfahim.com\/myblog\/wp-json\/wp\/v2\/tags?post=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}