Can't open view...

Hi,

I have a mySQL-based database. For one of the Entities I cannot open views anymore. I get the following error message:

java.lang.NullPointerException: v1
    at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:229)
    at com.im.df.impl.db.query2.BaseSelectBuilder.findLCA(BaseSelectBuilder.java:554)
    at com.im.df.impl.db.query2.BaseSelectBuilder.addJoin(BaseSelectBuilder.java:536)
    at com.im.df.impl.db.query2.BaseSelectBuilder.finish(BaseSelectBuilder.java:308)
    at com.im.df.impl.db.query2.BaseSelectBuilder.getSelect(BaseSelectBuilder.java:327)
    at com.im.df.impl.db.query2.QueryDefinitionBuilder.compileMainQuery(QueryDefinitionBuilder.java:358)
    at com.im.df.impl.db.query2.QueryDefinitionBuilder.build(QueryDefinitionBuilder.java:428)
    at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForDistinctValues(DBSchemaDataProviderImpl.java:474)
    at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIdsImpl(DBSchemaDataProviderImpl.java:531)
    at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIds(DBSchemaDataProviderImpl.java:191)
    at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIds(DBSchemaDataProviderImpl.java:179)
    at com.im.df.impl.db.resultset.ResultSetImpl$2.executeQuery(ResultSetImpl.java:324)
    at com.im.df.util.earlyresults.EarlyResultsBatcher.runQuery(EarlyResultsBatcher.java:38)
    at com.im.df.impl.db.resultset.ResultSetImpl.applyQueryInternal(ResultSetImpl.java:330)
    at com.im.df.impl.db.resultset.ResultSetImpl.applyWorkingQuery(ResultSetImpl.java:256)
    at com.im.df.impl.db.resultset.ResultSetImpl.readAllData(ResultSetImpl.java:642)
    at com.im.df.impl.db.resultset.ResultSetImpl.ensureLoaded(ResultSetImpl.java:611)
    at com.im.ijc.core.api.views.AbstractViewTopComponent$ViewBackgroundRunner.phase1InRequestProcessor(AbstractViewTopComponent.java:2349)
    at com.im.ijc.core.api.ui.DFItemTCRegistry$RunnerProxy.phase1InRequestProcessor(DFItemTCRegistry.java:329)
[catch] at com.im.commons.progress.BackgroundRunner.processTheTask(BackgroundRunner.java:140)
    at com.im.commons.progress.BackgroundRunner$1.run(BackgroundRunner.java:102)
    at com.im.commons.base.ThreadContext$2.run(ThreadContext.java:193)
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)

Creating a new view gives the same error. On the database side all looks fine, the data is all there (mySQL Workbench). This is in IJC 15.10.12.

Please advice!

Dear Evert,

after consultation with a developer, judging from the error, it seems that the data tree that is affected cant find some entities that the data tree definition expects. Could you please check that the data tree contains all the entities that are there and that the underlying entities are not broken?

You could also try creating the same data tree from scratch, next to the current one and copy the views there?

Wishing all the best

David

Hi David,

Creating a new data tree does the trick, I could create new views from that.

Cheers,

Evert