anant13703
Technical User
Hi all,
I have a mapping that have a complex SQL for fetching data. It taked around 2 hours just to run the query and fetch the first record.
The Target i have is a flat file and is located in some other machine and i need to do a Direct FTP with no staging since the business users dont want the target file to be created at informatica server at anytime. So i have FTP connection with No-staging.
In such scenario, the FTP session is opened during session initialization, the session goes on for 2+ hours(executing select SQL) and then fails with the following message :
WRT_8174 Error while flushing the buffer to output file [/staging/cms_cash_metrics_for_cap_1.out]. Error message is [Broken pipe], data buffer
[00000008281 000018000 0.00 0.00 90.00 0.00 0 0 24 0
00000008281 200301001 79.00 0.00 79.00 0.00 12 0 12 0
00000015415 200278008 0.00 0.00 79.00 -79.00 0 0 12-12
.
.
.
.
. and So-on...(some 1005 records)
What i think is that the FTP session that the informatica had initialized might have timed-out.
Query 1 - Kindly let me know if my perception of the problem is correct.
Query 2 - everything goes well if i configure FTP with Staging. But currently this is not an option. So is there anyway we can increase the session-timeout of FTP session?
Query 3 - Is there any Unix command or something to set FTP Session time out properties.
I'll appreciate your views and solution of this problem.
Cheers
Anant
I have a mapping that have a complex SQL for fetching data. It taked around 2 hours just to run the query and fetch the first record.
The Target i have is a flat file and is located in some other machine and i need to do a Direct FTP with no staging since the business users dont want the target file to be created at informatica server at anytime. So i have FTP connection with No-staging.
In such scenario, the FTP session is opened during session initialization, the session goes on for 2+ hours(executing select SQL) and then fails with the following message :
WRT_8174 Error while flushing the buffer to output file [/staging/cms_cash_metrics_for_cap_1.out]. Error message is [Broken pipe], data buffer
[00000008281 000018000 0.00 0.00 90.00 0.00 0 0 24 0
00000008281 200301001 79.00 0.00 79.00 0.00 12 0 12 0
00000015415 200278008 0.00 0.00 79.00 -79.00 0 0 12-12
.
.
.
.
. and So-on...(some 1005 records)
What i think is that the FTP session that the informatica had initialized might have timed-out.
Query 1 - Kindly let me know if my perception of the problem is correct.
Query 2 - everything goes well if i configure FTP with Staging. But currently this is not an option. So is there anyway we can increase the session-timeout of FTP session?
Query 3 - Is there any Unix command or something to set FTP Session time out properties.
I'll appreciate your views and solution of this problem.
Cheers
Anant