java.lang.Exception: Error contacting the database at url http://localhost:7001/endeca-server/ws/conversation/multitest: exception encountered while executing external function 'internal:navigation-query', caused by error endeca-err:MDEX0001 : Invalid input : Error in EQL Query: <eql_parser_types:queryWrapper xmlns:eql_parser_types=" http://www.endeca.com/MDEX/eql_parser/types " xmlns:mdex=" http://www.endeca.com/MDEX/XQuery/2009/09 " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xsi:type="eql_parser_types:Query"><ns2:statements xmlns:ns2=" http://www.endeca.com/MDEX/eql_parser/types " returnTable="true" statementKey="Res"><ns2:selects xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ " attributeKey="TOTAL"><ns2:expression xsi:type="ns2:AttributeRefExpression" attributeKey="TOTAL"/></ns2:selects><ns2:from xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:source xsi:type="ns2:StatementSource" statementKey="GenderWiseTotal"/></ns2:from><ns2:where xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:filter xsi:type="ns2:ComparisonExpression" comparison="="><ns2:leftOperand xsi:type="ns2:AttributeRefExpression" attributeKey="Gender"/><ns2:rightOperand xsi:type="ns2:StringLiteral" value="M"/></ns2:filter></ns2:where></ns2:statements><ns2:statements xmlns:ns2=" http://www.endeca.com/MDEX/eql_parser/types " returnTable="false" statementKey="GenderWiseTotal"><ns2:selects xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ " attributeKey="TOTAL"><ns2:expression xsi:type="ns2:FunctionCallExpression" function="COUNT"><ns2:arguments xsi:type="ns2:IntegerLiteral" value="1"/></ns2:expression></ns2:selects><ns2:from xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:source xsi:type="ns2:StatementSource" statementKey="Base"/></ns2:from><ns2:group xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:groupingSetsList><ns2:groupingSetList xsi:type="ns2:GroupingSet"><ns2:groupBys xsi:type="ns2:GroupBy" attributeKey="Gender"/></ns2:groupingSetList></ns2:groupingSetsList></ns2:group></ns2:statements></eql_parser_types:queryWrapper> - In statement "GenderWiseTotal": FROM statement ("Base") is not defined

Oracle Community | 990990 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    unable to query a view (which is created from Studio application) through web service

    Oracle Community | 3 years ago | 990990
    java.lang.Exception: Error contacting the database at url http://localhost:7001/endeca-server/ws/conversation/multitest: exception encountered while executing external function 'internal:navigation-query', caused by error endeca-err:MDEX0001 : Invalid input : Error in EQL Query: <eql_parser_types:queryWrapper xmlns:eql_parser_types=" http://www.endeca.com/MDEX/eql_parser/types " xmlns:mdex=" http://www.endeca.com/MDEX/XQuery/2009/09 " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xsi:type="eql_parser_types:Query"><ns2:statements xmlns:ns2=" http://www.endeca.com/MDEX/eql_parser/types " returnTable="true" statementKey="Res"><ns2:selects xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ " attributeKey="TOTAL"><ns2:expression xsi:type="ns2:AttributeRefExpression" attributeKey="TOTAL"/></ns2:selects><ns2:from xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:source xsi:type="ns2:StatementSource" statementKey="GenderWiseTotal"/></ns2:from><ns2:where xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:filter xsi:type="ns2:ComparisonExpression" comparison="="><ns2:leftOperand xsi:type="ns2:AttributeRefExpression" attributeKey="Gender"/><ns2:rightOperand xsi:type="ns2:StringLiteral" value="M"/></ns2:filter></ns2:where></ns2:statements><ns2:statements xmlns:ns2=" http://www.endeca.com/MDEX/eql_parser/types " returnTable="false" statementKey="GenderWiseTotal"><ns2:selects xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ " attributeKey="TOTAL"><ns2:expression xsi:type="ns2:FunctionCallExpression" function="COUNT"><ns2:arguments xsi:type="ns2:IntegerLiteral" value="1"/></ns2:expression></ns2:selects><ns2:from xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:source xsi:type="ns2:StatementSource" statementKey="Base"/></ns2:from><ns2:group xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:groupingSetsList><ns2:groupingSetList xsi:type="ns2:GroupingSet"><ns2:groupBys xsi:type="ns2:GroupBy" attributeKey="Gender"/></ns2:groupingSetList></ns2:groupingSetsList></ns2:group></ns2:statements></eql_parser_types:queryWrapper> - In statement "GenderWiseTotal": FROM statement ("Base") is not defined

    Root Cause Analysis

    1. java.lang.Exception

      Error contacting the database at url http://localhost:7001/endeca-server/ws/conversation/multitest: exception encountered while executing external function 'internal:navigation-query', caused by error endeca-err:MDEX0001 : Invalid input : Error in EQL Query: <eql_parser_types:queryWrapper xmlns:eql_parser_types=" http://www.endeca.com/MDEX/eql_parser/types " xmlns:mdex=" http://www.endeca.com/MDEX/XQuery/2009/09 " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xsi:type="eql_parser_types:Query"><ns2:statements xmlns:ns2=" http://www.endeca.com/MDEX/eql_parser/types " returnTable="true" statementKey="Res"><ns2:selects xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ " attributeKey="TOTAL"><ns2:expression xsi:type="ns2:AttributeRefExpression" attributeKey="TOTAL"/></ns2:selects><ns2:from xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:source xsi:type="ns2:StatementSource" statementKey="GenderWiseTotal"/></ns2:from><ns2:where xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:filter xsi:type="ns2:ComparisonExpression" comparison="="><ns2:leftOperand xsi:type="ns2:AttributeRefExpression" attributeKey="Gender"/><ns2:rightOperand xsi:type="ns2:StringLiteral" value="M"/></ns2:filter></ns2:where></ns2:statements><ns2:statements xmlns:ns2=" http://www.endeca.com/MDEX/eql_parser/types " returnTable="false" statementKey="GenderWiseTotal"><ns2:selects xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ " attributeKey="TOTAL"><ns2:expression xsi:type="ns2:FunctionCallExpression" function="COUNT"><ns2:arguments xsi:type="ns2:IntegerLiteral" value="1"/></ns2:expression></ns2:selects><ns2:from xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:source xsi:type="ns2:StatementSource" statementKey="Base"/></ns2:from><ns2:group xmlns=" http://www.endeca.com/MDEX/conversation/3/0 " xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ "><ns2:groupingSetsList><ns2:groupingSetList xsi:type="ns2:GroupingSet"><ns2:groupBys xsi:type="ns2:GroupBy" attributeKey="Gender"/></ns2:groupingSetList></ns2:groupingSetsList></ns2:group></ns2:statements></eql_parser_types:queryWrapper> - In statement "GenderWiseTotal": FROM statement ("Base") is not defined

      at com.oracle.endeca.server.examples.ops.Query.execute()
    2. com.oracle.endeca
      BasicTestCases.testEQLSearch
      1. com.oracle.endeca.server.examples.ops.Query.execute(Query.java:206)
      2. com.oracle.endeca.server.examples.integration_test.BasicTestCases.testEQLSearch(BasicTestCases.java:62)
      2 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    4. TestNG
      RemoteTestNG.main
      1. org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)
      2. org.testng.internal.Invoker.invokeMethod(Invoker.java:714)
      3. org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
      4. org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
      5. org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
      6. org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
      7. org.testng.TestRunner.privateRun(TestRunner.java:767)
      8. org.testng.TestRunner.run(TestRunner.java:617)
      9. org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
      10. org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
      11. org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
      12. org.testng.SuiteRunner.run(SuiteRunner.java:240)
      13. org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
      14. org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
      15. org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)
      16. org.testng.TestNG.runSuitesLocally(TestNG.java:1149)
      17. org.testng.TestNG.run(TestNG.java:1057)
      18. org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)
      19. org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)
      20. org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)
      20 frames