on 03-29-2016 9:51 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 'Footer'..
For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)" PREFIX="ERR">
Alfons
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.