Hi Team,
In my sql server golden gate, an extract process is always ABENDING and getting the below exception.
2018-10-16 01:34:17 ERROR OGG-05253 The SQL Server provider has thrown an exception. [mssqlcdcvam::MSSqlCDCCleanupMgr::Start] Invalid object name 'ogguser.OracleGGCleanupJobStatus'. Additional Info : Error (-2147217865): Invalid object name 'ogguser.OracleGGCleanupJobStatus'.
2018-10-16 01:34:17 ERROR OGG-01668 PROCESS ABENDING.
PS:
My database was fully enabled for CDC and recovery mode and all the tables also enabled for cdc & supplemental logging.
When i am trying to run the below .bat file to create missing job OracleGGCleanupJobStatus, its failing to create as following.
C:\Temp\GG>ogg_cdc_cleanup_setup.bat createJob oggsuser oggsuser1 xxxx DENxxNVX\MSSQL2016IDC ogguser
Oracle GoldenGate CDC cleanup job setup script
==============================================
Command: createJob
The SQL Server CDC Capture or Transactional Replication Log Reader job is not found in database Aconex.
Ensure that the database is enabled for CDC and either the SQL Server Capture job is enabled for database Aconex or the database is Published for Transactional Replication, and re-run this program.
below query is returning one record, hence the above .bat file is always failing.
select CD1.name,SD1.is_cdc_enabled,SD1.is_published,CD1.job_id from sys.databases SD1 left join msdb..sysjobs CD1 on CD1.name = N'cdc.' + db_name(db_id(N'XX')) + N'_capture'
where SD1.database_id = db_id(N'XX') and (SD1.is_cdc_enabled = 1 and (SD1.is_published = 1 or CD1.job_id is not null))
Please suggest me if I'm missing anything.
Thanks,
Apparao Akki.