Skip to Content
0
Nov 29, 2011 at 11:22 AM

Timeout error when exist universe row-level security

33 Views

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ó