Exception in advance search web UI "problem_with_query" in SAP CRM

[Former Member]

Hi Experts,

I have added new field in my transaction (Opportunity) "Created On date", this I have added in search criteria also.

When we are searching the same Opportunity in Advance search by using Created On date it gives error as "Exception condition "PROBLEM_WITH_QUERY" raised".

Also after further investigation we came to know that this exception is coming from the method "recursion_path_find" of class CL_CRM_REPORT_ACCRULE but I am not able to find the exact cause of the issue.

Please help to resolve this query as soon as possible.

Regards,

Chinmaya M.

[former_member13738 · Accepted solution]

Hi Chinmaya,

You can debug the method CL_CRM_REPORT_ACC_DYNAMIC->PARSE_QUERY and see where it throws the exception. If you have enhanced the view with AET and added a search parameter, you will have to add this field manually to the search structure.

Thanks & Best Regards,

Leon

[Former Member · Accepted solution]

Hello Leon,

Sorry for the late reply. The above solution worked. Thanks.

Regards,

Chinmaya M

[Former Member · Accepted solution]

Hi Chinmaya

how did you make it work?

I am having the exact issue as yours. I debugged into CL_CRM_REPORT_ACC_DYNAMIC->PARSE_QUERY, and found out that my z-field is not available in the table CRMC_REPDY. However I added the z-filed by appended structure to the search structure.

how did you make it work for your project?

Appreciate if you could share the solution.

Thanks

Jayson

[vinodkumar_kommineni · Accepted solution]

Hi Jayson,

You need to make the entry in CRMC_REPDY to publish your field to reporting framework.

Go to SM30 and open CRMC_REPDY and you would be able to make the entries for your Z fields.

Assuming you have added an attribute ZZFIELD1 to customerh for example

the entry would look like below:

SEL_FIELD would be ZZFIELD1

NAME_ON_DB would be CRMD_CUSTOMER_H~ZZFIELD1

DYN_METHOD would be DYN_CUSTOMER_H

Have a look at the data with in CRMC_REPDY and you would understand it.

Regards

Vinod

[Former Member · Accepted solution]

Hi Jayson,

I added an entry in the CRMC_REPDY table. The table maintenance generator for the table is available. So you can add entries to the table through it.

We need to give the field name, Name on DB will be the structure name and DYN_METHOD will be your Dynamic method name. In my case it was opportunity search screen, so we put "DYN_OPPORT_H" as the value.

Regards,

Chinmaya M

[Former Member · Accepted solution]

Hi Vinod and Chinmaya

thanks for your quick response.

in your case you, seem that you added new search zz-field which is enhanced to hte CUSTOMER_H table / object. After adding the record in CRMC_REPDY, does SAP FM 'CRM_BSP_OIC_1O_SEARCH_FROM_RF' automatically search based on the zz-field in customer_H, or you still need to filter the returned guild list using your own code after calling 'CRM_BSP_OIC_1O_SEARCH_FROM_RF'?

Thanks

[vinodkumar_kommineni · Accepted solution]

Hi Jayson,

You don't need to write any code after doing that entry.

Regards

Vinod

[Former Member · Accepted solution]

Thanks, Vinod, for your clarification.