cancel
Showing results for 
Search instead for 
Did you mean: 

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

sateesh_kumar1
Active Contributor
2,318

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 [10.5.2.12] 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
Sateesh

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello,

were you able to resolve the issue? we are facing similar issue with SFTP. we can see 0 KB file on SFTP site.

Thanks,

Mahesh

sateesh_kumar1
Active Contributor
0 Kudos

Hi Mahesh ,

as per SAP Note 2581781, issue is fixed in following versions .I didn't get chance to test.

Regards

Sateesh

Former Member
0 Kudos

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.

Regards,

Lokesh

sateesh_kumar1
Active Contributor
0 Kudos

Hi Lokesh ,

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

Regards

Sateesh

sateesh_kumar1
Active Contributor
0 Kudos

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 .

Regards

Sateesh

sateesh_kumar1
Active Contributor
0 Kudos

+additional information ,

we tried from BODS ,ended up getting below error

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

below is error message ,from fiddler .

fiddler.network.readresponse.failure> 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

former_member184995
Active Contributor
0 Kudos

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?

https://blogs.sap.com/2015/07/23/sftp-destination-for-sap-businessobjects-bi-platform-41/

There is also note

https://launchpad.support.sap.com/#/notes/2183131

Best Regards,

Jason