ORA : 1438

vijay.barani · Post by **vijay.barani** » Wed Oct 22, 2008 12:58 am

Hi Friends,
I have been facing an error like
"ORA-01438: value larger than specified precision allowed for this column"
when running a particular job.I had checked with the data size and found nothing wrong in that.
Could anyone please help me regarding this issue.

Thanks,
Vijay.

hamzaqk · Post by **hamzaqk** » Wed Oct 22, 2008 2:35 am

Can only tell if i had some sample rows and what metadata is defined in your oracle stage

vijay.barani · Post by **vijay.barani** » Wed Oct 22, 2008 6:19 am

hamzaqk wrote:Can only tell if i had some sample rows and what metadata is defined in your oracle stage

HI Hamzaqk,
Thank you for your responce.Please find the below details.

The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 6477 AC_STAT_SID = 14538 AC_SCHD_ST_SID
= 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20080401 AC_CUR_END_SID = 20090331 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 148411311.58 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0 AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT =

The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 6834 AC_STAT_SID = 14538 AC_SCHD_ST_SID = 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20070101 AC_CUR_END_SID = 20090531 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 0 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0
AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT = 0

The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 7589 AC_STAT_SID = 14538 AC_SCHD_ST_SID
= 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20070101 AC_CUR_END_SID = 20090531 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 0 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0
AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT = 0

The value of the row is: SRC_SYS_ID = FSCM SNAP_DT_SID = 20081022 AC_SID = 7615 AC_STAT_SID = 14538 AC_SCHD_ST_SID
= 19000101 AC_SCHD_END_SID = 19000101 AC_CUR_ST_SID = 20070101 AC_CUR_END_SID = 20090531 AC_ACT_ST_SID = 19000101
AC_ACT_END_SID = 19000101 AC_CMPLTD_PCT = 0 AC_ACT_AMT = 0 AC_ACT_R1_AMT = 0 AC_ACT_R2_AMT = 0 AC_BDGT_AMT = 0
AC_BDGT_R1_AMT = 0 AC_BDGT_R2_AMT = 0 AC_REV_AMT = 0 AC_REV_R1_AMT = 0 AC_REV_R2_AMT = 0 AC_RBNR_AMT = 0
AC_RBNR_R1_AMT = 0 AC_RBNR_R2_AMT = 0 AC_SR_AMT = 0

Column name SQL Type Length
----------- -------- ------
SRC_SYS_ID Char 5
SNAP_DT_SID Decimal 19
AC_SID Decimal 20
AC_STAT_SID Decimal 20
AC_SCHD_ST_SID Decimal 20
AC_SCHD_END_SID Decimal 20
AC_CUR_ST_SID Decimal 30
AC_CUR_END_SID Decimal 20
AC_ACT_ST_SID Decimal 20
AC_ACT_END_SID Decimal 20
AC_CMPLTD_PCT Decimal 20

chulett · Post by **chulett** » Wed Oct 22, 2008 8:11 am

You've posted in the wrong forum and thus we have no idea what job type this is. So... Parallel or Server job?

vijay.barani · Post by **vijay.barani** » Wed Oct 22, 2008 9:36 am

chulett wrote:You've posted in the wrong forum and thus we have no idea what job type this is. So... Parallel or Server job? ...

Sorry I had mistakenly entered in this forum.

I am working on Datastage 7.5.1 Server Edition. OS is Windows.

chulett · Post by **chulett** » Wed Oct 22, 2008 9:41 am

Moderator, please move to the Server forum.

hamzaqk · Post by **hamzaqk** » Wed Oct 22, 2008 11:46 pm

which column is it giving the error on

. i am sure you got some warnings etc before this ?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 23, 2008 3:04 pm

This forum is for "Forum for Master Data Management theory and Razza Dimension Server - a Master Data Management software application". Please don't encourage posting in the wrong place by answering.