we have OGG12.2.01.1 on ms-sql 2012 . every day at midnight is abending with the below error . I stopped backup and all DB schedule jobs at the same time but not succsed . any one have idea
GGSCI > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT RUNNING
EXTRACT RUNNING CCBEXT1 00:00:00 00:00:05
EXTRACT ABEND PCCBEXT1 00:00:00 00:00:02
REPLICAT RUNNING CCBSA01 00:00:00 00:00:04
2018-07-29 00:03:03 ERROR OGG-05210 Oracle GoldenGate Capture for SQL Server, CCBEXT1.prm: mssqlvam::OnlineLogInfo::GetLogStartLsn: A query to SQL Server has failed: set nocount on
declare @cols table(id int identity, name sysname, type sysname, introduced int);
declare @cmd nvarchar(4000),
@cmd2 nvarchar(1000)
set @cmd = N''
insert into @cols (name, type, introduced) values (N'Current LSN', 'char(22)', 0)
insert into @cols (name, type, introduced) values (N'Operation', 'char (25)', 0)
insert into @cols (name, type, introduced) values (N'Context', 'char (25)', 0)
insert into @cols (name, type, introduced) values (N'Transaction ID', 'char(13)', 0)
insert into @cols (name, type, introduced) values (N'LogBlockGeneration', 'int null', 655)
insert into @cols (name, type, introduced) values (N'Tag Bits', 'binary(2)', 0)
insert into @cols (name, type, introduced) values (N'Log Record Length', 'int', 0)
insert into @cols (name, type, introduced) values (N'Log Record Fixed Length', 'int null', 611)
insert into @cols (name, type, introduced) values (N'Previous LSN', 'char(22) null', 0)
insert into @cols (name, type, introduced) values (N'Flag Bits', 'binary(2) null', 0)
insert into @cols (name, type, introduced) values (N'Log Reserve', 'int null', 655)
insert into @cols (name, type, introduced) values (N'Description', 'varchar(255) null', 0)
select @cmd = @cmd + case when N'' = @cmd then N'(' else ', ' end + N'[' + C1.name + '] ' + C1.type
from @cols C1
where introduced <= DATABASEPROPERTY(db_name(), 'version')
order by id
set @cmd2 = 'insert into #logrecs exec (''dbcc log([' + db_name()+ '], 1, ''''numrecs'''', 1)'')'
select @cmd = 'create table #logrecs' + @cmd + N') ' + @cmd2 + 'select [Current LSN] from #logrecs'
exec (@cmd)
: Error (-2147217871): Query timeout expired.
2018-07-29 00:03:43 INFO OGG-00178 Oracle GoldenGate Capture for SQL Server, CCBEXT1.prm: VAM Client Report <Last LSN Read: 0001993f:0000a870:0001
No open transactions>.
2018-07-29 00:03:43 INFO OGG-00178 Oracle GoldenGate Capture for SQL Server, CCBEXT1.prm: VAM Client Report <Sanity checking is not enabled.
>.
2018-07-29 00:03:43 ERROR OGG-01668 Oracle GoldenGate Capture for SQL Server, CCBEXT1.prm: PROCESS ABENDING.
2018-07-29 07:07:35 INFO OGG-00987 Oracle GoldenGate Command Interpreter for SQL Server: GGSCI command (sqlsrvsdb1): info all.
2018-07-29 07:07:46 INFO OGG-00987 Oracle GoldenGate Command Interpreter for SQL Server: GGSCI command (sqlsrvsdb1): start CCBEXT1.
2018-07-29 07:07:47 INFO OGG-00963 Oracle GoldenGate Manager for SQL Server, mgr.prm: Command received from GGSCI on host [FE80::4DE6:5C22:CDFF:A26D]:62472 (START EXTRACT CCBEXT1 ).
2018-07-29 07:07:47 INFO OGG-00960 Oracle GoldenGate Manager for SQL Server, mgr.prm: Access granted (rule #1).
2018-07-29 07:07:47 INFO OGG-00975 Oracle GoldenGate Manager for SQL Server, mgr.prm: EXTRACT CCBEXT1 starting.