Oracle GoldenGate - Exceptions

Encountered some exceptions today when trying to formulate an EXTRACT job in GoldenGate. Some of them looks funny, but it would be really good to understand the cause..

Scenario 1: Extract parameter file is invalid.

EXTRACT ext1
USERID ggate,PASSWORD *****
TABLE HR.EMPLOYEES
Source Context :
  SourceModule            : [ggapp.parmscn]
  SourceID                : [$Id: //depot/releases/OpenSys/v10.4.0/src/gglib/ggapp/parmscn.c#1 $]
  SourceFunction          : [ci_get_next_cmd]
  SourceLine              : [1800]
  ThreadBacktrace         : [1] elements
                          : [C:\GoldenGate\extract.exe(ERCALLBACK+0x1193d0) [0x00589300]]

2010-04-13 13:20:12  GGS ERROR       101  Parameter unterminated.
2010-04-13 13:20:12  GGS ERROR       190  PROCESS ABENDING.

The parameter file should be terminated with a semi colon.

Scenario 2: RMTTRAIL not specified


EXTRACT ext1
USERID ggate,PASSWORD *****
TABLE HR.EMPLOYEES;
Source Context :
  SourceModule            : [er.main]
  SourceID                : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/rep.c#19 $]
  SourceFunction          : [get_infile_params]
  SourceLine              : [10436]
  ThreadBacktrace         : [1] elements
                          : [C:\GoldenGate\extract.exe(ERCALLBACK+0x1193d0) [0x00589300]]

2010-04-13 13:22:51  GGS ERROR       101  RMTTRAIL must be specified before FILE/TABLE/SEQUENCE.
2010-04-13 13:22:51  GGS ERROR       190  PROCESS ABENDING.

Scenario 3:- RMTHOST not specified

EXTRACT ext1
USERID ggate,PASSWORD *****
RMTTRAIL c:\purge

Source Context :
  SourceModule            : [er.extrout]
  SourceID                : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/extrout.c#4 $]
  SourceFunction          : [get_ext_params]
  SourceLine              : [2788]
  ThreadBacktrace         : [1] elements
                          : [C:\GoldenGate\extract.exe(ERCALLBACK+0x1193d0) [0x00589300]]

2010-04-13 13:32:21  GGS ERROR       101  No RMTHOST has been specified yet.
2010-04-13 13:32:21  GGS ERROR       190  PROCESS ABENDING.

Scenario 4: - After specifying RMTHOST, came to know that

2010-04-13 13:37:18  GGS ERROR       101  Trails cannot be used when SOURCEISTABLE/SOURCEISFILE is specified.
2010-04-13 13:37:18  GGS ERROR       190  PROCESS ABENDING.

And finally a successful run

EXTRACT ext1
USERID ggate,PASSWORD *****
RMTHOST home, MGRPORT 9500
RMTFILE c:\purge\rmtfilerr
TABLE HR.EMPLOYEES;
Using the following key columns for source table HR.EMPLOYEES: EMPLOYEE_ID.

CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE:                         64K
CACHESIZE:                                1G
CACHEBUFFERSIZE (soft max):               4M
CACHEPAGEOUTSIZE (normal):                4M
PROCESS VM AVAIL FROM OS (min):        1.72G
CACHESIZEMAX (strict force to disk):   1.53G

Processing table HR.EMPLOYEES

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************
Report at 2010-04-13 13:38:44 (activity since 2010-04-13 13:38:39)

Output to c:\purge\rmtfilerr:

From Table HR.EMPLOYEES:
       #                   inserts:       107
       #                   updates:         0
       #                   deletes:         0
       #                  discards:         0

No comments:

Post a Comment