https://community.qlik.com/t5/Connectivity-Data-Prep/Trouble-loading-all-data-from-extract-layer/m-p/2107847#M12723 <P>Beside the amount of data which may require any incremental approach it might be caused from certain settings in regard to not having the needed access rights or records are locked. Also the used driver may skip certain records if it couldn't handle a certain feature or data-type.</P> Mon, 21 Aug 2023 14:21:23 GMT marcus_sommer 2023-08-21T14:21:23Z https://community.qlik.com/t5/Connectivity-Data-Prep/Trouble-loading-all-data-from-extract-layer/m-p/2107149#M12633 <P>Has anyone had trouble or&nbsp;observed an extract job not reading all the rows from an oracle DB table?</P> <P>&nbsp;</P> <P>If so, what is the best solution?</P> Fri, 18 Aug 2023 13:08:31 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Trouble-loading-all-data-from-extract-layer/m-p/2107149#M12633 amandatedesco 2023-08-18T13:08:31Z https://community.qlik.com/t5/Connectivity-Data-Prep/Trouble-loading-all-data-from-extract-layer/m-p/2107376#M12638 <P>Hello everything is fine?</P> <P>this can be solved with an incremental load, separating your data by monthly periods for example.</P> <P>but that depends on a business analysis</P> Sat, 19 Aug 2023 18:25:07 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Trouble-loading-all-data-from-extract-layer/m-p/2107376#M12638 RodolfoBarbosa 2023-08-19T18:25:07Z https://community.qlik.com/t5/Connectivity-Data-Prep/Trouble-loading-all-data-from-extract-layer/m-p/2107847#M12723 <P>Beside the amount of data which may require any incremental approach it might be caused from certain settings in regard to not having the needed access rights or records are locked. Also the used driver may skip certain records if it couldn't handle a certain feature or data-type.</P> Mon, 21 Aug 2023 14:21:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Trouble-loading-all-data-from-extract-layer/m-p/2107847#M12723 marcus_sommer 2023-08-21T14:21:23Z