https://community.qlik.com/t5/Qlik-Replicate/Getting-invalid-XML-value-while-streaming-from-Oracle-to-Oracle/m-p/2071763#M6021 <P>We are doing a full load without CDC from source endpoint Oracle to target endpoint Oracle. Both are version 11.2.0.4.</P> <P>Hitting the following error. And the throughput is very slow taking 8 hours for about 10,000 records.</P> <P>We have to use unlimited LOB option though we have tried limit LOB=10240000K</P> <P>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</P> Tue, 16 May 2023 08:49:16 GMT desmondchew 2023-05-16T08:49:16Z https://community.qlik.com/t5/Qlik-Replicate/Getting-invalid-XML-value-while-streaming-from-Oracle-to-Oracle/m-p/2071763#M6021 <P>We are doing a full load without CDC from source endpoint Oracle to target endpoint Oracle. Both are version 11.2.0.4.</P> <P>Hitting the following error. And the throughput is very slow taking 8 hours for about 10,000 records.</P> <P>We have to use unlimited LOB option though we have tried limit LOB=10240000K</P> <P>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</P> Tue, 16 May 2023 08:49:16 GMT https://community.qlik.com/t5/Qlik-Replicate/Getting-invalid-XML-value-while-streaming-from-Oracle-to-Oracle/m-p/2071763#M6021 desmondchew 2023-05-16T08:49:16Z https://community.qlik.com/t5/Qlik-Replicate/Getting-invalid-XML-value-while-streaming-from-Oracle-to-Oracle/m-p/2071842#M6023 <P>Hi Team,</P> <P>&nbsp;</P> <P><SPAN>It looks like that Replicate is truncating the data in one of the XML columns and once this happens it becomes an invalid XML.</SPAN><BR /><SPAN>See, If you can use unlimited lob support or increase&nbsp;the limit lob size to accommodate the complete XML value.</SPAN></P> <P>&nbsp;</P> <P><SPAN>please do update if this&nbsp;</SPAN>helps.</P> <P>&nbsp;</P> <P><SPAN>Regards,</SPAN></P> <P><SPAN>Shivananda</SPAN></P> Tue, 16 May 2023 11:24:31 GMT https://community.qlik.com/t5/Qlik-Replicate/Getting-invalid-XML-value-while-streaming-from-Oracle-to-Oracle/m-p/2071842#M6023 kng 2023-05-16T11:24:31Z