Sequential Files in PX
Moderators: chulett, rschirm, roy
Sequential Files in PX
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
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
harshakumar mc
With just a 1 byte difference my guess would be line terminators in UNIX - they probably were not specified in the file format.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
harshakumar mc
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: