ERROR: null value in column "webui_dashboard_id" violates not-null constraint

Hallo zusammen,
ich habe frisch Metasfresh auf Ubuntu mit Docker installiert benutze zusätzlich SSL und habe die Ports auf 8443 und 8080 gelegt. Docker ps zeigt mir alle Dienste laufend , aber ich bekomme beim Platzieren von Widgets immer folgende Fehlermeldung:

ERROR: null value in column "webui_dashboard_id" violates not-null constraint
  Detail: Failing row contains (1000000, 1000000, 2020-10-19 14:29:02+02, 100, Y, Orders net amount, 2020-10-19 14:29:02+02, 100, null, null, 1000024, 10, T, 1000002, null, null).
	SQL: INSERT INTO WEBUI_DashboardItem (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,Name,SeqNo,Updated,UpdatedBy,WEBUI_DashboardItem_ID,WEBUI_DashboardWidgetType,WEBUI_KPI_ID) VALUES (1000000,1000000,TO_TIMESTAMP('2020-10-19 14:29:02','YYYY-MM-DD HH24:MI:SS'),100,'Y','Orders net amount',10,TO_TIMESTAMP('2020-10-19 14:29:02','YYYY-MM-DD HH24:MI:SS'),100,nextval('webui_dashboarditem_seq'),'T',1000002) RETURNING WEBUI_DashboardItem_ID

Uncaught (in promise) Error: Request failed with status code 500

**Kann mir einer weiterhelfen? Ich habe bereits die Datenbanken gelöscht in Volumes und mit docker-compose build/up -d bekomme ich auch keine Fehlermeldungen. **
Ich habe aber in den Logs mehrere Fehlermeldungen:

2020-10-19 11:54:52.949  WARN 19 --- [http-nio-8080-exec-10] o.adempiere.ad.trx.api.impl.TrxManager   : AbstractTrxManager.call0 - caught class org.adempiere.exceptions.DBException with message=ERROR: null value in column "webui_dashboard_id" violates not-null constraint
  Detail: Failing row contains (1000000, 1000000, 2020-10-19 11:54:52+02, 100, Y, Orders net amount, 2020-10-19 11:54:52+02, 100, null, null, 1000025, 10, T, 1000002, null, null).
        SQL: INSERT INTO WEBUI_DashboardItem (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,Name,SeqNo,Updated,UpdatedBy,WEBUI_DashboardItem_ID,WEBUI_DashboardWidgetType,WEBUI_KPI_ID) VALUES (1000000,1000000,TO_TIMESTAMP('2020-10-19 11:54:52','YYYY-MM-DD HH24:MI:SS'),100,'Y','Orders net amount',10,TO_TIMESTAMP(>

org.adempiere.exceptions.DBException: ERROR: null value in column "webui_dashboard_id" violates not-null constraint
  Detail: Failing row contains (1000000, 1000000, 2020-10-19 11:54:52+02, 100, Y, Orders net amount, 2020-10-19 11:54:52+02, 100, null, null, 1000025, 10, T, 1000002, null, null).
        SQL: INSERT INTO WEBUI_DashboardItem (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,Name,SeqNo,Updated,UpdatedBy,WEBUI_DashboardItem_ID,WEBUI_DashboardWidgetType,WEBUI_KPI_ID) VALUES (1000000,1000000,TO_TIMESTAMP('2020-10-19 11:54:52','YYYY-MM-DD HH24:MI:SS'),100,'Y','Orders net amount',10,TO_TIMESTAMP(>
        at org.adempiere.exceptions.DBException.wrapIfNeeded(DBException.java:92)
        at org.compiere.util.DB.executeUpdate(DB.java:974)
        at org.compiere.model.PO.saveNew(PO.java:3844)
        at org.compiere.model.PO.save0(PO.java:2996)
        at org.compiere.model.PO.access$100(PO.java:144)
  at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:167)
        at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        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:478)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "webui_dashboard_id" violates not-null constraint
  Detail: Failing row contains (1000000, 1000000, 2020-10-19 11:54:52+02, 100, Y, Orders net amount, 2020-10-19 11:54:52+02, 100, null, null, 1000025, 10, T, 1000002, null, null).
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2241)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:158)
        at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:108)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
        at org.adempiere.sql.impl.CPreparedStatementProxy.executeQuery(CPreparedStatementProxy.java:124)
        at org.adempiere.sql.impl.CPreparedStatementProxy.executeQueryAndLogMigationScripts(CPreparedStatementProxy.java:131)
        at org.compiere.util.DB.executeUpdate(DB.java:887)
        ... 110 common frames omitted

2020-10-19 11:54:52.967  WARN 19 --- [http-nio-8080-exec-10] d.m.ui.web.config.WebuiExceptionHandler  : Got REST exception from handler=public de.metas.ui.web.dashboard.json.JSONDashboardItem de.metas.ui.web.dashboard.DashboardRestController.addTargetIndicatorItem(de.metas.ui.web.dashboard.json.JsonUserDashboardIte>


        at org.compiere.model.PO$1.run(PO.java:2899)
        at org.adempiere.ad.trx.api.impl.TrxCallableWrappers$3.call(TrxCallableWrappers.java:147)
        at org.adempiere.ad.trx.api.impl.TrxCallableWrappers$3.call(TrxCallableWrappers.java:137)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call0(AbstractTrxManager.java:753)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:666)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:567)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:498)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.run(AbstractTrxManager.java:484)
        at org.compiere.model.PO.saveEx(PO.java:2893)
        at org.adempiere.model.POWrapper.save(POWrapper.java:798)
        at org.adempiere.model.InterfaceWrapperHelper.save(InterfaceWrapperHelper.java:620)
        at de.metas.ui.web.dashboard.UserDashboardRepository.createUserDashboardItemAndSave(UserDashboardRepository.java:427)
        at de.metas.ui.web.dashboard.UserDashboardRepository.lambda$addUserDashboardItem$6(UserDashboardRepository.java:377)
        at de.metas.ui.web.dashboard.UserDashboardRepository.lambda$executeChangeActionAndInvalidateAndReturn$4(UserDashboardRepository.java:281)
        at com.google.common.collect.ImmutableList.forEach(ImmutableList.java:408)
        at de.metas.ui.web.dashboard.UserDashboardRepository.lambda$executeChangeActionsAndInvalidate$3(UserDashboardRepository.java:264)
        at org.adempiere.ad.trx.api.impl.TrxCallableWrappers$1.call(TrxCallableWrappers.java:58)
        at org.adempiere.ad.trx.api.impl.TrxCallableWrappers$1.call(TrxCallableWrappers.java:48)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call0(AbstractTrxManager.java:753)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:666)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:567)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.call(AbstractTrxManager.java:498)
        at org.adempiere.ad.trx.api.impl.AbstractTrxManager.run(AbstractTrxManager.java:491)
        at de.metas.ui.web.dashboard.UserDashboardRepository.executeChangeActionsAndInvalidate(UserDashboardRepository.java:263)
        at de.metas.ui.web.dashboard.UserDashboardRepository.executeChangeActionAndInvalidateAndReturn(UserDashboardRepository.java:289)
        at de.metas.ui.web.dashboard.UserDashboardRepository.addUserDashboardItem(UserDashboardRepository.java:374)
        at de.metas.ui.web.dashboard.DashboardRestController.addDashboardItem(DashboardRestController.java:192)
        at de.metas.ui.web.dashboard.DashboardRestController.addTargetIndicatorItem(DashboardRestController.java:184)
        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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at de.metas.ui.web.config.WebConfig$1.doFilter(WebConfig.java:82)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at de.metas.ui.web.config.CORSFilter.doFilter(CORSFilter.java:79)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at de.metas.ui.web.config.ServletLoggingFilter.doFilter(ServletLoggingFilter.java:91)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Vielen Dank im Vorraus!
MFG

Hi,

das gleiche Problem habe ich auch. Sogar mit einer ganz frischen Installation (Stand heute) von Metasfresh (Docker). Ich bin nicht in der Lage Widgets zu platzieren. Jedes mal tritt dieser Fehler mit der gleichen Exception auf (auch mit unterschiedlichen Nutzern). Anscheinend wird der SQL-Befehl ohne die nötige webui_dashboard_id ausgeführt. Ich habe den Befehl manuell ausgeführt und die Dashboard-ID selbst hinzugefügt. Das Widget taucht danach trotzdem nicht auf.

Viele Grüße

Kevin