Data provider with uniserve based on Excel is not refreshed.
I'm here again beucase sometimes BO issues are really tricky, and hard to understand its behaviour.
So here we go, the scenario that I have is:
- BO Version: BO4 SP1
- A connection was created based on a excel sheed (JavaBeans 'driver')
- Then a (stored procedure) universe was created with this connection.
- It is possible to use the universe in a Web Intelligence report, data appears. So far, so good.
But the problem:
After the report is created and the data is captured from the data provider, the data from the excel will never be refreshed again.
I mean, we push the "refresh" button on the report, but the old data remains there.
Even if I delete the excel file, the old data from the very first execution will remain there.
I was thinking about some parameters that manage cache in both services (servers) and Universe, but I found none.
In fact there is no possibility to change parameter for that stored procedure universe: the fields are disabled.
So, do you know how can I force the report to be refreshed when I'm using a stored procedure universe?
Note: I have the same behavior in both stand-alone and client-server universe.
Thank you very much in advance.
Message was edited by: Marcos Morais
Marcos Morais replied
Maybe someone will face this issue in the future, so I will share the solution.
For me does not make sense, but the "Connection Pool Mode" must be "Disconnect after every transation" when you are using a universe based on Excel and if you want it to be refreshed on demand without any delays.