Error during file comparision

Rajee · Post by **Rajee** » Wed Apr 23, 2008 5:56 am

Hi,

I am trying to compare two files through the compare stage,i have imported the metadata of two files and set all the required properties.I have also checked for the metadata imported for the field "cnvrt_trd_crrnb_rt" and it is Decimal with length 15 and no scale,but when i try running the job i get the below quoted error.

BIOS_C069_OUTNA_OWNDELT_FILE: At field "cnvrt_trd_crrnb_rt": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=15, scale=0, round=trunc_zero, ascii}

Can anyone help me out in knowing the possible reason for the above error.

Thx,
Rajee

hamzaqk · Post by **hamzaqk** » Wed Apr 23, 2008 6:08 am

are you being able to view data in the two sequential files ?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 23, 2008 7:09 am

It's all in the message - the Field Width property is not set.

Rajee · Post by **Rajee** » Wed Apr 23, 2008 11:50 pm

ray.wurlod wrote:It's all in the message - the Field Width property is not set. ...

I dont find any attribute named "width" in either the sequential file stage or the compare stage.instead there is an attribute named "lenght" and that is assigned a value as 15.Can you let me know where you expect the "width" to be set.

Rajee · Post by **Rajee** » Wed Apr 23, 2008 11:53 pm

hamzaqk wrote:are you being able to view data in the two sequential files ?

No,I am not able to view the data,instead the same above error message is displayed.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 24, 2008 1:10 am

Go to the Columns grid. Right click on the appropriate row and choose Edit Row...

This should open a dialog in which the extended properties of the column you are editing are displayed, and you should find field width among them.

Rajee · Post by **Rajee** » Tue Apr 29, 2008 11:01 pm

ray.wurlod wrote:Go to the Columns grid. Right click on the appropriate row and choose Edit Row...

This should open a dialog in which the extended properties of the column you are editing are displayed, and you sh ...

Thanks ray,i got rid of the above error.But now I get the below info in the director and i have no clue about it.

OUTNA_OWNDELT_FILE,0: Input buffer overrun at field "W8_S", at offset: 38..

ray.wurlod · Post by **ray.wurlod** » Tue Apr 29, 2008 11:52 pm

More data than the field width allows for.

Rajee · Post by **Rajee** » Thu May 01, 2008 11:42 pm

ray.wurlod wrote:More data than the field width allows for. ...

I checked the source file,it does not have excess data than the length defined in the metadata.