Problem with FTP PLUGin stage when used for FIXED Width file
Posted: Fri Dec 01, 2006 4:12 am
Hi
I am facing a problem in using the FTP Plugin stage (in Parallel jobs).
The requirement is we have to tranfer the file from /datahub/dev/ams/ready to /datahub/dev/wc/target. Bothe are on the same BOX.
The login credentials for the /datahub/dev/ams is abc and for /datahub/dev/wc is xyz.
The source data is in the format
[cs2dhbi01:amsdev:/datahub/dev/ams/ready/Customer]cat abc.dat
2 FSWM1D06120100.dat91 0 0
I should get the target file also in the same format. When i am setting the properties in the FTP Plug in
Fixed-Width Columns to YES the job is ABORTING with the following error
FTP_Plug_in_0,0: Fatal Error: Fatal: Internal error: function 'row_to_external()' failed
At row 1, link "DSLink6", while processing column "Batch_ID"
Unable to retrieve column data
Source type (Long) does not promote to destination type (Raw)
The file does not have any Long or Raw datatypes. It is a FIXED Width file with 4 integer columns and 1 varchar column.
When i set the properties Fixed-Wdth Columns to NO and Column Delimiter to PIPE, the job is running fine and the output is
[cs2dhbi01:wcdev:/datahub/dev/wc/target]cat ABC.dat
2|FSWM1D06120100.dat|91|0|0
I want the target file also to be a FIXED WIDTH one, same as the source file.
Pls help me in this regard
Thanks Ahead,
Sadhvi
I am facing a problem in using the FTP Plugin stage (in Parallel jobs).
The requirement is we have to tranfer the file from /datahub/dev/ams/ready to /datahub/dev/wc/target. Bothe are on the same BOX.
The login credentials for the /datahub/dev/ams is abc and for /datahub/dev/wc is xyz.
The source data is in the format
[cs2dhbi01:amsdev:/datahub/dev/ams/ready/Customer]cat abc.dat
2 FSWM1D06120100.dat91 0 0
I should get the target file also in the same format. When i am setting the properties in the FTP Plug in
Fixed-Width Columns to YES the job is ABORTING with the following error
FTP_Plug_in_0,0: Fatal Error: Fatal: Internal error: function 'row_to_external()' failed
At row 1, link "DSLink6", while processing column "Batch_ID"
Unable to retrieve column data
Source type (Long) does not promote to destination type (Raw)
The file does not have any Long or Raw datatypes. It is a FIXED Width file with 4 integer columns and 1 varchar column.
When i set the properties Fixed-Wdth Columns to NO and Column Delimiter to PIPE, the job is running fine and the output is
[cs2dhbi01:wcdev:/datahub/dev/wc/target]cat ABC.dat
2|FSWM1D06120100.dat|91|0|0
I want the target file also to be a FIXED WIDTH one, same as the source file.
Pls help me in this regard
Thanks Ahead,
Sadhvi