- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Replicat ABENDS with "MAPPING ERROR" even with new SOURCDEFS
Oracle Linux 7 x64
MSSQL 2014 Std
Windows Server 2016
The customer changed 1 column data type in source DB, and this caused the REPLICAT on target to ABEND with:
WARNING OGG-01431 Aborted grouped transaction on SCHEMA.VEHICLE_ORDER, Mapping error.WARNING OGG-01003 Repositioning to rba 75954 in seqno 3.WARNING OGG-01151 Error mapping from SCHEMA.VEHICLE_ORDER to SCHEMA.VEHICLE_ORDER."ERROR OGG-01296 Error mapping from SCHEMA.VEHICLE_ORDER to SCHEMA.VEHICLE_ORDER.
1 column, named "EXTERNAL_REFERENCE" datatype was changed from VARCHAR2 to NUMBER. In MSSQL Target, the data type was VARCHAR(50), so as a result, I changed this to DECIMAL(38,0).
I then regenerated my definitions file on source and transferred them to target.
I updated the REPLICAT PARAM file to reference new definitions (I am using NO_USE_TRAILDEFS in my GLOBALS PARAMS, to force use of .def file in REPLICATE in OGG 12.3)
I restart REPLICAT on target but it still abends with the same error... Have I missed something? Or is it likely that the customer has actually changed more than that one column. (Thats all they tell me they have changed, but I'm not too sure if I trust that information...)
Any suggestions or help is appreciated. Thanks.