Since the error starts with ORA that means that it is being thrown by an Oracle data source not Denodo. Usually the invalid number error is caused by an operation requiring numeric types being done on a non-numeric field/column. So this is likely not related to the number of rows that is being delegated to the source.
If you have a valid support user account, please open a new support case at support.denodo.com so that the support team can review the issue in detail.
Hope this helps!