data length problem

hellboy · Post by **hellboy** » Thu Feb 04, 2010 7:37 am

hi friends,

i have a parallel job in which for a given column target data length is less then the source data length, both the column are of varchar type. when i am running the job the job is getting aborted ... with error...

sqlcode is: -12899
esql complaint: ORA-12899: value too large for column

i suppose it should not be the scenario.here only the record which is greater then the size should get rejected but the job should finish successfully.

Please look and advice me .. wht should to do make the job rejecting records not to get aborted.

nagarjuna · Post by **nagarjuna** » Thu Feb 04, 2010 8:24 am

Check the datatypes in the control file ( .cntl ) and see if it is same as that of the data you are receiving ...

chulett · Post by **chulett** » Thu Feb 04, 2010 9:50 am

If the source data is larger than the target column size, you should handle that in the job, either by logically rejecting it via a size check or substringing the data to fit. Oracle will abort if you don't, as you've seen.

hellboy · Post by **hellboy** » Thu Feb 04, 2010 10:37 pm

but the scene is , why the job is getting aborted ?
because in other cases like ora 1403 error of having duplicates on key or ora 1400 null insert error in keys job finishes smoothly without any aborts , why its happening in this case.

friends its a strange way of dealing data by Data Stage or may be i am wrong.

please suggest me to complete the job without the aborts.

i will be thankful to you friends.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 04, 2010 10:58 pm

CHECK the data before you send it to Oracle.

As you have already been advised.

If you don't send erroneous data, then the server will have nothing to complain about.

In my opinion, jobs should abort if there is an unresolvable data anomaly.

chulett · Post by **chulett** » Thu Feb 04, 2010 11:34 pm

hellboy wrote:friends its a strange way of dealing data by Data Stage or may be i am wrong. please suggest me to complete the job without the aborts.

You are... and I already did.

hellboy · Post by **hellboy** » Fri Feb 05, 2010 12:18 am

any way i am not the premium member so i can't see the full suggestion given by you...

thanks for the help provided...

ray.wurlod · Post by **ray.wurlod** » Fri Feb 05, 2010 5:39 am

hellboy wrote:any way i am not the premium member.

That, at least, is easily fixed.

chulett · Post by **chulett** » Fri Feb 05, 2010 9:05 am

hellboy wrote:any way i am not the premium member so i can't see the full suggestion given by you...

You have seen the full suggestion, all you missed were a handful of words unrelated to the actual solution so I've unmarked it.

Regardless, seriously consider a premium membership, there's way too much help and useful information here to not take full advantage of and to help support this site.