I can't see anything in the two map statements that would make the introduction of the second table MAP cause Replicat to skip the first. Can you do a SEND REP <replicat name> REPORT, and then paste the output of the entire report into this thread? I'd like to see the stats and the rest of the Replicat parameters.
I'm getting the error
Duplicate stored procedure name (record_lookup).
Sorry i didn't realise this earlier because i've written a routine to automatically restart GG when an error occurs, although this should only apply to when a DDL event occurs it seems to execute whenever an error occurs, another error in my setup that i will fix.
My question is, the stored procedure name, do they have to be unique for each COLMAP? it looks like they do. Can i pull the stored procedure to execute outside of the COLMAP statement so it is only included once in my parameter file?
Unfortunately, this is the case that the stored procedure names much be unique, so they can't be reused across multiple MAP or TABLE statements. Here is the KM that discusses this:
OGG Replicat Abended With OGG-00303 Duplicate Stored Procedure Name (Lookup) Error (Doc ID 1386883.1)
There is an enhancement request that was made to have this limitation removed to enable a user to include the same stored procedure in multiple MAPs but this functionality is not currently targeted for a particular release.