cancel
Showing results for 
Search instead for 
Did you mean: 

After update of universe (UNX) webi SDK still reference old tables

alfons_gonzalez
Active Participant
0 Kudos

Hi,

We are facing an strange issue that I detail below:

We have modified the structure of a database table (column has been moved from a table to a view). After change has been applied we have updated the change on UNX universe (business layer and data foundation).

One change has been applied problem that appears is the following:

The reports that contain references to UNX object based on modified column works fine when refreshed (or when an instance is created)

But when the report is refreshed using JAVA API ReportEngine the query generated is still referring the old object definition.

How is that possible? It does seem that when using JAVA API query is not updated prior to WebI execution (it used the query contained when document was saved). Does it exist a way to fix that?

I know this API is already deprecated and we are planning to move our ReportEngine SDK based developments towards new restFul API but at the meanwhile would be very useful to us to find a workaround to fox this annoying issue.

Thx

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Alfons,

Have you tried to re point your webi reports to updated universe?

You are getting any error message? if yes please provide it.

Thanx,

Kedar

alfons_gonzalez
Active Participant
0 Kudos

Hi Kedar,

Yes, by opening the report and saving it again issue disappears, but this workaround implies having to open and save manually all webi reports involved in a change of database structure (hundreds of them in some cases.....)

This is the error message generated by the webi processing server (basically saying that the column included in the query does not longer exist). As I say error appears because Report engine is executing the query as it was when the report was saved not the one that corresponds to current db structure and universe layer.

<ERROR COMPONENT="WIS" ERRORCODE="10901" ERRORTYPE="USER" MESSAGE="The following database error occurred: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name &apos;Footer&apos;..

For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)" PREFIX="ERR">

Alfons

Former Member
0 Kudos

Could you please go through the below block:

You can modify that code for all reports to re point the dataprovider.

Thanks,

Kedar