Issue in Analytical Applications on S/4 HANA On-Premise 1511

[karanbahl]

Hi all,

For most of the analytical KPI based tiles, I am getting the following error in console

Unknown or deleted query. Diagnosis Either the requested query, or one of the characteristic value variables with a replacement path from the query results, or its query does not exist or was deleted. System Response The system cannot execute the requested query. Procedure Check that the requested query still exists. Then check whether the requested query contains characteristic value variables with a replacement path from the results of the query, and whether these queries also exist. If neccesary, create the missing query again and reassign the query to the variables. Procedure for System Administration

Any idea what could be the issue?

Regards,

Karan

[former_member259059 · Accepted solution]

Hi Karan,

were you able to find a solution?

[karanbahl · Accepted solution]

Hi Silvia,

Not yet. We have asked BASIS Team to check and apply the notes for the version.

Regards,

Karan

[former_member259059 · Accepted solution]

thanks. please, keep us updated

[former_member259059 · Accepted solution]

Hi Bahl,

we solved the problem just activating the ABAP artifact with transaction SACM

[karanbahl · Accepted solution]

Hi Silvia,

I have generated the highlighted part as per the screenshot. Is this what you are referring to?

Regards,

Karan

[former_member259059 · Accepted solution]

yes, we did the first time and it didn't work.

then :

we upgrade everything at the latest version,

we installed correctly the embedded search,

we set into the HANA db user ID with system privilege = ROLE_ADMIN and USER_ADMIN and analytic privileges = _SYS_BI_CP_ALL (not all the user, only who is doing the regeneration)

and then yes, we regenerate the roles for the objects.

I'm not sure what step made the difference, but we now have the analytics working

[karanbahl · Accepted solution]

Thanks Silvia, I have got a few tiles working after this.

Regards,

Karan

[Former Member]

Hi Karan,

I get the same error as well. Were you able to fix this issue? Look forward to hear from you.

Regards,

Ann

[karanbahl]

Hi Ann,

No, Not yet.Will update when I am able to.

Regards,

Karan

[Former Member]

Sure Karan. Thank You. I will let you know if I am able to find anything as well.

Regards,

Ann