I'm trying to load a sequential file created as output in a server job in a parallel job. I am unable to view load or view the data, the error that pops up is :
##I TFCN 000001 16:52:17(000) <main_program>
DataStage XE Parallel Extender V7.0.0
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TOSH 000002 16:52:17(001) <main_program> orchgeneral: loaded
##I TOSH 000002 16:52:17(002) <main_program> orchsort: loaded
##I TOSH 000002 16:52:17(003) <main_program> orchstats: loaded
##I TFSC 000001 16:52:17(004) <main_program> APT configuration file: /ascential/datastage/70/UND/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 16:52:18(000) <main_program> Parameter specified but not used in flow: _APT_CONFIG_FILE
##W TCOS 000049 16:52:18(001) <main_program> Parameter specified but not used in flow: _SeqFilePath
##W TCOS 000049 16:52:18(002) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000000 16:52:19(000) <Sequential_File_0,0> Field "UPDATE_DATE" has import error and no default value; data: {0 3 / 2 1 / 1 9 9 9}, at offset: 265
##W TOIX 000154 16:52:19(001) <Sequential_File_0,0> Import warning at record 0:
##W TOIX 000018 16:52:19(002) <Sequential_File_0,0> Import unsuccessful at record 0:
##W TOIX 000000 16:52:19(003) <Sequential_File_0,0> Field "UPDATE_DATE" has import error and no default value; data: {0 5 / 1 7 / 1 9 9 6}, at offset: 267
##W TOIX 000154 16:52:19(004) <Sequential_File_0,0> Import warning at record 1:
##W TOIX 000018 16:52:19(005) <Sequential_File_0,0> Import unsuccessful at record 1:
##W TOIX 000000 16:52:19(006) <Sequential_File_0,0> Field "UPDATE_DATE" has import error and no default value; data: {1 1 / 1 2 / 1 9 9 1}, at offset: 266
##W TOIX 000154 16:52:19(007) <Sequential_File_0,0> Import warning at record 2:
##W TOIX 000018 16:52:19(008) <Sequential_File_0,0> Import unsuccessful at record 2:
##W TOIX 000000 16:52:19(009) <Sequential_File_0,0> Field "UPDATE_DATE" has import error and no default value; data: {0 5 / 1 0 / 1 9 9 3}, at offset: 265
##W TOIX 000154 16:52:19(010) <Sequential_File_0,0> Import warning at record 3:
##W TOIX 000018 16:52:19(011) <Sequential_File_0,0> Import unsuccessful at record 3:
##W TOIX 000000 16:52:19(012) <Sequential_File_0,0> Field "UPDATE_DATE" has import error and no default value; data: {1 0 / 3 1 / 1 9 9 0}, at offset: 267
##W TOIX 000154 16:52:19(013) <Sequential_File_0,0> Import warning at record 4:
##W TOIX 000018 16:52:19(014) <Sequential_File_0,0> Import unsuccessful at record 4:
##I TOIX 000157 16:52:19(015) <Sequential_File_0,0> (no further reports will be generated from this partition until successful import)
##I TOIX 000156 16:52:19(016) <Sequential_File_0,0> Progress: 10 percent
##I TOIX 000156 16:52:19(017) <Sequential_File_0,0> Progress: 20 percent
##I TOIX 000156 16:52:19(018) <Sequential_File_0,0> Progress: 30 percent
##I TOIX 000156 16:52:19(019) <Sequential_File_0,0> Progress: 40 percent
##I TOIX 000156 16:52:19(020) <Sequential_File_0,0> Progress: 50 percent
##I TOIX 000156 16:52:19(021) <Sequential_File_0,0> Progress: 60 percent
##I TOIX 000156 16:52:19(022) <Sequential_File_0,0> Progress: 70 percent
##I TOIX 000156 16:52:19(023) <Sequential_File_0,0> Progress: 80 percent
##I TOIX 000156 16:52:19(024) <Sequential_File_0,0> Progress: 90 percent
##I TOIX 000163 16:52:19(025) <Sequential_File_0,0> Import complete. 0 records imported successfully, 27768 rejected.
**VIEWDATA ROW LIMITER HIT**
What seems to be the problem ?, What am I doin wrong with the parameter ??
Sequential file load problem
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Metadata specified does not match to the given file layout. Check for UPDATE_DATE, for which it is complaining about. It has the values in the pattern of mm/dd/yyyy. What is the data type that been specified?
If you cannot nail down, change it to varchar and view the data.
If you cannot nail down, change it to varchar and view the data.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: