Getting invalid XML value while streaming from Oracle to Oracle table

[desmondchew]

We are doing a full load without CDC from source endpoint Oracle to target endpoint Oracle. Both are version 11.2.0.4.

Hitting the following error. And the throughput is very slow taking 8 hours for about 10,000 records.

We have to use unlimited LOB option though we have tried limit LOB=10240000K

Invalid XML value ~{DQAAAHZnn4yv4C75Np5cyggQGoRNtOvwrNe1BEP3CPiL7xh7nVkZypNg4VcXLVlclhqmV74QBp9mi/NCAo9sPmklMeLHeDZD9bFa9+3BAgLayR+gmabotNyKa1nZiTfIo5EdTIIT+3ZFa8kStuOtQbwE3V7O3ovEtqF5Xz95a/DS/Himy6D8QbQ/LlERIiJXm3uA6TE995tdMK4TeVjPnuaplS6vUJoGqTZZyoDvwyHaXm6/8Sm8xF6ly2DpE7aqwu+lqyLvdWGhdzA3lXQT1aGIFYlOPmRC2lKdcMD/ZknPE+uB0QhJh+LmQJfiA56pV2smeGKuvibRG+smmkg2BwW0dY7l715ZzggZqdtesKOrld7Zib76mUFcWaYGoWmrpYw7BxQlvVKHn13P5qThVSCCfrfqdU3RfDs1b92AnPk8syyBUUY/2IMU+PTsk7gPBXJzpsY2n3MHoUCqKpbs1bTJCiMPx2RAckfuN86vYETQoBBMOmMIMfCSnhpgXphBIylk1VYwAeueetLzJb3mYywKbjOTs0rWISyc0V5N75T/oEYAnz7DGAKjt+JRjrhWLMXMBpmdiT8nHzI1dLWpStLcjyaNBfE3CFolWOP7CcvL4ZYAW9/cr/lCjapkjBvXTcvSWkZF0HSjmyCG2eB6qBQAgsirdOdC7Jaeckir41Exa4MqvNpJ61SUa/UpRLeDgCgBPn4nlOnIwDTw45F3ZOiVjpn2yVmysDvsdS5FxCRp0PDEVQhTLDBkszrCFJiTAn5yisTEFmDUWnTZYOwxnPdnimxlq5ZeNhN8pMBmrDHkkwJFZ9cMxAwDSeiAWSBrRD4Vl1Fv7W20XO3eb0ZUmj+g5dTHevh2SRladCA3ocnqYSp/SWqZZ7AB4otwD25W7LSf3HWc/W31GFF2Xa4zoEn8Iqlz89BTJzTzRzfjNFcuRWYE4a6w8ovo2QcCxS0KgFOmiHfS7ITCrXZN2fkwgzkOZ03wCkklbrbQLesW8ey5

[kng]

Hi Team,

It looks like that Replicate is truncating the data in one of the XML columns and once this happens it becomes an invalid XML.
See, If you can use unlimited lob support or increase the limit lob size to accommodate the complete XML value.

please do update if this helps.

Regards,

Shivananda