The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
[OData Source [516]] Error: The OData Source was unable to process the data. Exception from HRESULT: 0xC0047072
After process 6000 of data then this error comes.
Using the same connection/same DB is working fine for some other entity.
Source: Odata