Hi All,
In our platform BOE XI 3.1 SP3 FP3.6 on Linux with Java InfoView all the reports based on a universe with row level restriction doesn't work.
The universe retrieve data from an Oracle 11g database.
We have investigated this problem a little more:
+ They work when we remove row-level data security from universe
+ Even with simple row-level constraints it doesn't work, for example:
DMSC.ETPOENT.ID_TIPO_ENTORNO = 'X'
What we would like to put is a bit more complicated:
(DMSC.ETPOENT.ID_TIPO_ENTORNO IN (SELECT DMSC.ERLCUSRTPOENT.ID_TIPO_ENTORNO from DMSC.ERLCUSRTPOENT WHERE DMSC.ERLCUSRTPOENT.COD_USUARIO = @variable('BOUSER')))
It doesn't work also
+ It doesn't work when we try to created a new webi based on that universe
+ IT WORKS when we work with Webi Rich Client, but stop doing it when export webi into CMS and open it from InfoView
+ And what it happens is that InfoView crashes with the following error:
Version:12.3.0.601 Servidor de aplicaciones:
http://mosbol0:8080/AnalyticalReporting/Webi/cdzServlet
Seguimiento de pila: java.lang.NullPointerException at com.businessobjects.wp.tc.TCAutoSaveDialog.showTimeOutRestore(Unknown Source) at com.businessobjects.wp.tc.TCReference.handleAutoSave(Unknown Source) at com.businessobjects.wp.tc.TCReference.displayError(Unknown Source) at com.businessobjects.wp.tc.TCReference.displayError(Unknown Source) at com.businessobjects.wp.tc.TCReference.displayError(Unknown Source) at com.businessobjects.wp.tc.TCReference.displayError(Unknown Source) at com.businessobjects.wp.tc.TCDocFactory.documentLoadingError(Unknown Source) at com.businessobjects.wp.xml.XMLCreateDoc.load(Unknown Source) at com.businessobjects.wp.xml.XMLCreateDoc.load(Unknown Source) at com.businessobjects.wp.tc.TCDocFactory.newDocument(Unknown Source) at com.businessobjects.wp.tc.TCMain.newDocument(Unknown Source) at com.businessobjects.wp.tc.TCMain.initDocument(Unknown Source) at com.businessobjects.wp.tc.TCMain.initClient2(Unknown Source) at com.businessobjects.wp.tc.TCMain.initClient(Unknown Source) at com.businessobjects.wp.tc.thread.InitAppletRunner.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
And more incredible is that our developers say that it worked in the past but now it doesn't work
Recently we have upgrade from FP3.3 to FP3.6
We are a bit confused and would appreciated any suggestion
Thanks in advance,
Carlos Castrilló