DSXchange

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.

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

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

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

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.

which column is it giving the error on . i am sure you got some warnings etc before this ?

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.