Advertisement
koharris

Broken query version 5.6

Nov 2nd, 2012
111
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Caused by: org.nuxeo.ecm.core.query.QueryException: Invalid query: SELECT * FROM Document WHERE ((ecm:mixinType = 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted') AND ecm:parentId='f5cdee5c-b320-47d9-9496-166ff798a892' AND (ecm:primaryType ='BESInspectSkins' OR ecm:currentLifeCycleState ='Pause')) ORDER BY dc:title
  2. at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:586)
  3. at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1512)
  4. ... 184 more
  5. Caused by: org.nuxeo.ecm.core.storage.StorageException: Invalid query: SELECT * FROM Document WHERE ((ecm:mixinType = 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted') AND ecm:parentId='f5cdee5c-b320-47d9-9496-166ff798a892' AND (ecm:primaryType ='BESInspectSkins' OR ecm:currentLifeCycleState ='Pause')) ORDER BY dc:title
  6. at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:841)
  7. at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.query(SoftRefCachingMapper.java:100)
  8. at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:1106)
  9. at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:348)
  10. at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:581)
  11. ... 185 more
  12. Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: (?169 = ?170); SQL statement:
  13. SELECT "_C1", "_C2" FROM (SELECT "HIERARCHY"."ID" AS "_C1", "_F1"."TITLE" AS "_C2" FROM "HIERARCHY" LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID" LEFT JOIN "MISC" "_F2" ON "HIERARCHY"."ID" = "_F2"."ID" WHERE (("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("HIERARCHY"."ISVERSION" IS NULL) AND ("_F2"."LIFECYCLESTATE" <> ?) AND ("HIERARCHY"."PARENTID" = ?) AND ((("HIERARCHY"."PRIMARYTYPE" = ?) OR ("_F2"."LIFECYCLESTATE" = ?)) OR (? = ?))) UNION ALL SELECT "_H"."ID" AS "_C1", "_F1"."TITLE" AS "_C2" FROM "HIERARCHY" "_H" JOIN "PROXIES" ON "_H"."ID" = "PROXIES"."ID" JOIN "HIERARCHY" ON "PROXIES"."TARGETID" = "HIERARCHY"."ID" LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID" LEFT JOIN "MISC" "_F2" ON "HIERARCHY"."ID" = "_F2"."ID" WHERE (("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("_H"."ISVERSION" IS NULL) AND ("_F2"."LIFECYCLESTATE" <> ?) AND ("_H"."PARENTID" = ?) AND ((("HIERARCHY"."PRIMARYTYPE" = ?) OR ("_F2"."LIFECYCLESTATE" = ?)) OR (? = ?)))) ORDER BY "_C2" [50004-114]
  14. at org.h2.message.Message.getSQLException(Message.java:105)
  15. at org.h2.message.Message.getSQLException(Message.java:116)
  16. at org.h2.message.Message.getSQLException(Message.java:75)
  17. at org.h2.expression.Comparison.optimize(Comparison.java:165)
  18. at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:132)
  19. at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:132)
  20. at org.h2.command.dml.Select.prepare(Select.java:723)
  21. at org.h2.command.dml.SelectUnion.prepare(SelectUnion.java:215)
  22. at org.h2.command.Parser.prepare(Parser.java:205)
  23. at org.h2.engine.Session.prepare(Session.java:394)
  24. at org.h2.engine.Session.prepare(Session.java:381)
  25. at org.h2.table.TableView.recompileQuery(TableView.java:68)
  26. at org.h2.table.TableView.initColumnsAndTables(TableView.java:81)
  27. at org.h2.table.TableView.<init>(TableView.java:58)
  28. at org.h2.table.TableView.createTempView(TableView.java:338)
  29. at org.h2.command.Parser.readTableFilter(Parser.java:939)
  30. at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1500)
  31. at org.h2.command.Parser.parseSelectSimple(Parser.java:1597)
  32. at org.h2.command.Parser.parseSelectSub(Parser.java:1494)
  33. at org.h2.command.Parser.parseSelectUnion(Parser.java:1339)
  34. at org.h2.command.Parser.parseSelect(Parser.java:1327)
  35. at org.h2.command.Parser.parsePrepared(Parser.java:394)
  36. at org.h2.command.Parser.parse(Parser.java:290)
  37. at org.h2.command.Parser.parse(Parser.java:262)
  38. at org.h2.command.Parser.prepareCommand(Parser.java:234)
  39. at org.h2.engine.Session.prepareLocal(Session.java:409)
  40. at org.h2.engine.Session.prepareCommand(Session.java:370)
  41. at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1044)
  42. at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
  43. at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:580)
  44. at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:769)
  45. ... 189 more
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement