Hi Lvca, The following exception occurred when executing select EXPAND query in orinetdb-community v1.7 distributed system. The same query is working in standalone.
Query: *select EXPAND($8) LET $1 = (select count(SEV_INWIN) as CRITICAL from V where ICON_TYPE IN [1,2,3,4,5,7] and SEV_INWIN IN [5] and STATE='Active'), $2 = (select count(SEV_INWIN) as MAJOR from V where ICON_TYPE IN [1,2,3,4,5,7] and SEV_INWIN IN [4] and STATE='Active'), $8 = UNIONALL($1,$2)* Exception: --> java.lang.NullPointerException [ONetworkProtocolHttpDb]Cannot route COMMAND operation to the distributed node null -> com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.getInvolvedClusters(OCommandExecutorSQLSelect.java:372) -> com.orientechnologies.orient.server.distributed.ODistributedStorage.command(ODistributedStorage.java:174) -> com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:59) -> com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.command(ONetworkProtocolBinary.java:1151) -> com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:342) -> com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:169) -> com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:45) Are there any changes happened in the latest version related to this query? Can you please look into this issue and let me know why it is occurred? Thanks, Madhu -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
