2020-06-19
ogg 12.1.2版本,启动捕获进程提示“Column name or number of supplied values does not match table definition”
5M环境说明:
OGG版本:12.1.2
SQL SERVER :2012 sp2
配置模式:经典模式
在源端SQL SERVER数据库上部署 12.1.2版本ogg,配置完extract进程后,
extract进程参数内容:
EXTRACT extchc1
SETENV ( NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" )
sourcedb ss, userid ggs, password sgg
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL c:\sqlserverogg\dirdat\la
dynamicresolution
GETUPDATEBEFORES
GETTRUNCATES
--FETCHOPTIONS NOUSESNAPSHOT
NOCOMPRESSDELETES
EOFDELAYCSECS 10
table dbo.test_4;
启动后报错:
ERROR OGG-05210 Oracle GoldenGate Capture for SQL Server, EXTCHC1.prm: mssqlvam::OnlineLogInfo::SetVirtualLogInfos: A query to SQL Server has failed: set nocount on
truncate table #layout
insert into #layout exec (N'dbcc loginfo')
delete from #layout where seq = 0
select fileId,
size,
offset,
seq,
status,
parity
from #layout
where seq >= (select min(seq)
from #layout
where status = 2)
order by seq
: Error (-2147217900): Column name or number of supplied values does not match table definition.
ERROR OGG-01668 Oracle GoldenGate Capture for SQL Server, EXTCHC1.prm: PROCESS ABENDING.
我来答
添加附件
收藏
分享
问题补充
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

