Tuesday, October 14, 2014

OGG-00049 Trails cannot be used when SOURCEISTABLE/SOURCEISFILE is specified

Today when doing Initial load my extract got ABENDED with the error below

2014-10-14 19:46:37  ERROR   OGG-00049  Trails cannot be used when SOURCEISTABLE/SOURCEISFILE is specified.
2014-10-14 19:46:37  ERROR   OGG-01668  PROCESS ABENDING.


GGSCI (oracledev01.com) 1> view params initEXT

EXTRACT initEXT
SETENV(ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV(ORACLE_SID=orcl)
sourceistable
USERID ggs_admin,PASSWORD xxxxx
RMTHOST oracleqa01, mgrport 7809
RMTTRAIL /u01/dev/oracle/input/ggs/remote/cb/DEV_ORCL.dat, purge
TABLE DEV.TAB1;
TABLE DEV.TAB2;

 Since here i'm sending the ".dat" files to the target server for the reporting purpose i'm not using Datapump and Replicat process, just sending files directly from my extract process (datapump process is always OPTIONAL)

SOURCEISTABLE:  extracts the records from the source tables directly.
RMTFILE:   Specifies the location and file name of the extract file that will be written during the load.

SOLUTION:   Remove the EXTTRAIL or RMTTRAIL parameter.

When I replaced RMTTRAIL with RMTFILE, then my issue got resolved.

RMTFILE /u01/dev/oracle/input/ggs/remote/cb/DEV_ORCL.dat, purge



GGSCI (oracledev01.domain.com) 3> start initEXT
Sending START request to MANAGER ...
EXTRACT INITEXT starting

GGSCI (oracledev01.domain.com) 4> info initEXT

EXTRACT    INITEXT      Initialized   2014-10-14 17:40   Status RUNNING
Checkpoint Lag              Not Available
Log Read Checkpoint   Not Available
                                       First Record         Record 0
Task                              SOURCEISTABLE


Reference: 


0 comments:

Post a Comment

Auto Scroll Stop Scroll