Simple Card Update Error

shawn.c · October 4, 2016, 3:52pm

Hi

I'm having a very similar to this post (http://www.cmdbuild.org/forum/forum-in-english/994709652/434809837/view).

We're testing out the 'Event synchronous' feature in Task Manager - we added a task with this details:

Phase=After Update
Group to apply: all
Class: Floor
No attributes or Relations is specified
Send notification email

We have set up a very simple test email with pretty much an empty body for this test case.

any help would be appreciated.

Here is the error from the cmdb.log:

INFO 2016-10-04 15:45:40 [jsonrpc ] Calling url /management/modcard/updatecard

INFO 2016-10-04 15:45:40 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#IsInFloor#Description'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#IsInRoom#Description'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#IsInUnit#Description'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#Country#Description'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#IsInFloor#Description'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#IsInRoom#Description'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#IsInUnit#Description'

WARN 2016-10-04 15:45:40 [sql ] cannot get content of column 'Floor#Country#Description'

INFO 2016-10-04 15:45:40 [jsonrpc ] adding condition '{"attribute":"Id","value":[251409],"operator":"equal"}' to actual filter '{"attribute":{},"relation":[]}'

INFO 2016-10-04 15:45:40 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'

ERROR 2016-10-04 15:45:40 [cmdbuild] error invoking method 'public abstract void org.cmdbuild.services.event.Observer.beforeUpdate(org.cmdbuild.dao.entry.CMCard,org.cmdbuild.dao.entry.CMCard)' for 'org.cmdbuild.logic.taskmanager.event.DefaultSynchronousEventFacade$DefaultIdentifiableObserver@dead49c[identifier=258071]', skipping

ERROR 2016-10-04 15:45:40 [cmdbuild] caused by

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.cmdbuild.services.event.DefaultObserverCollector$1.invoke(DefaultObserverCollector.java:62)

at com.sun.proxy.$Proxy160.beforeUpdate(Unknown Source)

at org.cmdbuild.services.event.ObservableDataView$ObservableExistingCardDefinition.save(ObservableDataView.java:60)

at org.cmdbuild.data.store.dao.DataViewStore.update(DataViewStore.java:244)

at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.updateCard0(DefaultDataAccessLogic.java:715)

at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.updateCard(DefaultDataAccessLogic.java:694)

at org.cmdbuild.servlets.json.management.ModCard.updateCard(ModCard.java:694)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:107)

at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:67)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:158)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:48)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:52)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.cmdbuild.filters.LocalizationFilter.doFilter(LocalizationFilter.java:127)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [

SELECT DISTINCT ON ("_Floor_Id")

"Floor#Availability"."Description" AS "Floor#Availability#Description", "Floor#Level"."Description" AS "Floor#Level#Description", "Floor#Condition"."Description" AS "Floor#Condition#Description", "Floor#Criticality"."Description" AS "Floor#Criticality#Description", "Floor#Complex"."Description" AS "Floor#Complex#Description", "Floor#Building"."Description" AS "Floor#Building#Description", "Floor#IsInComplex"."Description" AS "Floor#IsInComplex#Description", "Floor#IsInBuilding"."Description" AS "Floor#IsInBuilding#Description", "Floor#Area"."Description" AS "Floor#Area#Description", "Floor#Category"."Description" AS "Floor#Category#Description", "Floor#Group"."Description" AS "Floor#Group#Description", "Floor"."Code" AS "Floor#Code", "Floor"."Name" AS "Floor#Name", "Floor"."Notes" AS "Floor#Notes", "Floor"."Description" AS "Floor#Description", "Floor"."Availability" AS "Floor#Availability", "Floor"."Level" AS "Floor#Level", "Floor"."Complex" AS "Floor#Complex", "Floor"."Building" AS "Floor#Building", "Floor"."IsInComplex" AS "Floor#IsInComplex", "Floor"."IsInBuilding" AS "Floor#IsInBuilding", "Floor"."IsInFloor" AS "Floor#IsInFloor", "Floor"."IsInRoom" AS "Floor#IsInRoom", "Floor"."IsInUnit" AS "Floor#IsInUnit", "Floor"."Address" AS "Floor#Address", "Floor"."ZIP" AS "Floor#ZIP", "Floor"."City" AS "Floor#City", "Floor"."Country" AS "Floor#Country", "Floor"."Area" AS "Floor#Area", "Floor"."Category" AS "Floor#Category", "Floor"."Group" AS "Floor#Group", "Floor"."Condition" AS "Floor#Condition", "Floor"."Criticality" AS "Floor#Criticality", "Floor"."LastCheckDate" AS "Floor#LastCheckDate", "Floor"."TotalGrossArea" AS "Floor#TotalGrossArea", "Floor"."TotalNetArea" AS "Floor#TotalNetArea", "Floor"."CoveredArea" AS "Floor#CoveredArea", "Floor"."GlazedArea" AS "Floor#GlazedArea", "Floor"."CleanableArea" AS "Floor#CleanableArea", "Floor"."TotalVolume" AS "Floor#TotalVolume", "Floor"."OutOfHourTelephone" AS "Floor#OutOfHourTelephone", "Floor"."TotalHeatedVolume" AS "Floor#TotalHeatedVolume", "Floor"."OpeningHours" AS "Floor#OpeningHours", "Floor"."TelNumber" AS "Floor#TelNumber", "Floor"."Rooms" AS "Floor#Rooms", "Floor"."IdClass"::oid AS "_Floor_IdClass", "Floor"."Id" AS "_Floor_Id", "Floor"."User" AS "_Floor_User", "Floor"."BeginDate" AS "_Floor_BeginDate"

FROM "Floor" AS "Floor"

LEFT JOIN "Complex" AS "Floor#Complex" ON "Floor#Complex"."Id" = "Floor"."Complex"

LEFT JOIN "LookUp" AS "Floor#Availability" ON "Floor#Availability"."Id" = "Floor"."Availability"

LEFT JOIN "LookUp" AS "Floor#Level" ON "Floor#Level"."Id" = "Floor"."Level"

LEFT JOIN "LookUp" AS "Floor#Condition" ON "Floor#Condition"."Id" = "Floor"."Condition"

LEFT JOIN "Building" AS "Floor#IsInBuilding" ON "Floor#IsInBuilding"."Id" = "Floor"."IsInBuilding"

LEFT JOIN "LookUp" AS "Floor#Criticality" ON "Floor#Criticality"."Id" = "Floor"."Criticality"

LEFT JOIN "MaintenanceArea" AS "Floor#Area" ON "Floor#Area"."Id" = "Floor"."Area"

LEFT JOIN "Complex" AS "Floor#IsInComplex" ON "Floor#IsInComplex"."Id" = "Floor"."IsInComplex"

LEFT JOIN "MaintenanceGroup" AS "Floor#Group" ON "Floor#Group"."Id" = "Floor"."Group"

LEFT JOIN "MaintenanceCategory" AS "Floor#Category" ON "Floor#Category"."Id" = "Floor"."Category"

LEFT JOIN "Building" AS "Floor#Building" ON "Floor#Building"."Id" = "Floor"."Building"

WHERE "Floor"."Id" = ? AND "Floor"."Status" = ?

ORDER BY "Floor#Description" ASC, "_Floor_Id"

LIMIT 2147483647

OFFSET 0]; nested exception is org.postgresql.util.PSQLException: ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY expressions

Position: 25

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:747)

at org.cmdbuild.dao.driver.postgres.EntryQueryCommand.run(EntryQueryCommand.java:72)

at org.cmdbuild.dao.driver.postgres.PostgresDriver.query(PostgresDriver.java:194)

at org.cmdbuild.dao.view.DBDataView.executeQuery(DBDataView.java:416)

at org.cmdbuild.dao.view.ForwardingDataView.executeQuery(ForwardingDataView.java:160)

at org.cmdbuild.services.localization.LocalizedDataView.executeQuery(LocalizedDataView.java:208)

at org.cmdbuild.dao.view.ForwardingDataView.executeQuery(ForwardingDataView.java:160)

at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:181)

at org.cmdbuild.dao.view.user.UserQuerySpecsBuilder.run(UserQuerySpecsBuilder.java:149)

at org.cmdbuild.logic.taskmanager.event.DefaultObserverFactory$SynchronousEventTaskPredicate.matchesFilter(DefaultObserverFactory.java:174)

at org.cmdbuild.logic.taskmanager.event.DefaultObserverFactory$SynchronousEventTaskPredicate.matchesCards(DefaultObserverFactory.java:159)

at org.cmdbuild.logic.taskmanager.event.DefaultObserverFactory$SynchronousEventTaskPredicate.apply(DefaultObserverFactory.java:138)

at org.cmdbuild.logic.taskmanager.event.DefaultObserverFactory$SynchronousEventTaskPredicate.apply(DefaultObserverFactory.java:81)

at org.cmdbuild.services.event.FilteredObserver$Builder$1.invoke(FilteredObserver.java:70)

at com.sun.proxy.$Proxy160.beforeUpdate(Unknown Source)

at org.cmdbuild.services.event.ForwardingObserver.beforeUpdate(ForwardingObserver.java:25)

... 62 more

Caused by: org.postgresql.util.PSQLException: ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY expressions

Position: 25

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)

at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)

at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)

at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)

... 82 more

ERROR 2016-10-04 15:45:40 [jsonrpc ] A java.lang.reflect.UndeclaredThrowableException occurred calling method class org.cmdbuild.servlets.json.management.ModCard.updateCard

java.lang.reflect.UndeclaredThrowableException