Error while retrieving from Dataset

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dh_Madhu
Premium Member
Premium Member
Posts: 65
Joined: Sat Apr 23, 2005 3:19 am
Location: Stirling, Scotland

Error while retrieving from Dataset

Post by dh_Madhu »

Guys,
While writing to a dataset, the record datatype is set to binary and the field length is set to 748 to enable the quality stage to do the standardisation bit. Later I read the dataset which has now a bigger record length of 2580 bytes. while running the job, which performs a update or insert operation using oci, the following error occurs:
Import consumed only 2577bytes of the record's 2580 bytes (no further warnings will be generated from this partition).
Btw,the data is getting inserted.
The dataset is a fixed width and has no delimeter.

Any inputs will be appreciated.
Thanks in advance.
Regards,
Madhu Dharmapuri
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Well it will be getting inserted but Which stage is generating that error? Post all the warnings...
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
dh_Madhu
Premium Member
Premium Member
Posts: 65
Joined: Sat Apr 23, 2005 3:19 am
Location: Stirling, Scotland

Post by dh_Madhu »

Well yes! the import column stage had generated the error.
I have just found out that I had missed out pulling one column from the dataset. :roll:

Thanks,
Regards,
Madhu Dharmapuri
Post Reply