Hi Fellas,
I'm loading data from a oracle table to a sequential file(Job1).The job is running fine with no indication of errors or warnings in the log.I use this sequential file to load to another table(Job2).
Now the scenario is like this.
When I tried to view the data from the job 1, I get the following messages.
1. read_delimited() - invalid quotes
2. read_delimited() -required column missing
I'm not able to get rid of this.
When I run the Job 2, Sequential file (from Job1) into a table,the job is getting aborted with the following message.
read_delimited() - invalid quotes, row 204
So, Unless I fix the issue in job1,my job 2 cannot be go for a successful run.Please throw your opnions on this issue.
Regards,
VG.
read_delimited()
Moderators: chulett, rschirm, roy
Make sure your Sequential stage in the OCI-->SEQ job is setup to honor quotes if your delimiter is in the data. If not, don't use quotes in the setup. If so, you then need to make sure your data does contain quotes that will foul up the detection of column separation. In addition, data containing low/hi ASCII values and embedded <CR>/<LF> values will also need to be honored in the configuration of the SEQ stage.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Looks like some records contains terminators(as Ken mentioned ASCII characters) to me. Identify which column's data contains these termintators and then, in the Sequential file stage, go to the Columns tab and set the attribute " Contains Terminators" to Yes for that column. Hopefully, that should take care of your error.
The columns which might contain the terminators in most cases would be of datatype Varchar(in my experience). I hope that gives a good start.
The columns which might contain the terminators in most cases would be of datatype Varchar(in my experience). I hope that gives a good start.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Participant
- Posts: 76
- Joined: Wed Jan 25, 2006 6:42 pm
I just happened to see one of the discussions posted on this issue.It was suggested,"The best way to handle it , is to go to the column tab in the sequential file stage, and set the 'Contains Terminators' of the last row to Yes. "
Now I just ran the job with the said modifications and is running.This job is multiple instance job as the source has 0.45 Billion records, So I decided to chunk the data.
Thanks a lot for your opinions.Your thoughts valued a lot to me.......
Rgds,
VG.
Now I just ran the job with the said modifications and is running.This job is multiple instance job as the source has 0.45 Billion records, So I decided to chunk the data.
Thanks a lot for your opinions.Your thoughts valued a lot to me.......
Rgds,
VG.
ETL
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio