Error when creating a Service Group #242

mcherri · 2023-04-23T18:31:25Z

mcherri
Apr 23, 2023

Hi,

I am trying to register a new Service Group, but getting the following error. I tried to follow the advice given in this issue and upgraded to version 6.0.7. We use the dockerized version. Did I miss something? It was working about one year before.

The corresponding stack trace is as follows.

[2023-04-23T18:06:23,505] [SMP-SERVER] [INFO ] [http-nio-8080-exec-1] Trying to CREATE business iso6523-actorid-upis::    :              for                          in SML -- com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:120)
[2023-04-23T18:06:23,505] [SMP-SERVER] [INFO ] [http-nio-8080-exec-1] Performing SML query to 'https://acc.edelivery.tech.ec.europa.eu/edelivery-sml/manageparticipantidentifier' -- com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML._createSMLCaller(RegistrationHookWriteToSML.java:68)
[2023-04-23T18:06:23,522] [SMP-SERVER] [INFO ] [http-nio-8080-exec-1] Trying to create new participant iso6523-actorid-upis::    :              in SMP '                         ' -- com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:167)
[2023-04-23T18:06:24,872] [SMP-SERVER] [ERROR] [http-nio-8080-exec-1] An exception was thrown -- com.helger.commons.log.LogHelper.log(LogHelper.java:315)
java.sql.SQLException: Caught exception while perfoming something in a level 1 transaction [42]
	at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:652) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:541) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:486) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:74) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.ui.secure.PageSecureServiceGroup.validateAndSaveInputParameters(PageSecureServiceGroup.java:612) ~[phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.ui.secure.PageSecureServiceGroup.validateAndSaveInputParameters(PageSecureServiceGroup.java:116) ~[phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.photon.uicore.page.AbstractWebPageForm.fillContent(AbstractWebPageForm.java:1253) ~[ph-oton-uicore-8.4.5.jar:8.4.5]
	at com.helger.photon.uicore.page.AbstractWebPage.getContent(AbstractWebPage.java:162) ~[ph-oton-uicore-8.4.5.jar:8.4.5]
	at com.helger.photon.bootstrap4.uictrls.ext.BootstrapPageRenderer.getPageContent(BootstrapPageRenderer.java:133) ~[ph-oton-bootstrap4-uictrls-8.4.5.jar:8.4.5]
	at com.helger.photon.bootstrap4.uictrls.ext.BootstrapPageRenderer.getPageContent(BootstrapPageRenderer.java:160) ~[ph-oton-bootstrap4-uictrls-8.4.5.jar:8.4.5]
	at com.helger.phoss.smp.ui.secure.SMPRendererSecure.getContent(SMPRendererSecure.java:227) ~[phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.ui.SMPLayoutHTMLProvider.fillBody(SMPLayoutHTMLProvider.java:70) [phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.photon.core.html.AbstractSWECHTMLProvider.fillHeadAndBody(AbstractSWECHTMLProvider.java:106) [ph-oton-core-8.4.5.jar:8.4.5]
	at com.helger.photon.core.html.AbstractHTMLProvider.createHTML(AbstractHTMLProvider.java:164) [ph-oton-core-8.4.5.jar:8.4.5]
	at com.helger.photon.app.html.PhotonHTMLHelper.createHTMLResponse(PhotonHTMLHelper.java:117) [ph-oton-app-8.4.5.jar:8.4.5]
	at com.helger.photon.core.servlet.AbstractApplicationXServletHandler.handleRequest(AbstractApplicationXServletHandler.java:101) [ph-oton-core-8.4.5.jar:8.4.5]
	at com.helger.phoss.smp.servlet.SMPApplicationXServletHandler.handleRequest(SMPApplicationXServletHandler.java:81) [phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.xservlet.handler.simple.XServletHandlerToSimpleHandler.onRequest(XServletHandlerToSimpleHandler.java:245) [ph-xservlet-9.7.2.jar:9.7.2]
	at com.helger.xservlet.AbstractXServlet._invokeHandler(AbstractXServlet.java:345) [ph-xservlet-9.7.2.jar:9.7.2]
	at com.helger.xservlet.AbstractXServlet.service(AbstractXServlet.java:533) [ph-xservlet-9.7.2.jar:9.7.2]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) [servlet-api.jar:4.0.FR]
	at com.helger.xservlet.AbstractXServlet.service(AbstractXServlet.java:587) [ph-xservlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at com.helger.web.servlets.scope.AbstractScopeAwareFilter.doHttpFilter(AbstractScopeAwareFilter.java:81) [ph-web-9.7.2.jar:9.7.2]
	at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) [ph-servlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at com.helger.xservlet.AbstractXFilter.doHttpFilter(AbstractXFilter.java:189) [ph-xservlet-9.7.2.jar:9.7.2]
	at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) [ph-servlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at com.helger.servlet.filter.CharacterEncodingFilter.doHttpFilter(CharacterEncodingFilter.java:187) [ph-servlet-9.7.2.jar:9.7.2]
	at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) [ph-servlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.20.0.jar:2.20.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:9.0.71]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:9.0.71]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.71]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:9.0.71]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) [catalina.jar:9.0.71]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) [tomcat-coyote.jar:9.0.71]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.71]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) [tomcat-coyote.jar:9.0.71]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) [tomcat-coyote.jar:9.0.71]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.71]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:9.0.71]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:9.0.71]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.71]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: com.helger.phoss.smp.smlhook.RegistrationHookException: Could not create business iso6523-actorid-upis::    :              in SML
	at com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:137) ~[phoss-smp-backend-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.lambda$createSMPServiceGroup$0(SMPServiceGroupManagerJDBC.java:154) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:604) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	... 60 more
Caused by: com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: Unauthorized
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.checkStatusCode(HttpTransportPipe.java:307) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.createResponsePacket(HttpTransportPipe.java:249) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.process(HttpTransportPipe.java:207) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.processRequest(HttpTransportPipe.java:120) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.DeferredTransportPipe.processRequest(DeferredTransportPipe.java:109) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:1105) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:1019) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:988) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:846) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.Stub.process(Stub.java:432) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SEIStub.doProcess(SEIStub.java:161) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:77) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:61) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:131) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.proxy.$Proxy59.create(Unknown Source) ~[?:?]
	at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:172) ~[peppol-sml-client-8.8.4.jar:8.8.4]
	at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:138) ~[peppol-sml-client-8.8.4.jar:8.8.4]
	at com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:125) ~[phoss-smp-backend-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.lambda$createSMPServiceGroup$0(SMPServiceGroupManagerJDBC.java:154) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:604) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	... 60 more
[2023-04-23T18:06:24,892] [SMP-SERVER] [WARN ] [http-nio-8080-exec-1] Technical details -- com.helger.phoss.smp.ui.SMPCommonUI.getTechnicalDetailsUI(SMPCommonUI.java:380)
com.helger.phoss.smp.exception.SMPInternalErrorException: Error creating ServiceGroup 'iso6523-actorid-upis::    :             '
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:200) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:74) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.ui.secure.PageSecureServiceGroup.validateAndSaveInputParameters(PageSecureServiceGroup.java:612) ~[phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.ui.secure.PageSecureServiceGroup.validateAndSaveInputParameters(PageSecureServiceGroup.java:116) ~[phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.photon.uicore.page.AbstractWebPageForm.fillContent(AbstractWebPageForm.java:1253) ~[ph-oton-uicore-8.4.5.jar:8.4.5]
	at com.helger.photon.uicore.page.AbstractWebPage.getContent(AbstractWebPage.java:162) ~[ph-oton-uicore-8.4.5.jar:8.4.5]
	at com.helger.photon.bootstrap4.uictrls.ext.BootstrapPageRenderer.getPageContent(BootstrapPageRenderer.java:133) ~[ph-oton-bootstrap4-uictrls-8.4.5.jar:8.4.5]
	at com.helger.photon.bootstrap4.uictrls.ext.BootstrapPageRenderer.getPageContent(BootstrapPageRenderer.java:160) ~[ph-oton-bootstrap4-uictrls-8.4.5.jar:8.4.5]
	at com.helger.phoss.smp.ui.secure.SMPRendererSecure.getContent(SMPRendererSecure.java:227) ~[phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.ui.SMPLayoutHTMLProvider.fillBody(SMPLayoutHTMLProvider.java:70) [phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.photon.core.html.AbstractSWECHTMLProvider.fillHeadAndBody(AbstractSWECHTMLProvider.java:106) [ph-oton-core-8.4.5.jar:8.4.5]
	at com.helger.photon.core.html.AbstractHTMLProvider.createHTML(AbstractHTMLProvider.java:164) [ph-oton-core-8.4.5.jar:8.4.5]
	at com.helger.photon.app.html.PhotonHTMLHelper.createHTMLResponse(PhotonHTMLHelper.java:117) [ph-oton-app-8.4.5.jar:8.4.5]
	at com.helger.photon.core.servlet.AbstractApplicationXServletHandler.handleRequest(AbstractApplicationXServletHandler.java:101) [ph-oton-core-8.4.5.jar:8.4.5]
	at com.helger.phoss.smp.servlet.SMPApplicationXServletHandler.handleRequest(SMPApplicationXServletHandler.java:81) [phoss-smp-webapp-6.0.7.jar:6.0.7]
	at com.helger.xservlet.handler.simple.XServletHandlerToSimpleHandler.onRequest(XServletHandlerToSimpleHandler.java:245) [ph-xservlet-9.7.2.jar:9.7.2]
	at com.helger.xservlet.AbstractXServlet._invokeHandler(AbstractXServlet.java:345) [ph-xservlet-9.7.2.jar:9.7.2]
	at com.helger.xservlet.AbstractXServlet.service(AbstractXServlet.java:533) [ph-xservlet-9.7.2.jar:9.7.2]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) [servlet-api.jar:4.0.FR]
	at com.helger.xservlet.AbstractXServlet.service(AbstractXServlet.java:587) [ph-xservlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at com.helger.web.servlets.scope.AbstractScopeAwareFilter.doHttpFilter(AbstractScopeAwareFilter.java:81) [ph-web-9.7.2.jar:9.7.2]
	at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) [ph-servlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at com.helger.xservlet.AbstractXFilter.doHttpFilter(AbstractXFilter.java:189) [ph-xservlet-9.7.2.jar:9.7.2]
	at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) [ph-servlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at com.helger.servlet.filter.CharacterEncodingFilter.doHttpFilter(CharacterEncodingFilter.java:187) [ph-servlet-9.7.2.jar:9.7.2]
	at com.helger.servlet.filter.AbstractHttpServletFilter.doFilter(AbstractHttpServletFilter.java:66) [ph-servlet-9.7.2.jar:9.7.2]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.20.0.jar:2.20.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.71]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:9.0.71]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:9.0.71]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.71]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [catalina.jar:9.0.71]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:9.0.71]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) [catalina.jar:9.0.71]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) [tomcat-coyote.jar:9.0.71]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.71]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) [tomcat-coyote.jar:9.0.71]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) [tomcat-coyote.jar:9.0.71]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.71]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:9.0.71]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:9.0.71]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.71]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.sql.SQLException: Caught exception while perfoming something in a level 1 transaction [42]
	at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:652) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:541) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:486) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	... 56 more
Caused by: com.helger.phoss.smp.smlhook.RegistrationHookException: Could not create business iso6523-actorid-upis::    :              in SML
	at com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:137) ~[phoss-smp-backend-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.lambda$createSMPServiceGroup$0(SMPServiceGroupManagerJDBC.java:154) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:604) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:541) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:486) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	... 56 more
Caused by: com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: Unauthorized
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.checkStatusCode(HttpTransportPipe.java:307) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.createResponsePacket(HttpTransportPipe.java:249) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.process(HttpTransportPipe.java:207) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.http.client.HttpTransportPipe.processRequest(HttpTransportPipe.java:120) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.transport.DeferredTransportPipe.processRequest(DeferredTransportPipe.java:109) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:1105) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:1019) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:988) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:846) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.Stub.process(Stub.java:432) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SEIStub.doProcess(SEIStub.java:161) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:77) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:61) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:131) ~[jaxws-rt-2.3.5.jar:2.3.5]
	at com.sun.proxy.$Proxy59.create(Unknown Source) ~[?:?]
	at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:172) ~[peppol-sml-client-8.8.4.jar:8.8.4]
	at com.helger.peppol.smlclient.ManageParticipantIdentifierServiceCaller.create(ManageParticipantIdentifierServiceCaller.java:138) ~[peppol-sml-client-8.8.4.jar:8.8.4]
	at com.helger.phoss.smp.smlhook.RegistrationHookWriteToSML.createServiceGroup(RegistrationHookWriteToSML.java:125) ~[phoss-smp-backend-6.0.7.jar:6.0.7]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.lambda$createSMPServiceGroup$0(SMPServiceGroupManagerJDBC.java:154) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	at com.helger.db.jdbc.executor.DBExecutor.lambda$performInTransaction$9(DBExecutor.java:604) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withExistingConnectionDo(DBExecutor.java:541) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.withNewConnectionDo(DBExecutor.java:486) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.db.jdbc.executor.DBExecutor.performInTransaction(DBExecutor.java:673) ~[ph-db-jdbc-6.7.4.jar:6.7.4]
	at com.helger.phoss.smp.backend.sql.mgr.SMPServiceGroupManagerJDBC.createSMPServiceGroup(SMPServiceGroupManagerJDBC.java:142) ~[phoss-smp-backend-sql-6.0.7.jar:6.0.7]
	... 56 more

The screenshot below shows that the certificate is recent and valid.

Thanks in advance for your help!

Answered by phax

Apr 27, 2023

HI @mcherri , as you "recently" (September 2022) updated your Peppol test certificate, you may have forgotten, that you need to propagate the new certificate also to the SMK (=test SML). Please see https://peppol.helger.com/public/locale-en_US/menuitem-docs-peppol-cert-update for a description on what needs to be done to update a Peppol certificate. If this is the first test participant that you wanted to create, this is the most likely option.
hth, Philip

View full answer

phax · 2023-04-27T12:25:12Z

phax
Apr 27, 2023
Maintainer

HI @mcherri , as you "recently" (September 2022) updated your Peppol test certificate, you may have forgotten, that you need to propagate the new certificate also to the SMK (=test SML). Please see https://peppol.helger.com/public/locale-en_US/menuitem-docs-peppol-cert-update for a description on what needs to be done to update a Peppol certificate. If this is the first test participant that you wanted to create, this is the most likely option.
hth, Philip

0 replies

mcherri · 2023-04-28T07:30:03Z

mcherri
Apr 28, 2023
Author

Thanks, @phax! That fixed it!

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error when creating a Service Group #242

{{title}}

Replies: 2 comments

{{title}}

{{title}}

Select a reply

Error when creating a Service Group #242

mcherri Apr 23, 2023

Replies: 2 comments

phax Apr 27, 2023 Maintainer

mcherri Apr 28, 2023 Author

mcherri
Apr 23, 2023

phax
Apr 27, 2023
Maintainer

mcherri
Apr 28, 2023
Author