APD related problem.

[Former Member]

Hi,

I have an APD in the BW Production system. The APD is run with the help of an ABAP Program in the process chain. The APD runs a query and writes the output in a App Server file.

Lately, the APD step in the chain has been failing. The error says: Check the APD definition or Query definition.

After sometime, when we repeat the step, it works perfectly fine.

APD has only 3 objects: Query (source), Routine (acts as a filter), Flatfile (target)

APD Definition is correct

Query is also right

Amount of data is very less

please help me out .

[Former Member · Accepted solution]

This can be because of any query element change, which is not captured in APD. Follow these steps.

1. Regenerate source query again in RSRT and check if it is fine.

Hope, this solution works.

[Former Member]

thanks bilvanth for u answers.

the issue is solved

[Former Member]

Then, send an active version to PED.

It is very important to reactivate APD, when there is any change in query definition.

[Former Member]

Go to APD definition and check it. Also activate it again.