Poster: ORA-01458: invalid length inside variable character string. 处理一例
来源:互联网 发布:淘宝卖家店铺中分类 编辑:程序博客网 时间:2024/05/20 09:10
产品环境,shareplex复制报错,查看log:
Info 2014-12-08 09:48:00.565477 8102 499754752 Poster exited with code=1, pid = 28650 (posting from aaaaa_splex, queue aaaa_bbbb, to bbbb_splex)
Error 2014-12-08 09:48:00.540231 28650 1879045888 s:2 Poster: Unexpected Oracle error: ORA-01458: invalid length inside variable character string. (object name: "AAA"."AAAAAAAAAAAAAAAAAAA") (posting from aaaaa_splex, queue aaaa_bbbb, to bbbb_splex) [module opo]
Notice 2014-12-08 09:48:00.537308 28650 1879045888 s:2 Poster: ORA-01458: invalid length inside variable character string. (posting from aaaaa_splex, queue aaaa_bbbb, to bbbb_splex) [module osp]
查看两边的表结构,一致。
处理方法:
1. source端,查询AAAAAAA的object_id,比如:111111
2. post端,
set param sp_opo_disable_object_num 111111
stop post
start post
===正常之后
reset param SP_OPO_DISABLE_OBJECT_NUM
stop post
start post
丢的数据,到log目录下面能找到。里面有详细信息。
- Poster: ORA-01458: invalid length inside variable character string. 处理一例
- ORA-01483: invalid length for DATE or NUMBER bind variable
- ORA-01483: invalid length for DATE or NUMBER bind variable
- ORA-00911: invalid character 的问题处理
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character
- ORA-00911: invalid character错误
- String contains an invalid character
- Uncaught RangeError: Invalid string length
- ORA-00911: invalid character的解决办法
- SQL EXCEPTION ORA-00911: invalid character
- ORA-00911: invalid character的解决办法
- java.sql.SQLException: ORA-00911: invalid character
- java.sql.SQLException: ORA-00911: invalid character
- ORA-00911: invalid character问题解决办法
- Android 5.0学习之ListView升级版RecyclerView
- 设置 Ubuntu DNS 缓存
- Android 5.0学习之Activity过渡动画
- 神经网络模型分类
- 合并两个有序列表
- Poster: ORA-01458: invalid length inside variable character string. 处理一例
- FTP文件传输协议
- 设计模式-享元模式
- Android 5.0学习之定义阴影
- Android 5.0学习之动画
- struts2实现上传文件时遇到的若干问题
- Android 5.0学习之Tinting和Clipping
- 学习android从零开始(20)(自定义控件)
- android笔记20-数据存储之sharedPreference