Error while reading File

[chandra.shekhar@tcs.com]

Hi,

I am reading a file through sequential file and I am getting the following error.

Code: Select all

Internal Error: (endingOffset_ >= startingOffset_+delimLen_): impexp/recordstream.C: 1948 
>Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH

The properties used in the file are :
Final Delimeter = end
Delimeter = ^
Null Field Value = ''
Quote = none

The most wierd part is the data in the file is

Code: Select all

20^193

It is not able to read even a single row, I am out of options.
I tried to search in the forum but didnt find any issue like mine.
Kindly suggest

[ArndW]

Have you defined this as a fixed-length file? Also, is your test file just one line, and if so, does it have a <lf> at the end? Just 2 columns in the file - is your DataStage sequential file also defined with 2 columns?

[chandra.shekhar@tcs.com]

Its not a fixed length file, as specified the delimeter is ^(caret).
Yeah, this test file is having only 1 record.
whats a <lf> ??

does it have a <lf> at the end

It has a new line character at the end. And in the job 2 columns are defined varchar(50) & Smallint respectively.

[prasson_ibm]

Hi,
On unix you can check the file format by command "od -c" and check if there is some garbage character there or not.

[chulett]

<lf> means line feed which on UNIX is the same as a "newline" I suppose. What have you specified as the record delimiter in the stage?

[chandra.shekhar@tcs.com]

@Craig
Its a new line character.
Actually this file is getting generated by a Job A and later in Job B this file acts as a source.
In Job A, when I view the data of the file(from datastage) its visible.
But in Job B, keeping all the properties same as Job A, I am not able to view the data.
I am going nuts...

[ArndW]

Just compare the attributes in both the

Code: Select all

Properties

and

Code: Select all

Format

tabs, they need to be identical.

[chandra.shekhar@tcs.com]

Its the same....

[ArndW]

Very strange.

What about Stage -> NLS Map, are they the same?