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