Error viewing data from Sequential file

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
vskr72
Premium Member
Premium Member
Posts: 128
Joined: Wed Apr 28, 2004 9:36 pm

Error viewing data from Sequential file

Post by vskr72 »

I am getting the following warning messages and I cannot view the data. The error is not clearly stating the reason for failure.

Code: Select all

 ##W IIS-DSEE-TOSH-00049 19:37:07(005) <main_program> Parameter specified but not used in flow: DSProjectMapName
 ##I IIS-DSEE-TFSC-00001 19:37:07(011) <main_program> APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt
 ##W IIS-DSEE-TOIX-00018 19:37:07(000) <INFL_CREDIT,0> Import unsuccessful at record 0.
 ##W IIS-DSEE-TOIX-00018 19:37:07(001) <INFL_CREDIT,0> Import unsuccessful at record 1.
 ##W IIS-DSEE-TOIX-00018 19:37:07(002) <INFL_CREDIT,0> Import unsuccessful at record 2.
 ##W IIS-DSEE-TOIX-00018 19:37:07(003) <INFL_CREDIT,0> Import unsuccessful at record 3.
 ##W IIS-DSEE-TOIX-00018 19:37:07(004) <INFL_CREDIT,0> Import unsuccessful at record 4.
 ##I IIS-DSEE-TOIX-00193 19:37:07(005) <INFL_CREDIT,0> No further reports will be generated from this partition until a successful import.
 ##I IIS-DSEE-TOIX-00163 19:37:07(006) <INFL_CREDIT,0> Import complete; 0 records imported successfully, 306 rejected.
 **VIEWDATA ROW LIMITER HIT**
Thank you for your inputs.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Put simply, your data and metadata don't match.

Add a reject link to capture the rejected records. Compare these to the metadata that describe them.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vskr72
Premium Member
Premium Member
Posts: 128
Joined: Wed Apr 28, 2004 9:36 pm

Post by vskr72 »

Thank you RAy. Will check using reject link.
Post Reply