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.

[roland_szajko]

Hi Vasudev

Unfortunately the screenshot you posted is a very generic error message.

Aren't there:

• Any specific errors in the joblog of the dtp request?
• Any specific errors in SM21?
• Any dumps in ST22?

In the debugger what is the specific exception that is thrown by the extraction? Check the docu:

https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361385767.html?locale=en-US

br

Roland

[pallela_vasudeva_reddy]

.

[pallela_vasudeva_reddy]

.

[pallela_vasudeva_reddy]

Hello Roland,
we didnt get any dump in ST22 and SM21 we didn't checked
but we identified that one of the CKF is having the issue with 0 division.
we fixixed it with NDIV0() function and it is working fine now.

thanks for support,
Vasudev.

[Savio_Dmello]

Even if Transformation and dtp is active, try activating the transformation and dtp using RSDG_TRFN_ACTIVATE. In the selection screen, make sure you change the objects status from INA to ACT. 

[pallela_vasudeva_reddy]

error