When a user tries to run a query SELECT act FROM BPMActivityType act LEFT JOIN FETCH act.properties where act.processType='{urn:switchyard-soa:rtgov_activity_generation:0.1.0}Process' ORDER BY timestamp DESC An exception is thrown 11:16:10,855 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) SQL Error: 1054, SQLState: 42S22 11:16:10,855 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) Unknown column 'timestamp' in 'order clause' The problem is that the column name in MySQL table is tstamp - instead of timestamp - but still property name is timestamp so it is not possible to refer to this field.
A change of mapping was done in productization
Not a beta blocker, this is advanced usage not thought to be used in beta.
Can you try adding 'act.' in front of the timestamp - e.g. "BY act.timestamp DESC" and let me know if that fixes for you - it works for me.
Have tested with the 'act.' prefix and it appears to resolve the problem, so have set the devel flag to '-'.
Don't believe this is a bug, but if further evidence becomes available then please reopen.
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days