暂无图片
ogg 12.1.2版本,启动捕获进程提示“Column name or number of supplied values does not match table definition”
我来答
分享
Psql
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.
我来答
添加附件
收藏
分享
问题补充
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏