error in viewing the data

harithay · Post by **harithay** » Fri May 13, 2005 10:55 am

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**

T42 · Post by **T42** » Fri May 13, 2005 11:09 am

You will need to explicitly define the format for the date field. Default is YYYY-MM-DD, with the hyphens.

harithay · Post by **harithay** » Fri May 13, 2005 12:19 pm

Hi all,.

thanks T42 for your reply.
my target database is sqlserver
i need to generate sysdate in the output in the form of

yyyy-mm-dd 00:00:00.000 . ( data type is timestamp in sqlserver)

i am not using Basic tarnsformer in paralle jobs. how can i approach for this problem.

bcarlson · Post by **bcarlson** » Mon May 16, 2005 11:49 am

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