Fixed width columns (Non Delimited file)

nhv · Post by **nhv** » Tue Oct 11, 2005 5:08 am

Hi All,
I'm trying to read data from the fixed width file via the FTP stage,
I'm getting the following error: Internal Error function 'utf_to_row()' failed

I defined all the column types as char and Not Nullable as required.
Also the column lengths are included correctly.

NOTE: reading a delimited file via FTP causes no problems.

Please suggest me the solution for this.

Thanks in Advance
NHV

roy · Post by **roy** » Tue Oct 11, 2005 5:49 am

Hi And Welcome Aboard

,
Searching this forum will get you lots of posts with great info.

What Os you use?
What exact DS version?
What is the OS of the system you try to ftp from?
What happens when you try to process this file after you manually ftped it to your DS server?

chulett · Post by **chulett** » Tue Oct 11, 2005 6:35 am

nhv wrote:Also the column lengths are included correctly.

As a guess, I would say - no, you didn't.

All it takes is one wrong one to hork the whole thing up. The other tidbit - assuming it works the same as the Sequential File stage - is it uses the information in the Display Size column - not the Size size column to drive itself.

nhv · Post by **nhv** » Tue Oct 11, 2005 7:05 am

Hi,

What Os you use - Unix
What exact DS version - 7.5
What is the OS of the system you try to ftp from - Unix
What happens when you try to process this file after you manually ftped it to your DS server- It works fine.

I used these manually ftped files in seq stage and it works perfect

Regards,
Nirav

nhv · Post by **nhv** » Tue Oct 11, 2005 7:07 am

Hi Craig,

Yes, I have mentioned the correct lengths under Display Size.

Regards.
nhv

chulett · Post by **chulett** » Tue Oct 11, 2005 7:19 am

And in the Properties, you've changed 'Fixed Width Columns' to 'Yes'?

nhv · Post by **nhv** » Tue Oct 11, 2005 7:39 am

Hi Craig,

I have set the relevant properties.The error I keep getting is
Internal Error function 'utf_to_row()' failed

Regards,
NHV

track_star · Post by **track_star** » Tue Oct 11, 2005 3:01 pm

Can you post the portion of the osh script with the ftp operator calls? If you're using the FTP Enterprise operator, look for the pftp entry in the osh script. If you're using the FTP plug-in, look for dscapiop and there will be an option immediately below that with the ftp shared object file name.

srividhya · Post by **srividhya** » Wed Oct 12, 2005 7:19 am

Hai nhv,
In the output properties
check against metadata --- yes
line termination --- [CR][LF] (DOS Style Termination)
Fixed width column --- yes
space between columns --- 0
All the other properties are to be default

In the ouput column give the length of the row (fixed width)
you can also check, if the file contains ^m in the end of line

Sri

DSXchange

Fixed width columns (Non Delimited file)

Fixed width columns (Non Delimited file)

Re: Fixed width columns (Non Delimited file)

Re: Fixed width columns (Non Delimited file)