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
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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