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
Nirmal Kumar
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