Sequential Files in PX

[mc_harsha]

Hi,

Error Message:
S1A3_ITEM_LOC_WK,0: Import consumed only 24bytes of the record's 25 bytes (no further warnings will be generated from this partition)

Any info why we will get above type of error?

with regards,
harsha

[Maveric]

Do an exact search on "Import consumed only". This has been answered a lot of time.

[ArndW]

With just a 1 byte difference my guess would be line terminators in UNIX - they probably were not specified in the file format.

[ray.wurlod]

... or that the file came from Windows, and has a two-character record terminator string. As noted, this question has been answered before.

[mc_harsha]

You are right..... Windows Seq file...

File End Delimiter : None

[ray.wurlod]

Use Record Delimiter String property, set to "DOS-style", rather than Record Delimiter property.

[mc_harsha]

Thanks for you response.

What i did:
From Oracle Table Imported into Excel using sql developer, then converted into CSV file.(Windows operating system)

Now here using as source file.

Using Record delimiter string=Dos format, getting the following warning

S1A2_ITEM_LOC_DC_NONWK1,0: Input buffer overrun at field "ITEM"
S1A2_ITEM_LOC_DC_NONWK1,0: Import warning at record 0:
S1A2_ITEM_LOC_DC_NONWK1,0: Import unsuccessful at record 0:

Now unable to view the data itself in the seq stage.

Previously using final delimiter = none, able to view the data.

-In my mind, Because of the final delimiter, i am getting the above error.

What could be the problem?

[ray.wurlod]

Not final delimiter - this appears between the data and the record delimiter.

Now read my previous post again.

[mc_harsha]

thanks buddy....

Got you....working fine :D

[ray.wurlod]

Time to mark the thread as Resolved, then?