phoss-smp icon indicating copy to clipboard operation
phoss-smp copied to clipboard

Published 20 hours ago • verified publisher icon phax

Error in creating & deleting service group

Open MengXinAlex opened this issue 1 year ago • 4 comments

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:

  • SMP Version: 7.1.1
  • JDK Version: 21.0.1

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'

MengXinAlex avatar Mar 20 '24 06:03 MengXinAlex

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

phax avatar Mar 20 '24 07:03 phax

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

skizub avatar May 02 '24 16:05 skizub

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

phax avatar May 02 '24 16:05 phax

@MengXinAlex were you able to resolve your issue?

phax avatar May 02 '24 16:05 phax