DSG error ORA-01438

shibm1$[/dsgcrm]mon_dt.sh
======================================================================================================================================================
Monitor Loader
==============
/dsgcrm/fold1
-------------
Loader_Real:0   |Receivednum:2681840|Loadednum:2681840|NoLoadnum:0      |DelayTime:-15(s)|Errnum:0      |DsTime:2016-04-26:08:13:53     |MapDelaynum:Unknown
Loader_Real:1   |Receivednum:17719925|Loadednum:17719925|NoLoadnum:0    |DelayTime:-14(s)|Errnum:0      |DsTime:2016-04-26:08:13:53     |MapDelaynum:Unknown
Loader_Real:2   |Receivednum:16378251|Loadednum:16378251|NoLoadnum:0    |DelayTime:-14(s)|Errnum:0      |DsTime:2016-04-26:08:13:53     |MapDelaynum:Unknown
Loader_Real:3   |Receivednum:15308663|Loadednum:15308661|NoLoadnum:2    |DelayTime:-12(s)|Errnum:0      |DsTime:2016-04-26:08:13:44     |MapDelaynum:Unknown
Loader_Real:4   |Receivednum:16411281|Loadednum:16411281|NoLoadnum:0    |DelayTime:-15(s)|Errnum:0      |DsTime:2016-04-26:08:13:53     |MapDelaynum:Unknown
not real
--------------------------------------------------------------------------------
/dsgcrm/fold2
-------------
Loader_Real:0   |Receivednum:106934|Loadednum:106934|NoLoadnum:0        |DelayTime:-11(s)|Errnum:0      |DsTime:2016-04-26:08:11:23     |MapDelaynum:Unknown
Loader_Real:1   |Receivednum:14307467|Loadednum:14307466|NoLoadnum:1    |DelayTime:-12(s)|Errnum:0      |DsTime:2016-04-26:08:13:54     |MapDelaynum:Unknown
Loader_Real:2   |Receivednum:17975596|Loadednum:17975594|NoLoadnum:2    |DelayTime:-15(s)|Errnum:0      |DsTime:2016-04-26:08:13:53     |MapDelaynum:Unknown
Loader_Real:3   |Receivednum:13022937|Loadednum:13022935|NoLoadnum:2    |DelayTime:-15(s)|Errnum:0      |DsTime:2016-04-26:08:13:53     |MapDelaynum:Unknown
Loader_Real:4   |Receivednum:17391833|Loadednum:17391831|NoLoadnum:2    |DelayTime:-15(s)|Errnum:0      |DsTime:2016-04-26:08:13:53     |MapDelaynum:Unknown
--------------------------------------------------------------------------------
/dsgcrm/fold3
-------------
Loader_Real:0   |Receivednum:9378763|Loadednum:9375637|NoLoadnum:3126   |DelayTime:Unknown(s)|Errnum:6  |DsTime:Unknown |MapDelaynum:Unknown
--------------------------------------------------------------------------------
======================================================================================================================================================
Monitor Dt_Vagentd
==================
Dt_Vagentd:/dsgcrm/fold1        |CurrentTime:2016-04-26:08:13:42|ReceiveLastTime:2016-04-26:08:13:37    |Errnum:0       |NoReceiveTime:5(s)
Dt_Vagentd:/dsgcrm/fold2        |CurrentTime:2016-04-26:08:13:42|ReceiveLastTime:2016-04-26:08:13:41    |Errnum:0       |NoReceiveTime:1(s)
Dt_Vagentd:/dsgcrm/fold3        |CurrentTime:2016-04-26:08:13:42|ReceiveLastTime:2016-04-26:08:13:40    |Errnum:0       |NoReceiveTime:2(s)
===================================================================================================================================================

shibm1$[/dsgcrm/fold3/log]tail -f log.r0
                       0001 31                                 ..1
      COL_034 [   20]: 0012 3233 3031 3033-3139 3531 3130 3130 ..23010319511010
                       3039 3433                               0943
      COL_035 [    2]: 0000                                    ..
      COL_036 [    8]: 0006 CEB4 CCEE D0B4                     ........
      COL_037 [   14]: 000C 3034 3531 3832-3630 3937 3631      ..045182609761
      COL_038 [   35]: 0021 C4CF B8DA C7F8-CEC4 D6D0 BDD6 3139 .!............19
                       2D31 BAC5 34B5 A5D4-AA37 C2A5 31BA C5B7 -1..4....7..1...
                       BFBC E4                                 ...
      COL_039 [    6]: 0004 3034 3531                          ..0451
      COL_040 [    8]: 0006 3937 3432 3134                     ..974214
      COL_041 [    6]: 0004 5054 4448                          ..PTDH
      COL_042 [    7]: 0005 C41F 0102 2E                       .......
      COL_043 [    3]: 0001 4C                                 ..L

OCI Error -1 occurred at File xf1_to_oracle_upd_rid.c:1177.
ORA-01438: value larger than specified precision allowed for this column

OCI Error -1 occurred at File xf1_to_oracle_upd_rid.c:1177.
ORA-01438: value larger than specified precision allowed for this column
Error to execute SQL statement:
UPDATE  "UCR_CRM1"."TF_F_CUST_VIP" partition (PAR_TF_F_CUST_VIP_4) SET "CUST_ID"=:1,"USECUST_ID"=:2,"NET_TYPE_CODE"=:3,"CUST_NAME"=:4,"USECUST_NAME"=:5,"USEPSPT_TYPE_CODE"=:6,"USEPSPT_ID"=:7,"USEPSPT_END_DATE"=:8,"USEPSPT_ADDR"=:9,"USEPHONE"=:10,"USEPOST_ADDR"=:11,"EPARCHY_CODE"=:12,"CITY_CODE"=:13,"BRAND_CODE"=:14,"PRODUCT_ID"=:15,"USER_TYPE_CODE"=:16,"USER_STATE_CODESET"=:17,"OPEN_DATE"=:18,"OPEN_MODE"=:19,"OPEN_DEPART_ID"=:20,"OPEN_STAFF_ID"=:21,"IN_DATE"=:22,"IN_NET_MODE"=:23,"IN_DEPART_ID"=:24,"IN_STAFF_ID"=:25,"DEVELOP_DATE"=:26,"DEVELOP_EPARCHY_CODE"=:27,"DEVELOP_CITY_CODE"=:28,"DEVELOP_STAFF_ID"=:29,"DEVELOP_DEPART_ID"=:30,"FIRST_CALL_TIME"=:31,"LAST_STOP_TIME"=:32,"SCORE_VALUE"=:33,"CREDIT_CLASS"=:34,"BASIC_CREDIT_VALUE"=:35,"CREDIT_VALUE"=:36,"CREDIT_TRADE_TAG"=:37,"RSRV_NUM1"=:38,"RSRV_STR2"=:39,"RSRV_DATE2"=:40,"RSRV_DATE5"=:41,"RSRV_TAG1"=:42,"RSRV_TAG2"=:43 WHERE ROWID=:44 RETURNING ROWID INTO :45
        Error occurs at "33,"CREDIT_CLASS"=:34,"BASIC_C..."
ERROR rowid:  AAGoYnAElAAC1pLAAF (001A8627.494B5A4B.0005)

        : 0001022C.001A8627.494B5A4B.0005 B5(URP)  --H-FL-- cc:43/141 len:6965
483 transactions rollbacked (oci: 1438)
(UCR_CRM1.TF_F_CUST_VIP -> UCR_CRM1.TF_F_CUST_VIP) OCI Error -1 occurred at File xf1_to_oracle_upd_rid.c:1177.
ORA-01438: value larger than specified precision allowed for this column
fail to process /dsgcrm/fold3/rmp/real0/9375637.xf1 xf1_to_oracle.c:5553, retry it.fail to process /dsgcrm/fold3/rmp/real0/9375637.xf1 xf1_to_oracle.c:5553, retry it.


解决办法 删除有问题的记录
shibm1$[/dsgcrm/fold3/rmp]../bin/xfview -delrowid 0x001A8627 0x494B5A4B 0x0005  real0/9375637.xf1

之后查看
======================================================================================================================================================
Monitor Loader
==============
/dsgcrm/fold1
-------------
Loader_Real:0   |Receivednum:2686456|Loadednum:2686456|NoLoadnum:0      |DelayTime:-11(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
Loader_Real:1   |Receivednum:17727934|Loadednum:17727934|NoLoadnum:0    |DelayTime:-10(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
Loader_Real:2   |Receivednum:16386180|Loadednum:16386180|NoLoadnum:0    |DelayTime:-11(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
Loader_Real:3   |Receivednum:15316470|Loadednum:15316470|NoLoadnum:0    |DelayTime:-11(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
Loader_Real:4   |Receivednum:16419265|Loadednum:16419265|NoLoadnum:0    |DelayTime:-10(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
not real
--------------------------------------------------------------------------------
/dsgcrm/fold2
-------------
Loader_Real:0   |Receivednum:107006|Loadednum:107006|NoLoadnum:0        |DelayTime:-17(s)|Errnum:0      |DsTime:2016-04-26:14:37:03     |MapDelaynum:Unknown
Loader_Real:1   |Receivednum:14315433|Loadednum:14315433|NoLoadnum:0    |DelayTime:-11(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
Loader_Real:2   |Receivednum:17983652|Loadednum:17983652|NoLoadnum:0    |DelayTime:-10(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
Loader_Real:3   |Receivednum:13030753|Loadednum:13030753|NoLoadnum:0    |DelayTime:-11(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
Loader_Real:4   |Receivednum:17399689|Loadednum:17399689|NoLoadnum:0    |DelayTime:-11(s)|Errnum:0      |DsTime:2016-04-26:15:01:46     |MapDelaynum:Unknown
--------------------------------------------------------------------------------
/dsgcrm/fold3
-------------
Loader_Real:0   |Receivednum:9386976|Loadednum:9376402|NoLoadnum:10574  |DelayTime:31560(s)|Errnum:0    |DsTime:2016-04-26:06:15:38     |MapDelaynum:Unknown
--------------------------------------------------------------------------------
======================================================================================================================================================
Monitor Dt_Vagentd
==================
Dt_Vagentd:/dsgcrm/fold1        |CurrentTime:2016-04-26:15:01:39|ReceiveLastTime:2016-04-26:15:01:34    |Errnum:0       |NoReceiveTime:5(s)
Dt_Vagentd:/dsgcrm/fold2        |CurrentTime:2016-04-26:15:01:39|ReceiveLastTime:2016-04-26:15:01:34    |Errnum:0       |NoReceiveTime:5(s)
Dt_Vagentd:/dsgcrm/fold3        |CurrentTime:2016-04-26:15:01:39|ReceiveLastTime:2016-04-26:15:01:38    |Errnum:0       |NoReceiveTime:1(s)
======================================================================================================================================================

shibm1$[/dsgcrm/fold3/log]tail -f log.r0

Loader: 9376437.xf1  2016-04-26:15:02:09: (commit) SCN 0xd8de295.f4f30001, Time 2016-04-26 06:17:30
2016-04-26:15:02:09: 3-I 0-D 1283-U 0-DDL(693 ms) (31479 s)

Loader: 9376438.xf1  2016-04-26:15:02:11: (commit) SCN 0xd8de296.03e10001, Time 2016-04-26 06:17:33
2016-04-26:15:02:11: 0-I 0-D 2445-U 0-DDL(1365 ms) (31478 s)

Loader: 9376439.xf1  2016-04-26:15:02:11: (commit) SCN 0xd8de296.09ca0001, Time 2016-04-26 06:17:34
2016-04-26:15:02:11: 4-I 0-D 786-U 0-DDL(579 ms) (31477 s)

Loader: 9376440.xf1  2016-04-26:15:02:12: (commit) SCN 0xd8de296.1bb00001, Time 2016-04-26 06:17:39
2016-04-26:15:02:12: 2-I 0-D 1096-U 0-DDL(1080 ms) (31473 s)

Loader: 9376441.xf1  2016-04-26:15:02:13: (commit) SCN 0xd8de296.2b3c0001, Time 2016-04-26 06:17:43

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26179376/viewspace-2088608/，如需转载，请注明出处，否则将追究法律责任。