on 11-29-2017 10:48 PM
I have several SFTP sites that BOE has scheduled reports and sends data to on a regular basis. They all worked when the BOE server was at 4.2 SP02 in October 2017. I upgraded to 4.2 SP04 mid-October. All SFTP sites are working now except one. This particular site will send data but it will be received at the destination site as a 0 byte file. The fingerprint is correct because it worked with SP02 and it does send the file but, again, with 0 bytes. BOE reports the report instance as failed. The destination site is using Ipswitch SFTP Server. I sent the Network Manager the correct settings for one of the sites that works and he verified that his site had the same security settings. Additionally, using WinSCP directly on the BOE server to send the file works fine also--the file size is correct. Our firewall team ran a trace and the sftp send via BOE had the same results from this non-working site as with all of the working sites so there are no firewall blocks.
Any ideas on what to do to fix this?
Just answering this for closure.
I shot this over to development under Note 2581781
https://launchpad.support.sap.com/#/notes/2581781
It's a coding error and will be fixed in future patches on both 4.1 and 4.2
The fix levels for the issue will be updated in the Note once the patches containing the release are available for download.
Cheers,
Leslie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Approximately how large is the csv file for 27 days?
Could you shoot me an email at leslie.mui@sap.com with the incident #?
Is the SFTP destination off-site (fairly far away from the BI servers?)
If it's the same cause as Sateesh's issue, the difference in behaviour is a result of the change in Note 2346469.
I have a good guess as to what the problem is, but it'd need some testing
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just an update, I forwarded Celeste's incident to development under Note 2581781
https://launchpad.support.sap.com/#/notes/2581781
The Note isn't currently public, but I expect it to be published in the next day or so.
The developer assigned will reach out to you via the incident if more info is required Celeste.
I do have a technical case open but am hoping for other information from the community.
After further investigation and testing, I found that it is not the sftp site but rather the size/selection of the query to create the file. The file is in an .csv format. The query (prompts) to create the file normally uses 90 days and creates the 0 byte file. When I set the query to 27 days or less, it worked and sftp'd the file correctly. When I set it at 28 days or more, it fails in BOE and sends a 0 byte file to the vendor sftp location.
No resolution yet, but at least I have made progress on narrowing down the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
please contact technical support for this kind of investigation
kind regards, H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Grone ,
we too observing same issue , I've raised thread to SAP ,but no solution .
https://answers.sap.com/questions/301070/bi-42-sp3-schedule-to-sftp-with-ssh-2-security-is.html
Regards
Sateesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.