查看外网ogg端,发现有异常。 OGG-01163 Bad column length (xxx) specified for column AAA in table OWNER.TABLE, maximum allowable length is yyy. 随即想起了前天给表的某字段修改了字段长度,varchar2(300) 修改成了 varchar2(1000)。 当时并没意识到ogg会出问题,查看了资料,可以归因于修改字段的时候,由于...
OGG-01163Badcolumnlength (65535) specifiedforcolumnXBintableOWNER.TABLE, maximum allowable lengthis. 产生原因: 因源端与目标端分区表名称不一致导致。 解决办法: 源端: 在dirdef目录下新建一个zz.def文件 cd /oracle/ogg/dirdef vi cjsqxx.prm defsfile/oracle/ogg/dirdef/zz.def,purge userid ogguser,...
Log Read Checkpoint File/ogg/dirdat/by0000031052020-11-1300:57:56.003931RBA14279905 ERROR OGG-01163 Bad column length (38) specified for column C_NAME in table O.O, maximum allowable length is 32. 目标端C_NAME VARCHAR2(256) 源端C_NAME VARCHAR2(256) 数据库字符集相同,不存在转换问题! 使用...
监控告警有一个OGG源端的投递(EXTRACT)进程挂起,尝试直接start无法启动。view report查看报错信息为OGG-01163 Bad column length(65536) specified for column XXXX in table XX.xxxx ,maximum allowable length is 2. 问题分析 这个报错之前也遇到过,不过都是在目标端复制(REPLICA)进程出现的报错,原因是源目标端表...
2018-02-23 21:28:36 ERROR OGG-01163 Oracle GoldenGate Delivery for Oracle, rlis.prm: Bad column length (21) specified for column BATCHNO in table LISBASE.LCSIGNLIST, maximum allowable length is 20. 故障分析: 经询问得知,因应用产生超过现有字段长度的数据,应用运维人员在未知会DBA的情况下直接修...
变更源端表结构后,目标端ogg告警。 2019-04-15 12:48:47 ERROR OGG-01163 Bad column length (21) specified for column CHANNEL_CODE in table MCS.T_MCS_REPAY_ORD_INF, maximum allowable length is 15. 将复制进程中参数注掉后: –ASSUMETARGETDEFS ...
140727.2135.1_FBO Linux, x64, 64bit (optimized), Oracle 11g onAug 7 2014 09:38:29 2015-08-19 17:47:34 ERROR OGG-01163 Bad columnlength (8) specified for column STATUS_ID in table <SCHEMA>.<TABLE>, maximum allowable length is 4. Cause Sign In To view full details, sign...
2016-12-08 00:32:29 ERROR OGG-01163 Bad column length (3) specified for column SCEN_RSTRCD_PREAPRVL_YN in table MORTMGR.SCENARIOS, maximum allowable length is 1.CauseSign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support...
Using the following key columns for target table GGS.T_EMP. 2018-07-29 10:15:56 ERROROGG-01163Oracle GoldenGateDelivery forOracle,reprpt01.prm: Bad column length (21) specified for column BANK in table CU.T_EMP, maximum allowable length is 20. 2018-07-29 10:15:56 ERROR OGG-01668Orac...
监控告警有一个OGG源端的投递(EXTRACT)进程挂起,尝试直接start无法启动。view report查看报错信息为OGG-01163 Bad column length(65536) specified for column XXXX in table XX.xxxx ,maximum allowable length is 2. 问题分析 这个报错之前也遇到过,不过都是在目标端复制(REPLICA)进程出现的报错,原因是源目标端表...