user lacks privilege or object not found

0
I am getting an below Error while I am Query run in basic Report.   Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: j1staticdata$region.regioncode     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQuery(JDBCDataStore.java:303)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQueries(JDBCDataStore.java:198)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:163)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:152)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:229)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:196)     at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:78)     at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:62)     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:41)     at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:459)     at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:92)     at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:17)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49)     at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248)     at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.core.component.InternalCore.retrieveOQLDataTable(InternalCore.java:1012)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getResultFromOQL(SeriesDataGenerator.java:417)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesValues(SeriesDataGenerator.java:340)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesDataList(SeriesDataGenerator.java:83)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesDataList(SeriesDataGenerator.java:74)     at com.mendix.webui.reporting.clientactions.ReportAction.execute(ReportAction.java:68)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:317)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:312)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:312)     at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:144)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     My Query : select  E.IdNr IDNr,  E.TypeOfReport Type, E.Status Status, E.RegisteredDate RegdDate, A.AssetCode AssetCode, A.AssetName AssetName, A.Hosted Hosted from ISDatabase.ISEvent E JOIN StaticData.Asset A ON A.AssetCode = E/ISDatabase.ISEvent_Asset/StaticData.Asset/AssetCode JOIN StaticData.Region R ON R.RegionCode = E/ISDatabase.ISEvent_Region/StaticData.Region/RegionCode and E/ISDatabase.ISEvent_Region = $EventRegion and E/ISDatabase.ISEvent_Location = $EventLocation and E.Status = $EventStatus and E.RegisteredDate in $EventRegDateRange   user hasRead/Write Access to Entity StaticData.Region
asked
1 answers
1

Rewrite to

FROM ISDatabase.ISEvent E
INNER JOIN E/ISDatabase.ISEvent_Asset/StaticData.Asset AS A
INNER JOIN E/ISDatabase.ISEvent_Region/StaticData.Region AS R
INNER JOIN E/ISDatabase.ISEvent_Location/StaticData.location AS L

SELECT 
E.IdNr IDNr, 
E.TypeOfReport _Type,
E.Status Status,
E.RegisteredDate RegdDate,
A.AssetCode AssetCode,
A.AssetName AssetName,
A.Hosted Hosted


WHERE
R = $EventRegion
and L = $EventLocation
and E.Status = $EventStatus
and E.RegisteredDate in $EventRegDateRange

 

answered