Hi all,
my source is sequential file stage, when i want view the data using sequntial file stage data browser, it is giving folloing error,
cal anyone let me know
#I TUTL 000031 12:52:04(001) <main_program> The open files limit is 100; raising to 4096.
##I TOSH 000002 12:52:05(000) <main_program> orchgeneral: loaded
##I TOSH 000002 12:52:05(001) <main_program> orchsort: loaded
##I TOSH 000002 12:52:05(002) <main_program> orchstats: loaded
##I TFSC 000001 12:52:05(003) <main_program> APT configuration file: /detld1/etl/ascential/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 12:52:06(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000000 12:52:09(000) <Nsarseqfile,0> Field "DATE" has import error and no default value; data: {0 6 / 3 0 / 2 0 0 4}, at offset: 52
##W TOIX 000154 12:52:09(001) <Nsarseqfile,0> Import warning at record 0.
##W TOIX 000018 12:52:09(002) <Nsarseqfile,0> Import unsuccessful at record 0.
##W TOIX 000000 12:52:09(003) <Nsarseqfile,0> Field "DATE" has import error and no default value; data: {1 2 / 3 1 / 2 0 0 3}, at offset: 52
##W TOIX 000154 12:52:09(004) <Nsarseqfile,0> Import warning at record 1.
##W TOIX 000018 12:52:09(005) <Nsarseqfile,0> Import unsuccessful at record 1.
##W TOIX 000000 12:52:09(006) <Nsarseqfile,0> Field "DATE" has import error and no default value; data: {1 2 / 3 1 / 2 0 0 4}, at offset: 52
##W TOIX 000154 12:52:09(007) <Nsarseqfile,0> Import warning at record 2.
##W TOIX 000018 12:52:09(008) <Nsarseqfile,0> Import unsuccessful at record 2.
##W TOIX 000000 12:52:09(009) <Nsarseqfile,0> Field "DATE" has import error and no default value; data: {0 4 / 3 0 / 2 0 0 4}, at offset: 68
##W TOIX 000154 12:52:09(010) <Nsarseqfile,0> Import warning at record 3.
##W TOIX 000018 12:52:09(011) <Nsarseqfile,0> Import unsuccessful at record 3.
##W TOIX 000000 12:52:09(012) <Nsarseqfile,0> Field "DATE" has import error and no default value; data: {0 9 / 3 0 / 2 0 0 4}, at offset: 50
##W TOIX 000154 12:52:09(013) <Nsarseqfile,0> Import warning at record 4.
##W TOIX 000018 12:52:09(014) <Nsarseqfile,0> Import unsuccessful at record 4.
##I TOIX 000193 12:52:09(015) <Nsarseqfile,0> No further reports will be generated from this partition until a successful import.
##I TOIX 000156 12:52:09(016) <Nsarseqfile,0> Progress: 10 percent.
##I TOIX 000156 12:52:10(000) <Nsarseqfile,0> Progress: 20 percent.
##I TOIX 000156 12:52:10(001) <Nsarseqfile,0> Progress: 30 percent.
##I TOIX 000156 12:52:10(002) <Nsarseqfile,0> Progress: 40 percent.
##I TOIX 000156 12:52:10(003) <Nsarseqfile,0> Progress: 50 percent.
##I TOIX 000156 12:52:10(004) <Nsarseqfile,0> Progress: 60 percent.
##I TOIX 000156 12:52:10(005) <Nsarseqfile,0> Progress: 70 percent.
##I TOIX 000156 12:52:10(006) <Nsarseqfile,0> Progress: 80 percent.
##I TOIX 000156 12:52:10(007) <Nsarseqfile,0> Progress: 90 percent.
##I TOIX 000163 12:52:10(008) <Nsarseqfile,0> Import complete; 0 records imported successfully, 26159 rejected.
**VIEWDATA ROW LIMITER HIT**
error in viewing the data
Moderators: chulett, rschirm, roy
Check your import schema. The messages you are getting are the same as those you would get if there was a problem with your Sequential File Stage import during processing. The browser has to import the data, too.
In your schema, make sure you define the format of the data coming in (in the Edit Column Meta Data window). If the format is yyyy-mm-dd, then use the default format (%yyyy-%mm-%dd). In your case, it looks like the format is mm/dd/yyyy so the format string is "%mm/%dd/%yyyy".
bcarlson
In your schema, make sure you define the format of the data coming in (in the Edit Column Meta Data window). If the format is yyyy-mm-dd, then use the default format (%yyyy-%mm-%dd). In your case, it looks like the format is mm/dd/yyyy so the format string is "%mm/%dd/%yyyy".
bcarlson