Errors while loading the sequential files to sql server
Moderators: chulett, rschirm, roy
Errors while loading the sequential files to sql server
Hi Folks
Please help us resolving the following issue.
We are getting errors while loading the sequential files to sql server
Source:
Sequential File varying columns hold 3 different types of metadata. Delimiter is a Pipe. We are getting warning messages on particular records. We created a reject link to store rejected data.
The errors from the Director Log. Import warnings at record. The following is the warning
Import error at record and no default value. data <empty>
Field011 has import error and has no default value.
In addition to that we tried to put the default values for all null fields.
We are able to view the data in the file at the squential source stage but when we run the job it aborts due to the above errors.
Thanks in advance.
Please help us resolving the following issue.
We are getting errors while loading the sequential files to sql server
Source:
Sequential File varying columns hold 3 different types of metadata. Delimiter is a Pipe. We are getting warning messages on particular records. We created a reject link to store rejected data.
The errors from the Director Log. Import warnings at record. The following is the warning
Import error at record and no default value. data <empty>
Field011 has import error and has no default value.
In addition to that we tried to put the default values for all null fields.
We are able to view the data in the file at the squential source stage but when we run the job it aborts due to the above errors.
Thanks in advance.
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
import error
check weather there are '|' in the record.make sure your record dont have any'|' with in the record excluding the delimiters
Re: import error
Can you explain more about how to search the delimiter in the record?pukars4u wrote:check weather there are '|' in the record.make sure your record dont have any'|' with in the record excluding the delimiters
The file has pipe delimited records and there are no header columns.
Thanks.
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Delimiter for field "LAST_ACTV_SIGNON_ID" not found; input: {0d}, atsamsuf2002 wrote:what is the log u r getting for this error ? what u mentioned above is a warning .is ur job getting aborted or just rejecting some records
offset: 100
Field "DUPL_CHECK_DUR_HRS" has import error and no default value: data <empty>, at offset: 285
These are the errors/warning we are getting at job gets aborted.
Pls. try to helpo me figure out this errors.
Thanks.
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
it shows that u have a pipe in ur data which is taken as delimiter by datastage creating a new column which doesnot exist ....u need need to figure out which field has data which contain pipe .......what i wud do is create a small job seq file1----Transformer-----seqfile2 and put a seqfile3 to seqfile1 as a reject link where u can capture the bad records and analyse it.....
hi sam here