search

phax / phoss-smp

phoss SMP - a Peppol and OASIS BDXR SMP Server, CEF eDelivery compliant
125 stars 36 forks source link

Error in creating & deleting service group #273

Closed MengXinAlex closed 2 weeks ago

MengXinAlex commented 3 months ago

Hi

I'm experiencing strange behaviour on SMP TEST. I can create and delete endpoints, but I am unable to create and delete service groups.

Environment details:

image

Stack Trace:

[WARN ] 2024-03-20 06:19:09.242 [jetty-server-24] SMPCommonUI - Technical details
com.helger.phoss.smp.exception.SMPInternalErrorException: Error creating ServiceGroup 'iso6523-actorid-upis::0151:testggg'
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:200) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:74) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.ui.secure.PageSecureServiceGroup.validateAndSaveInputParameters(PageSecureServiceGroup.java:612) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.ui.secure.PageSecureServiceGroup.validateAndSaveInputParameters(PageSecureServiceGroup.java:116) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.uicore.page.AbstractWebPageForm.fillContent(AbstractWebPageForm.java:1253) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.uicore.page.AbstractWebPage.getContent(AbstractWebPage.java:162) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.bootstrap4.uictrls.ext.BootstrapPageRenderer.getPageContent(BootstrapPageRenderer.java:133) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.bootstrap4.uictrls.ext.BootstrapPageRenderer.getPageContent(BootstrapPageRenderer.java:160) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.ui.secure.SMPRendererSecure.getContent(SMPRendererSecure.java:227) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.ui.SMPLayoutHTMLProvider.fillBody(SMPLayoutHTMLProvider.java:70) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.core.html.AbstractSWECHTMLProvider.fillHeadAndBody(AbstractSWECHTMLProvider.java:106) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.core.html.AbstractHTMLProvider.createHTML(AbstractHTMLProvider.java:164) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.app.html.PhotonHTMLHelper.createHTMLResponse(PhotonHTMLHelper.java:117) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.photon.core.servlet.AbstractApplicationXServletHandler.handleRequest(AbstractApplicationXServletHandler.java:102) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.servlet.SMPApplicationXServletHandler.handleRequest(SMPApplicationXServletHandler.java:81) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.xservlet.handler.simple.XServletHandlerToSimpleHandler.onRequest(XServletHandlerToSimpleHandler.java:241) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.xservlet.AbstractXServlet._invokeHandler(AbstractXServlet.java:355) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.xservlet.AbstractXServlet.service(AbstractXServlet.java:540) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:587) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.xservlet.AbstractXServlet.service(AbstractXServlet.java:596) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1419) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.web.servlets.scope.AbstractScopeAwareFilter.doHttpFilter(AbstractScopeAwareFilter.java:82) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.xservlet.AbstractXFilter.doHttpFilter(AbstractXFilter.java:190) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:210) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.servlet.filter.CharacterEncodingFilter.doHttpFilter(CharacterEncodingFilter.java:184) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:131) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:578) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:223) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1381) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1303) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:51) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.Server.handle(Server.java:563) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at java.lang.Thread.run(Thread.java:1583) [?:?]
Caused by: java.sql.SQLException: Caught exception while perfoming something in a level 1 transaction [22]
    at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:652) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:536) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:480) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    ... 67 more
Caused by: com.helger.phoss.smp.smlhook.RegistrationHookException: Could not create business iso6523-actorid-upis::0151:testggg in SML
    at com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:132) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.lambda$createSMPServiceGroup$0(SMPServiceGroupManagerJDBC.java:154) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:598) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:536) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:480) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    ... 67 more
Caused by: com.sun.xml.ws.client.ClientTransportException: HTTP transport error: java.net.SocketException: Unexpected end of file from server
    at com.sun.xml.ws.transport.http.client.HttpClientTransport.getOutput(HttpClientTransport.java:103) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.transport.http.client.HttpTransportPipe.process(HttpTransportPipe.java:209) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.transport.http.client.HttpTransportPipe.processRequest(HttpTransportPipe.java:131) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.transport.DeferredTransportPipe.processRequest(DeferredTransportPipe.java:111) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:1106) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:1020) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:989) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:847) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.Stub.process(Stub.java:431) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SEIStub.doProcess(SEIStub.java:160) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:78) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:62) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:132) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at jdk.proxy2.$Proxy61.create(Unknown Source) ~[?:?]
    at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:173) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:139) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:120) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.lambda$createSMPServiceGroup$0(SMPServiceGroupManagerJDBC.java:154) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:598) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:536) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:480) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    ... 67 more
Caused by: java.net.SocketException: Unexpected end of file from server
    at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:955) ~[?:?]
    at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:759) ~[?:?]
    at sun.net.www.protocol.http.HttpURLConnection.doTunneling0(HttpURLConnection.java:2179) ~[?:?]
    at sun.net.www.protocol.http.HttpURLConnection.doTunneling(HttpURLConnection.java:2143) ~[?:?]
    at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185) ~[?:?]
    at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(HttpURLConnection.java:1446) ~[?:?]
    at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1417) ~[?:?]
    at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:219) ~[?:?]
    at com.sun.xml.ws.transport.http.client.HttpClientTransport.getOutput(HttpClientTransport.java:90) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.transport.http.client.HttpTransportPipe.process(HttpTransportPipe.java:209) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.transport.http.client.HttpTransportPipe.processRequest(HttpTransportPipe.java:131) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.transport.DeferredTransportPipe.processRequest(DeferredTransportPipe.java:111) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:1106) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:1020) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:989) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:847) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.Stub.process(Stub.java:431) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SEIStub.doProcess(SEIStub.java:160) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:78) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:62) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:132) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at jdk.proxy2.$Proxy61.create(Unknown Source) ~[?:?]
    at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:173) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:139) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:120) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.lambda$createSMPServiceGroup$0(SMPServiceGroupManagerJDBC.java:154) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:598) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:536) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:480) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[peppol-smp-server-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
    ... 67 more
[DEBUG] 2024-03-20 06:19:09.269 [jetty-server-29] SMPRestFilter - REST Filter path variants:
[DEBUG] 2024-03-20 06:19:09.269 [jetty-server-29] SMPRestFilter - a) /secure/locale-en_US/menuitem-service_groups
[DEBUG] 2024-03-20 06:19:09.269 [jetty-server-29] SMPRestFilter - b) http://smptest.xaana.net/secure/locale-en_US/menuitem-service_groups
[DEBUG] 2024-03-20 06:19:09.269 [jetty-server-29] SMPRestFilter - c) /secure/locale-en_US/menuitem-service_groups
[DEBUG] 2024-03-20 06:19:09.269 [jetty-server-29] SMPRestFilter - d) http://smptest.xaana.net/secure/locale-en_US/menuitem-service_groups
[DEBUG] 2024-03-20 06:19:09.269 [jetty-server-29] SMPRestFilter - e) /secure/locale-en_US/menuitem-service_groups
[DEBUG] 2024-03-20 06:19:09.270 [jetty-server-29] SMPRestFilter - f) http://smptest.xaana.net/secure/locale-en_US/menuitem-service_groups
[DEBUG] 2024-03-20 06:19:09.270 [jetty-server-29] SMPRestFilter - [REST API] Ignoring '/secure/locale-en_US/menuitem-service_groups' because it is an application internal path.
[DEBUG] 2024-03-20 06:19:09.272 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.connections'
[DEBUG] 2024-03-20 06:19:09.272 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.transactions'
[DEBUG] 2024-03-20 06:19:09.273 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.sql'
[DEBUG] 2024-03-20 06:19:09.274 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.enabled' with value 'true' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.274 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.ms' with value '5000' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.277 [jetty-server-29] SMPConfig - Failed to find Configuration key 'csp.enabled'
[DEBUG] 2024-03-20 06:19:09.278 [jetty-server-29] SMPConfig - Failed to find Configuration key 'csp.reporting.only'
[DEBUG] 2024-03-20 06:19:09.278 [jetty-server-29] SMPConfig - Failed to find Configuration key 'csp.reporting.enabled'
[DEBUG] 2024-03-20 06:19:09.279 [jetty-server-29] SMPConfig - Found Configuration key 'sml.smpid' with value 'XAANA-SMP-ID-TEST' and prio 200 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.280 [jetty-server-29] SMPSettingsManagerJDBC$SettingsSingleton - Loading SMP settings from DB
[DEBUG] 2024-03-20 06:19:09.281 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.connections'
[DEBUG] 2024-03-20 06:19:09.282 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.transactions'
[DEBUG] 2024-03-20 06:19:09.282 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.sql'
[DEBUG] 2024-03-20 06:19:09.282 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.enabled' with value 'true' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.283 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.ms' with value '5000' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.284 [jetty-server-29] SMPSettingsManagerJDBC$SettingsSingleton - Reusing SMP settings of request
[DEBUG] 2024-03-20 06:19:09.285 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.connections'
[DEBUG] 2024-03-20 06:19:09.285 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.transactions'
[DEBUG] 2024-03-20 06:19:09.286 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.sql'
[DEBUG] 2024-03-20 06:19:09.286 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.enabled' with value 'true' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.286 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.ms' with value '5000' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.287 [jetty-server-29] SMPSettingsManagerJDBC$SettingsSingleton - Reusing SMP settings of request
[DEBUG] 2024-03-20 06:19:09.287 [jetty-server-29] SMPConfig - Found Configuration key 'smp.rest.type' with value 'peppol' and prio 200 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.288 [jetty-server-29] SMPConfig - Found Configuration key 'webapp.servicegroups.extensions.show' with value 'false' and prio 200 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.288 [jetty-server-29] SMPServiceGroupManagerJDBC - getAllSMPServiceGroups()
[DEBUG] 2024-03-20 06:19:09.288 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.connections'
[DEBUG] 2024-03-20 06:19:09.289 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.transactions'
[DEBUG] 2024-03-20 06:19:09.289 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.sql'
[DEBUG] 2024-03-20 06:19:09.289 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.enabled' with value 'true' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.289 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.ms' with value '5000' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.293 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.connections'
[DEBUG] 2024-03-20 06:19:09.294 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.transactions'
[DEBUG] 2024-03-20 06:19:09.294 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.sql'
phax commented 3 months ago

Hi @MengXinAlex. It seems like you are missing the configuration items for the database connection etc. Please check https://github.com/phax/phoss-smp/wiki/Configuration and make sure that all the required properties are set. See e.g.

[DEBUG] 2024-03-20 06:19:09.272 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.connections'
[DEBUG] 2024-03-20 06:19:09.272 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.transactions'
[DEBUG] 2024-03-20 06:19:09.273 [jetty-server-29] SMPConfig - Failed to find Configuration key 'jdbc.debug.sql'
[DEBUG] 2024-03-20 06:19:09.274 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.enabled' with value 'true' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.274 [jetty-server-29] SMPConfig - Found Configuration key 'jdbc.execution-time-warning.ms' with value '5000' and prio 180 in RESOURCE
[DEBUG] 2024-03-20 06:19:09.277 [jetty-server-29] SMPConfig - Failed to find Configuration key 'csp.enabled'
[DEBUG] 2024-03-20 06:19:09.278 [jetty-server-29] SMPConfig - Failed to find Configuration key 'csp.reporting.only'
[DEBUG] 2024-03-20 06:19:09.278 [jetty-server-29] SMPConfig - Failed to find Configuration key 'csp.reporting.enabled'

In general it seems like the configuration file could not be found.

Please make sure to to provide the configuration file properly. See e.g. https://github.com/phax/phoss-smp/tree/master/docker#smp-file-storage for how to provide the configuration file in.

hth

skizub commented 1 month ago

Hi Philip, a very similar problem: image

SMP server version 7.1.1 with SQL backend: On JDBC settings: amended after checking your post above - no luck: image

In logs: image

Database user must have full access to database schema. All database tables were created during server startup: image

phax commented 1 month ago

@skizub I extracted this in a fresh issue. Please don't reuse issues.

phax commented 1 month ago

@MengXinAlex were you able to resolve your issue?