error creating fileset

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
shivadas
Participant
Posts: 48
Joined: Tue Jun 12, 2007 12:10 am

error creating fileset

Post by shivadas »

Hi while creating the fileset i am getting a following error:


When checking operator: No nodes with disk in "export" resource pool; using default disk pool instead

before some time the same job was running fine.
we did not change the config.apt file.

while trying to view data it says data overflow at a particular field.
##W TOIX 000000 13:10:02(000) <File_Set_3,0> Input buffer overrun at field "TCCOPOST", at offset: 463
##W TOIX 000154 13:10:02(001) <File_Set_3,0> Import warning at record 0:
##W TOIX 000018 13:10:02(002) <File_Set_3,0> Import unsuccessful at record 0:
##W TOIX 000000 13:10:02(003) <File_Set_3,0> Input buffer overrun at field "TCCOPOST", at offset: 343
##W TOIX 000154 13:10:02(004) <File_Set_3,0> Import warning at record 1:
##W TOIX 000018 13:10:02(005) <File_Set_3,0> Import unsuccessful at record 1:
##W TOIX 000000 13:10:02(006) <File_Set_3,0> Input buffer overrun at field "TCCOPOST", at offset: 340
##W TOIX 000154 13:10:02(007) <File_Set_3,0> Import warning at record 2:
##W TOIX 000018 13:10:02(008) <File_Set_3,0> Import unsuccessful at record 2:
##W TOIX 000000 13:10:02(009) <File_Set_3,0> Input buffer overrun at field "TCCOPOST", at offset: 421
##W TOIX 000154 13:10:02(010) <File_Set_3,0> Import warning at record 3:
##W TOIX 000018 13:10:02(011) <File_Set_3,0> Import unsuccessful at record 3:
##W TOIX 000000 13:10:02(012) <File_Set_3,0> Input buffer overrun at field "TCCOPOST", at offset: 390
##W TOIX 000154 13:10:02(013) <File_Set_3,0> Import warning at record 4:
##W TOIX 000018 13:10:02(014) <File_Set_3,0> Import unsuccessful at record 4:
##I TOIX 000157 13:10:02(015) <File_Set_3,0> (no further reports will be generated from this partition until successful import)
##I TOIX 000163 13:10:02(016) <File_Set_3,0> Import complete. 0 records imported successfully, 10 rejected.

and jobs finishes sucessfully with any warnings but no data is generated at the target dataset?

can any one help me ...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

All of the warnings relate to an import operator. You are failing to read from something correctly. Make sure that the table (schema) definition is accurate - re-import it from whatever it is you are reading.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply