Skip to Content

BI 4.2 SP3 schedule to SFTP with SSH-2 security is failing

Sep 06, 2017 at 01:34 PM


avatar image

Hi Team ,

Environment : BI 4.2 SP3 .
we are facing issue in scheduling webi report as excel/csv to sftp. Most of the times schedule showing failed status,but in sftp I see schedule out put file with 0KB.

error message :

connection error. []: [CrystalEnterprise.Sftp] in instance history.

destination_sftp: exception caught while putting source file [D:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\procSched\XXX.AdaptiveJobServer\CHILD0\JOB1\Test Report_30_3706756254865343140.xlsx] to sftp server [] as destination file [BI_PTD_PM/AM_PLANT_1001_SYNC/From_NONPRD2.xlsx]. Details: [Something went wrong while writing data. Please try again].in logs .

sometimes only out put with less 10 KB is sending to sftp .SFTP team verified there is no restriction on file size,file type ,characters for files .

Did you came through this issue?
sftp is using SSH-2 security .

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jason Everly
Sep 07, 2017 at 12:57 PM

Not sure about this one, if SSH-2 security is the problem or something else.

Have you gone through this blog and seen if you have things set up properly?

There is also note

Best Regards,


10 |10000 characters needed characters left characters exceeded
Sateesh Kumar Bukkisham Sep 07, 2017 at 03:14 PM

Thanks for reply Jason ,

Yes ,we have made configuration as per note and Ueda instructions .SAP ticket is also raised .We are not able to trace issue .

as mentioned up to 10 KB is file delivering ! .There is no restriction on file size ,no time outs set at SFTP .



Show 1 Share
10 |10000 characters needed characters left characters exceeded

+additional information ,

we tried from BODS ,ended up getting below error

<sftp> protocol. Error: <(-31) SFTP Protocol Error>

below is error message ,from fiddler .> Session #22 raised exception System.Net.Sockets.SocketException An established connection was aborted by the software in your host machine .

How can we resolve this ? Any configurations to apply at SFTP or BIP ?

Thanks in advance

Lokesh Madabathula Dec 06, 2017 at 10:46 PM

Hi Sateesh -

Did you resolve the issue? We're also seeing same issue. We have upgraded to SP4 but our sftp reports are failing as like you have. We can see the file with 0KB and schedule status failed. FTP is again working. Also, we have ensured above note FINGERPRINTs are correct.

Please let us know if you got solution from SAP.



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Lokesh ,

No .Issue still persists .We had to go with BW-BODS .