DTP failed while loading the data from Query(as infoprovider) to ADSO

[pallela_vasudeva_reddy]

Hello,

DTP failed while loading the data from Query(as infoprovider) to ADSO, this was worked fine one time but later it starts giving the below error while extracting data.

An error occurred when getting data from the processor.
Error reading the data of InfoProvider @Q<name of the Query>
Error while extracting from source 003YPSVRR***<Query techname> (type InfoProvider)
Error reading the data of InfoProvider @Q<name of the Query>

Note: 

Transformation and DTP is active, Query is working fine when we run it in RSRT, giving error while loading from DTP Only.
we created few more flows like same but others are working fine except this flow..

please suggest that did i missed something here ? 

thanks in advance.

Regards,

Vasudev.

[MKreitlein]

Hello Vasudev. It is just a first idea... have you checked all the criteria listed here?

https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/4b/c347cd494650e9e10000000a15822b/content.htm?no_c...

Maybe some technical restriction prevents it?

BR, Martin

[pallela_vasudeva_reddy]

Hi Martin, we checked above link and quiery have all settings right, data extraction also worked fine for the first time, from the second run onwords we are getting this error. We tried clear the content in ADSO and loaded again but this time also it failed. Thanks, Vasudev.

[pallela_vasudeva_reddy · Accepted solution]

Hello,

there were lot of CKFs used in query and We identified that one of the CKF is having the issue with 0 division.
We fixed it with NDIV0() function and it is working fine now.

thanks for support,
Vasudev.