Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:586)
- at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1512)
- ... 184 more
- 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
- at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:841)
- at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.query(SoftRefCachingMapper.java:100)
- at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:1106)
- at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:348)
- at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:581)
- ... 185 more
- Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: (?169 = ?170); SQL statement:
- 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]
- at org.h2.message.Message.getSQLException(Message.java:105)
- at org.h2.message.Message.getSQLException(Message.java:116)
- at org.h2.message.Message.getSQLException(Message.java:75)
- at org.h2.expression.Comparison.optimize(Comparison.java:165)
- at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:132)
- at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:132)
- at org.h2.command.dml.Select.prepare(Select.java:723)
- at org.h2.command.dml.SelectUnion.prepare(SelectUnion.java:215)
- at org.h2.command.Parser.prepare(Parser.java:205)
- at org.h2.engine.Session.prepare(Session.java:394)
- at org.h2.engine.Session.prepare(Session.java:381)
- at org.h2.table.TableView.recompileQuery(TableView.java:68)
- at org.h2.table.TableView.initColumnsAndTables(TableView.java:81)
- at org.h2.table.TableView.<init>(TableView.java:58)
- at org.h2.table.TableView.createTempView(TableView.java:338)
- at org.h2.command.Parser.readTableFilter(Parser.java:939)
- at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1500)
- at org.h2.command.Parser.parseSelectSimple(Parser.java:1597)
- at org.h2.command.Parser.parseSelectSub(Parser.java:1494)
- at org.h2.command.Parser.parseSelectUnion(Parser.java:1339)
- at org.h2.command.Parser.parseSelect(Parser.java:1327)
- at org.h2.command.Parser.parsePrepared(Parser.java:394)
- at org.h2.command.Parser.parse(Parser.java:290)
- at org.h2.command.Parser.parse(Parser.java:262)
- at org.h2.command.Parser.prepareCommand(Parser.java:234)
- at org.h2.engine.Session.prepareLocal(Session.java:409)
- at org.h2.engine.Session.prepareCommand(Session.java:370)
- at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1044)
- at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
- at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:580)
- at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:769)
- ... 189 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement