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