HI,
To make use of the editable datagrid I updated to version 6.5 of both the studio and platform. After recompiling it turned out that many of my screens were broken - especially in styling. But I also had a number of errors regarding PSQL (see below).
Luckily I’m using git and could revert to the 6.4.2 platform version I was running. This worked well except for the PSQL error which keeps popping up. So, I cleaned the database (I didn’t have a backup of the database) to start all over again. But still, the PSQL error remains.
Needless to say that this is a major issue for me. Any help appreciated.
Error:
PSQLException: ERROR: column t1.int_entity_id does not exist
Position: 222
Details:
com.haulmont.cuba.core.global.RemoteException:
---
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.cuba15): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column t1.int_entity_id does not exist
Position: 222
Error Code: 0
Call: SELECT t1.ID, t1.BOOLEAN_VALUE, t1.CODE, t1.CREATE_TS, t1.CREATED_BY, t1.DATE_VALUE, t1.DELETE_TS, t1.DELETED_BY, t1.DOUBLE_VALUE, t1.INTEGER_VALUE, t1.STRING_VALUE, t1.UPDATE_TS, t1.UPDATED_BY, t1.VERSION, t1.ENTITY_ID, t1.INT_ENTITY_ID, t1.LONG_ENTITY_ID, t1.STRING_ENTITY_ID, t1.ENTITY_VALUE, t1.INT_ENTITY_VALUE, t1.LONG_ENTITY_VALUE, t1.STRING_ENTITY_VALUE, t1.CATEGORY_ATTR_ID, t1.PARENT_ID, t0.ID, t0.CATEGORY_ENTITY_TYPE, t0.CODE, t0.CREATE_TS, t0.CREATED_BY, t0.DATA_TYPE, t0.DEFAULT_BOOLEAN, t0.DEFAULT_DATE, t0.DEFAULT_DATE_IS_CURRENT, t0.DEFAULT_DOUBLE, t0.DEFAULT_INT, t0.DEFAULT_STRING, t0.DELETE_TS, t0.DELETED_BY, t0.ENTITY_CLASS, t0.ENUMERATION, t0.FILTER_XML, t0.IS_COLLECTION, t0.JOIN_CLAUSE, t0.LOOKUP, t0.NAME, t0.ORDER_NO, t0.REQUIRED, t0.ROWS_COUNT, t0.SCREEN, t0.TARGET_SCREENS, t0.UPDATE_TS, t0.UPDATED_BY, t0.VERSION, t0.WHERE_CLAUSE, t0.WIDTH, t0.DEFAULT_ENTITY_VALUE, t0.DEFAULT_INT_ENTITY_VALUE, t0.DEFAULT_LONG_ENTITY_VALUE, t0.DEFAULT_STR_ENTITY_VALUE, t0.CATEGORY_ID, t2.ID, t2.DISCRIMINATOR, t2.CREATE_TS, t2.CREATED_BY, t2.DELETE_TS, t2.DELETED_BY, t2.ENTITY_TYPE, t2.IS_DEFAULT, t2.NAME, t2.SPECIAL, t2.UPDATE_TS, t2.UPDATED_BY, t2.VERSION FROM SYS_ATTR_VALUE t1 LEFT OUTER JOIN SYS_CATEGORY_ATTR t0 ON (t0.ID = t1.CATEGORY_ATTR_ID) LEFT OUTER JOIN SYS_CATEGORY t2 ON (t2.ID = t0.CATEGORY_ID) WHERE (((t1.ENTITY_ID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (t1.PARENT_ID IS NULL)) AND (t1.DELETE_TS IS NULL))
bind => [5073902b-0976-41b9-96da-1841e29051dc, aca2ebd3-c85e-4964-81a1-b2a72c0da9a0, 4b4d5d6a-57f9-4a46-92fe-9a5db92eb037, fbfec283-542f-407e-b5e4-4e5b92459b12, 05bddc4c-fd98-4ae6-b920-2dba45c38271, 340b6cfe-aa83-479e-8457-c2bb09e686c8, e22b125f-19fb-44c0-be34-c912712975ea, 2fd4db65-4e40-4475-90fd-bfe548f8ab69, f72e32ee-8046-4241-933f-8bc22b992053, cfc3e1d0-a763-4644-985f-0a8979eac638, 8a16b235-ff6c-47a4-839b-cf6248ad15ee, 6d158e5c-940b-4ba0-80c2-bc4a3e7cc743, 14eb2b2d-33b2-4b71-a779-a3e57cd2c87e, c5bcae4e-ca3f-487e-8703-3f83a156b9d3, 3be59fc5-b131-4efe-9bf5-045274c524f4, 8a42d39c-ba78-4f8c-90f6-d1e9cfa5be0c, c937fdc3-18e8-47f3-9e34-e1ff3165d67d, 266dd388-ce84-428e-ba4a-a45a55005f23]
Query: ReadAllQuery(referenceClass=CategoryAttributeValue sql="SELECT t1.ID, t1.BOOLEAN_VALUE, t1.CODE, t1.CREATE_TS, t1.CREATED_BY, t1.DATE_VALUE, t1.DELETE_TS, t1.DELETED_BY, t1.DOUBLE_VALUE, t1.INTEGER_VALUE, t1.STRING_VALUE, t1.UPDATE_TS, t1.UPDATED_BY, t1.VERSION, t1.ENTITY_ID, t1.INT_ENTITY_ID, t1.LONG_ENTITY_ID, t1.STRING_ENTITY_ID, t1.ENTITY_VALUE, t1.INT_ENTITY_VALUE, t1.LONG_ENTITY_VALUE, t1.STRING_ENTITY_VALUE, t1.CATEGORY_ATTR_ID, t1.PARENT_ID, t0.ID, t0.CATEGORY_ENTITY_TYPE, t0.CODE, t0.CREATE_TS, t0.CREATED_BY, t0.DATA_TYPE, t0.DEFAULT_BOOLEAN, t0.DEFAULT_DATE, t0.DEFAULT_DATE_IS_CURRENT, t0.DEFAULT_DOUBLE, t0.DEFAULT_INT, t0.DEFAULT_STRING, t0.DELETE_TS, t0.DELETED_BY, t0.ENTITY_CLASS, t0.ENUMERATION, t0.FILTER_XML, t0.IS_COLLECTION, t0.JOIN_CLAUSE, t0.LOOKUP, t0.NAME, t0.ORDER_NO, t0.REQUIRED, t0.ROWS_COUNT, t0.SCREEN, t0.TARGET_SCREENS, t0.UPDATE_TS, t0.UPDATED_BY, t0.VERSION, t0.WHERE_CLAUSE, t0.WIDTH, t0.DEFAULT_ENTITY_VALUE, t0.DEFAULT_INT_ENTITY_VALUE, t0.DEFAULT_LONG_ENTITY_VALUE, t0.DEFAULT_STR_ENTITY_VALUE, t0.CATEGORY_ID, t2.ID, t2.DISCRIMINATOR, t2.CREATE_TS, t2.CREATED_BY, t2.DELETE_TS, t2.DELETED_BY, t2.ENTITY_TYPE, t2.IS_DEFAULT, t2.NAME, t2.SPECIAL, t2.UPDATE_TS, t2.UPDATED_BY, t2.VERSION FROM SYS_ATTR_VALUE t1 LEFT OUTER JOIN SYS_CATEGORY_ATTR t0 ON (t0.ID = t1.CATEGORY_ATTR_ID) LEFT OUTER JOIN SYS_CATEGORY t2 ON (t2.ID = t0.CATEGORY_ID) WHERE (((t1.ENTITY_ID IN ?) AND (t1.PARENT_ID IS NULL)) AND (t1.DELETE_TS IS NULL))")
---
org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: org.postgresql.util.PSQLException: ERROR: column t1.int_entity_id does not exist
Position: 222
Error Code: 0
Call: SELECT t1.ID, t1.BOOLEAN_VALUE, t1.CODE, t1.CREATE_TS, t1.CREATED_BY, t1.DATE_VALUE, t1.DELETE_TS, t1.DELETED_BY, t1.DOUBLE_VALUE, t1.INTEGER_VALUE, t1.STRING_VALUE, t1.UPDATE_TS, t1.UPDATED_BY, t1.VERSION, t1.ENTITY_ID, t1.INT_ENTITY_ID, t1.LONG_ENTITY_ID, t1.STRING_ENTITY_ID, t1.ENTITY_VALUE, t1.INT_ENTITY_VALUE, t1.LONG_ENTITY_VALUE, t1.STRING_ENTITY_VALUE, t1.CATEGORY_ATTR_ID, t1.PARENT_ID, t0.ID, t0.CATEGORY_ENTITY_TYPE, t0.CODE, t0.CREATE_TS, t0.CREATED_BY, t0.DATA_TYPE, t0.DEFAULT_BOOLEAN, t0.DEFAULT_DATE, t0.DEFAULT_DATE_IS_CURRENT, t0.DEFAULT_DOUBLE, t0.DEFAULT_INT, t0.DEFAULT_STRING, t0.DELETE_TS, t0.DELETED_BY, t0.ENTITY_CLASS, t0.ENUMERATION, t0.FILTER_XML, t0.IS_COLLECTION, t0.JOIN_CLAUSE, t0.LOOKUP, t0.NAME, t0.ORDER_NO, t0.REQUIRED, t0.ROWS_COUNT, t0.SCREEN, t0.TARGET_SCREENS, t0.UPDATE_TS, t0.UPDATED_BY, t0.VERSION, t0.WHERE_CLAUSE, t0.WIDTH, t0.DEFAULT_ENTITY_VALUE, t0.DEFAULT_INT_ENTITY_VALUE, t0.DEFAULT_LONG_ENTITY_VALUE, t0.DEFAULT_STR_ENTITY_VALUE, t0.CATEGORY_ID, t2.ID, t2.DISCRIMINATOR, t2.CREATE_TS, t2.CREATED_BY, t2.DELETE_TS, t2.DELETED_BY, t2.ENTITY_TYPE, t2.IS_DEFAULT, t2.NAME, t2.SPECIAL, t2.UPDATE_TS, t2.UPDATED_BY, t2.VERSION FROM SYS_ATTR_VALUE t1 LEFT OUTER JOIN SYS_CATEGORY_ATTR t0 ON (t0.ID = t1.CATEGORY_ATTR_ID) LEFT OUTER JOIN SYS_CATEGORY t2 ON (t2.ID = t0.CATEGORY_ID) WHERE (((t1.ENTITY_ID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (t1.PARENT_ID IS NULL)) AND (t1.DELETE_TS IS NULL))
bind => [5073902b-0976-41b9-96da-1841e29051dc, aca2ebd3-c85e-4964-81a1-b2a72c0da9a0, 4b4d5d6a-57f9-4a46-92fe-9a5db92eb037, fbfec283-542f-407e-b5e4-4e5b92459b12, 05bddc4c-fd98-4ae6-b920-2dba45c38271, 340b6cfe-aa83-479e-8457-c2bb09e686c8, e22b125f-19fb-44c0-be34-c912712975ea, 2fd4db65-4e40-4475-90fd-bfe548f8ab69, f72e32ee-8046-4241-933f-8bc22b992053, cfc3e1d0-a763-4644-985f-0a8979eac638, 8a16b235-ff6c-47a4-839b-cf6248ad15ee, 6d158e5c-940b-4ba0-80c2-bc4a3e7cc743, 14eb2b2d-33b2-4b71-a779-a3e57cd2c87e, c5bcae4e-ca3f-487e-8703-3f83a156b9d3, 3be59fc5-b131-4efe-9bf5-045274c524f4, 8a42d39c-ba78-4f8c-90f6-d1e9cfa5be0c, c937fdc3-18e8-47f3-9e34-e1ff3165d67d, 266dd388-ce84-428e-ba4a-a45a55005f23]
Query: ReadAllQuery(referenceClass=CategoryAttributeValue sql="SELECT t1.ID, t1.BOOLEAN_VALUE, t1.CODE, t1.CREATE_TS, t1.CREATED_BY, t1.DATE_VALUE, t1.DELETE_TS, t1.DELETED_BY, t1.DOUBLE_VALUE, t1.INTEGER_VALUE, t1.STRING_VALUE, t1.UPDATE_TS, t1.UPDATED_BY, t1.VERSION, t1.ENTITY_ID, t1.INT_ENTITY_ID, t1.LONG_ENTITY_ID, t1.STRING_ENTITY_ID, t1.ENTITY_VALUE, t1.INT_ENTITY_VALUE, t1.LONG_ENTITY_VALUE, t1.STRING_ENTITY_VALUE, t1.CATEGORY_ATTR_ID, t1.PARENT_ID, t0.ID, t0.CATEGORY_ENTITY_TYPE, t0.CODE, t0.CREATE_TS, t0.CREATED_BY, t0.DATA_TYPE, t0.DEFAULT_BOOLEAN, t0.DEFAULT_DATE, t0.DEFAULT_DATE_IS_CURRENT, t0.DEFAULT_DOUBLE, t0.DEFAULT_INT, t0.DEFAULT_STRING, t0.DELETE_TS, t0.DELETED_BY, t0.ENTITY_CLASS, t0.ENUMERATION, t0.FILTER_XML, t0.IS_COLLECTION, t0.JOIN_CLAUSE, t0.LOOKUP, t0.NAME, t0.ORDER_NO, t0.REQUIRED, t0.ROWS_COUNT, t0.SCREEN, t0.TARGET_SCREENS, t0.UPDATE_TS, t0.UPDATED_BY, t0.VERSION, t0.WHERE_CLAUSE, t0.WIDTH, t0.DEFAULT_ENTITY_VALUE, t0.DEFAULT_INT_ENTITY_VALUE, t0.DEFAULT_LONG_ENTITY_VALUE, t0.DEFAULT_STR_ENTITY_VALUE, t0.CATEGORY_ID, t2.ID, t2.DISCRIMINATOR, t2.CREATE_TS, t2.CREATED_BY, t2.DELETE_TS, t2.DELETED_BY, t2.ENTITY_TYPE, t2.IS_DEFAULT, t2.NAME, t2.SPECIAL, t2.UPDATE_TS, t2.UPDATED_BY, t2.VERSION FROM SYS_ATTR_VALUE t1 LEFT OUTER JOIN SYS_CATEGORY_ATTR t0 ON (t0.ID = t1.CATEGORY_ATTR_ID) LEFT OUTER JOIN SYS_CATEGORY t2 ON (t2.ID = t0.CATEGORY_ID) WHERE (((t1.ENTITY_ID IN ?) AND (t1.PARENT_ID IS NULL)) AND (t1.DELETE_TS IS NULL))")
---
org.postgresql.util.PSQLException: ERROR: column t1.int_entity_id does not exist
Position: 222
at com.haulmont.cuba.core.sys.ServiceInterceptor.aroundInvoke(ServiceInterceptor.java:127)
at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy219.loadList(Unknown Source)
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 com.haulmont.cuba.core.sys.remoting.LocalServiceInvokerImpl.invoke(LocalServiceInvokerImpl.java:94)
at com.haulmont.cuba.web.sys.remoting.LocalServiceProxy$LocalServiceInvocationHandler.invoke(LocalServiceProxy.java:148)
at com.sun.proxy.$Proxy25.loadList(Unknown Source)
at com.haulmont.cuba.client.sys.DataManagerClientImpl.loadList(DataManagerClientImpl.java:53)
at com.haulmont.cuba.gui.data.impl.GenericDataSupplier.loadList(GenericDataSupplier.java:102)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.loadData(CollectionDatasourceImpl.java:587)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(CollectionDatasourceImpl.java:146)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(CollectionDatasourceImpl.java:106)
at com.haulmont.cuba.gui.app.core.entityinspector.EntityInspectorBrowse.lambda$createButtonsPanel$4(EntityInspectorBrowse.java:370)
at com.haulmont.bali.events.EventRouter.fireEvent(EventRouter.java:45)
at com.haulmont.cuba.web.gui.components.WebFileUploadField.fireFileUploadSucceed(WebFileUploadField.java:443)
at com.haulmont.cuba.web.gui.components.WebFileUploadField.lambda$initUploadButton$982e378a$1(WebFileUploadField.java:264)
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 com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:200)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:163)
at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1037)
at com.haulmont.cuba.web.toolkit.ui.CubaFileUpload.fireUploadSuccess(CubaFileUpload.java:474)
at com.haulmont.cuba.web.toolkit.ui.CubaFileUpload$1.fileUploaded(CubaFileUpload.java:72)
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 com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:158)
at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:119)
at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:444)
at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:409)
at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274)
at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:90)
at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:41)
at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1422)
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:385)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.serviceAppRequest(CubaApplicationServlet.java:278)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.service(CubaApplicationServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at com.haulmont.cuba.web.sys.CubaHttpFilter.handleNotFiltered(CubaHttpFilter.java:108)
at com.haulmont.cuba.web.sys.CubaHttpFilter.doFilter(CubaHttpFilter.java:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1437)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
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)