Query syntax error after multiprovider change

[Former Member]

Hi everyone,

I removed key figures from a multicube, changed a query on top afterwards and saved it. The key figures are no longer in the key figure list of the query in the Query designer, and are no longer used in any place within the query.

Now, I'm getting a syntax error on query execution, since the compiled query still contains a reference to the old key figures. Regeneration via RSRT or saving under a new name doesn't work, and to delete the generated report I need a developer key.

Any ideas?

Regards,

Tilman

[esteban_rodriguezfernande]

I have similar error, it was due to a component included in SAPKW70017 OLAP Tunnel it runs with queries reading from Aggregation Level an then reading from a multiprovider. The report generated by this component did not "refreshed" the multiprovider changes and referenced unavailible infoobjects.

Note 1101187 for further information.

The report can be regenerated in RSRT - <multiprovider>/!!1<multiprovider>

I Think this should helps

[former_member189638]

May be because you had some Calculated or Restricted key figures in your query which was using the Key Figure that you had deleted.

Also when a query or the infoprovider is changed it is important to regenerate the query to clear the cache or else it gives an error.

[Former Member]

I deleted the Infocube and the Multiprovider and recreated everything, now it's working. Still it would be interesting what might have caused the problem

[Former Member]

Hello,

Check the definition of the query with the chek query button at the top of query designer.

Also let know what error you get,

Regds,

Shashank

[Former Member]

Hi Shashank,

thanks for your response.

I did try the "check query" button, it didn't return an error. When executing the query via rsrt, I get a dump due to "Syntax error in program GP48VM7K0MSF08DRO2382A2PSTI ". The program still contains data type references to the removed infoobjects. When checking the program via SE38, you get just that syntax error.

I'm looking for a way to clean these things up. Even when creating a new query on the aggregation level (I was talking about a multiprovider earlier, which is located underneath), the error pops up. I activated all the objects along the way, with no effect.

Regards,

Tilman

[Former Member]

Queries on the multiprovider do work, while the error only occurs once I create the query on the aggregation level. Deleting and recreating the aggregation level and the filter didn't work either.