COPA extraction: RD155 No source could be found to answer the search query

[ram_pandey]

Hi Everyone,

I'm trying to schedule an init. load for the new fiscal year from an Account-based 1_CO_PA** extractor. I've entered restrictions for Controlling Area (single entry) and Fiscal Period (PERIO) 001.2011 - 001.2025.

When I try to schedule the init. load or even test the extraction in RSA3, I get the error message 'No source could be found to answer the search query'. I've checked my summarization levels and and they have the value '*' for all characteristics.

If someone can provide an explanation for the error message, it would be most helpful.

Thanks,

Ram

[ram_pandey]

Hi All,

Any inputs please?

Thanks,

Ram

[Pravender]

Check out the summarization level in tcode KEDV, whether you have defined it properly. All the characterstics should be available in summarization level. You can use * in KEDV.

[ram_pandey]

Hi Pravender,

I've alread mentioned that I checked the summarization levels and all the characteristics have value '*'.

Thanks,

Ram.

[desgallagher]

Hi Ram,

This error is almost always caused by incomplete or incorrect customizing:

In addition, the summarization level must have status 'ACTIVE' (this applies also to the search function in the maintenance transaction for CO-PA data sources,KEB0).

Please also review the SAP note 392635 which is release independent and has further information on the customizing and CO-PA extraction:

392635 - Information: Sources with BW extraction for account-based

CO-PA

So please check your customizing and the note 392635 carefully in particular please pay attention to the following:

There has to be one (single) summarization level that contains all characteristics (except for the controlling area) with '*' in the

characteristics view in transaction KEDV and has status 'active'.

After checking the above you need to replicate the datasource in the connected BW system and reactivate the transfer rules.

Best Regards,

Des

[ram_pandey]

Hi Des,

Thanks for your inputs.

I'm pretty sure that I've missed some step in the customising, but I just can't figure out which step it is.

I've checed my summarisation level (there's only one '1'). Its status is 'active, without data' in KEDV. This summarisation level contains all the characteristics and their value is '*'.

I guess its the 'without data' bit in KEDV that's causing the problems. I tried to run the job 'RKETRERU' in the source-system to remedy this, but when I run the job with 'Refresh' selected, it ends in about 5 seconds without updating any data. When I try to run the same job in either 'Rebuild' or 'Build new levels' mode, the job runs for more than 100,000 seconds and then fails because of 'DBIF_RSQL_SQL_ERROR' error. Any ideas as to where I'm missing a step?

Thanks,

Ram