PeopleSoft HCM Database Connector Configuration Error

Which IIQ version are you inquiring about?

8.1,8.2,8.3,8.4

Please share any images or screenshots, if relevant.

Please share any other relevant files that may be required (for example, logs).

PeopleSoftHRMS.jar (13.4 MB)

psjoa.jar (1.8 MB)

Corresponding Log in sailpoint.log and error.log


Caused by: sailpoint.connector.ConnectorException: ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

```
at sailpoint.connector.PeopleSoftDirectConnector.throwException(PeopleSoftDirectConnector.java:367) ~[connector-bundle-jdbc.jar:8.4]
at sailpoint.connector.PeopleSoftDirectConnector.errorHandler(PeopleSoftDirectConnector.java:319) ~[connector-bundle-jdbc.jar:8.4]
... 81 more

2025-08-11T20:40:25,450 ERROR http-nio-8080-exec-6 sailpoint.connector.PeopleSoftHRMSConnector:236 - Exception in testConnection : Exception in testConnection : sailpoint.connector.ConnectorException: ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

2025-08-11T20:40:25,474 ERROR http-nio-8080-exec-6 sailpoint.web.ApplicationObjectBean:2863 - Connector failed.
sailpoint.connector.ConnectorException: ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

at sailpoint.connector.PeopleSoftHRMSConnector.testConfiguration(PeopleSoftHRMSConnector.java:237) ~[?:?]
at sailpoint.connector.ConnectorProxy.testConfiguration(ConnectorProxy.java:411) ~[connector-bundle-identityiq.jar:8.4]
at sailpoint.web.ApplicationObjectBean.testConnectorAction(ApplicationObjectBean.java:2857) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.el.parser.AstValue.invoke(AstValue.java:252) [jasper-el.jar:9.0.80]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:266) [jasper-el.jar:9.0.80]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) [javax.faces-2.2.20.jar:2.2.20]
at sailpoint.web.util.SailPointActionListener.processAction(SailPointActionListener.java:42) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at javax.faces.component.UICommand.broadcast(UICommand.java:315) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:658) [javax.faces-2.2.20.jar:2.2.20]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:357) [tomahawk20-1.1.14.jar:1.1.14]
at sailpoint.web.MyFacesExtensionsFilter.doFilter(MyFacesExtensionsFilter.java:62) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) [tomcat-websocket.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.SailPointResponseFilter.doFilter(SailPointResponseFilter.java:76) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.PageAuthorizationFilter.doFilter(PageAuthorizationFilter.java:102) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.PageAuthenticationFilter$Chainlink.doFilter(PageAuthenticationFilter.java:290) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.service.PageAuthenticationService.handleFinally(PageAuthenticationService.java:644) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.web.PageAuthenticationFilter$MyHandler.handle(PageAuthenticationFilter.java:333) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.web.PageAuthenticationFilter.doFilter(PageAuthenticationFilter.java:127) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.SailPointContextRequestFilter.doFilter(SailPointContextRequestFilter.java:68) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.util.MethodFilter.doFilter(MethodFilter.java:51) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.SailPointPollingRequestFilter.doFilter(SailPointPollingRequestFilter.java:151) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.util.TimingFilter.doFilter(TimingFilter.java:88) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:63) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) [catalina.jar:9.0.80]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) [catalina.jar:9.0.80]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) [catalina.jar:9.0.80]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.80]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.80]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) [tomcat-coyote.jar:9.0.80]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) [tomcat-coyote.jar:9.0.80]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) [tomcat-coyote.jar:9.0.80]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790) [tomcat-coyote.jar:9.0.80]
at 

org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) [tomcat-coyote.jar:9.0.80]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:9.0.80]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:9.0.80]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.80]
at java.lang.Thread.run(Thread.java:834) [?:?]

```

Share all details about your problem, including any error messages you may have received.

I am trying to configure PeopleSoft HCM 9.2 application with SailPoint IIQ versions 8.1,8.2,8.3 and 8.4. I have followed the steps mentioned in this document/s:

I am using PeopleTools version 8.61.03 after a lot of research and testing to comply with both SailPoint and PeopleSoft HCM to generate the appropriate jar files attached above.

My error is narrowed down to

ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

I opened all the JSL related ports on PeopleSoft machine and disabled SSL to work in a Lab environment.

Can you please help me debug, address and close this issue.

Thanks,

Suresh

Hi @sjagirdar1580 , What is the exact error you are getting , can’t see in above screenshot ?


Caused by: sailpoint.connector.ConnectorException: ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

```
at sailpoint.connector.PeopleSoftDirectConnector.throwException(PeopleSoftDirectConnector.java:367) ~[connector-bundle-jdbc.jar:8.4]
at sailpoint.connector.PeopleSoftDirectConnector.errorHandler(PeopleSoftDirectConnector.java:319) ~[connector-bundle-jdbc.jar:8.4]
... 81 more

2025-08-11T20:40:25,450 ERROR http-nio-8080-exec-6 sailpoint.connector.PeopleSoftHRMSConnector:236 - Exception in testConnection : Exception in testConnection : sailpoint.connector.ConnectorException: ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

2025-08-11T20:40:25,474 ERROR http-nio-8080-exec-6 sailpoint.web.ApplicationObjectBean:2863 - Connector failed.
sailpoint.connector.ConnectorException: ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

at sailpoint.connector.PeopleSoftHRMSConnector.testConfiguration(PeopleSoftHRMSConnector.java:237) ~[?:?]
at sailpoint.connector.ConnectorProxy.testConfiguration(ConnectorProxy.java:411) ~[connector-bundle-identityiq.jar:8.4]
at sailpoint.web.ApplicationObjectBean.testConnectorAction(ApplicationObjectBean.java:2857) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.el.parser.AstValue.invoke(AstValue.java:252) [jasper-el.jar:9.0.80]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:266) [jasper-el.jar:9.0.80]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87) [javax.faces-2.2.20.jar:2.2.20]
at 
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) [javax.faces-2.2.20.jar:2.2.20]
at sailpoint.web.util.SailPointActionListener.processAction(SailPointActionListener.java:42) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at javax.faces.component.UICommand.broadcast(UICommand.java:315) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [javax.faces-2.2.20.jar:2.2.20]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198) [javax.faces-2.2.20.jar:2.2.20]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:658) [javax.faces-2.2.20.jar:2.2.20]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:357) [tomahawk20-1.1.14.jar:1.1.14]
at sailpoint.web.MyFacesExtensionsFilter.doFilter(MyFacesExtensionsFilter.java:62) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) [tomcat-websocket.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.SailPointResponseFilter.doFilter(SailPointResponseFilter.java:76) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.PageAuthorizationFilter.doFilter(PageAuthorizationFilter.java:102) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.PageAuthenticationFilter$Chainlink.doFilter(PageAuthenticationFilter.java:290) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.service.PageAuthenticationService.handleFinally(PageAuthenticationService.java:644) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.web.PageAuthenticationFilter$MyHandler.handle(PageAuthenticationFilter.java:333) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.web.PageAuthenticationFilter.doFilter(PageAuthenticationFilter.java:127) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.SailPointContextRequestFilter.doFilter(SailPointContextRequestFilter.java:68) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.util.MethodFilter.doFilter(MethodFilter.java:51) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.SailPointPollingRequestFilter.doFilter(SailPointPollingRequestFilter.java:151) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.util.TimingFilter.doFilter(TimingFilter.java:88) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at sailpoint.web.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:63) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.80]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) [catalina.jar:9.0.80]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) [catalina.jar:9.0.80]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) [catalina.jar:9.0.80]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670) [catalina.jar:9.0.80]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.80]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.80]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) [tomcat-coyote.jar:9.0.80]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) [tomcat-coyote.jar:9.0.80]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) [tomcat-coyote.jar:9.0.80]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790) [tomcat-coyote.jar:9.0.80]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) [tomcat-coyote.jar:9.0.80]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:9.0.80]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:9.0.80]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.80]
at java.lang.Thread.run(Thread.java:834) [?:?]
```

HI @sjagirdar1580 ,

Please look in to below link -

https://community.sailpoint.com/t5/IdentityIQ-Forum/ERROR-0-0-DOWNbea-jolt-ServiceException-Invalid-Session/m-p/270514#M196207

The page says..
This resource is no longer available. Use the search bar at the top of the page to locate to most relevant, up-to-date content for your needs.

Return to my original page

@harsh_gupta4

Basically Access is Denied to that page for me. Can you please copy paste the stuff here.

Thanks,

Suresh

Document 3034531.1.pdf (157.5 KB)

Hi @sjagirdar1580 , Please refer the attached pdf .

Hi @harsh_gupta4 ,

>java -DTM_ALLOW_NOTLS=Y <Java_Main_Driver_Program_Name>

Note: <Java_Main_Driver_Program_Name> is a placeholder for the name of the driver program.

Which Main Driver Program is this documentation is referring to?

I already have this environment variable set on the PeopleSoft Machine like this

But yet the error when trying to connect to HCM Database named HR92U051.

Appreciate your kind help!

Thanks & Regards,
Suresh

Hi @sjagirdar1580 , Please refer the below screenshot . This user was also facing the same issue which you have been , refer his fix -

@harsh_gupta4

Despite having everything setup correctly including JAVA_OPTS to point to -DTM_ALLOW_NOTLS=Y on both Tomcat and PeopleSoft sides

SailPoint Application Configuration page is throwing

ERROR (0,0) : DOWNbea.jolt.ServiceException: Invalid Session

when I click Test Connection Button.

I am going to give up here and move on.

Thanks for your help! Means a lot.

Regards,

Suresh

Hi @harsh_gupta4 ,

The issue finally got resolved after continued persistence.

Please refer to the following link for clues:


bea.jolt.JoltException: NwHdlr: IO exceptions\njava.net.ConnectException: Connection timed out

July 3, 2019 / Swamy Boppa / Leave a comment

Issue:

When trying to run peoplesoft user management target reconciliation OIM to peoplesoft, using peoplesoft UM connector below error showing in logs.

Target Class = oracle.iam.connectors.icfcommon.prov.ICProvisioningManager
bea.jolt.JoltException: NwHdlr: IO exceptions\njava.net.ConnectException: Connection timed out (Connection timed out)
at bea.jolt.NwHdlr.open_socket(NwHdlr.java:2091)
at bea.jolt.NwHdlr.openConnection(NwHdlr.java:639)
at bea.jolt.CMgr.connect(CMgr.java:173)
at bea.jolt.JoltSession.logon(JoltSession.java:249)
at bea.jolt.JoltSession.(JoltSession.java:127)
at psft.pt8.net.JoltSessionWrapper.(JoltSessionWrapper.java:92)
at psft.pt8.net.JoltSessionPool.createConnection(JoltSessionPool.java:856)

Cause:

jolt ports are not opened from OIM to peoplesoft server.

Solution:

jolt connection work is depending on the Min and Max handlers configured in cfg file. The Client connects to JSL port 9400, JSL responds to the Client and says, you need to connect to JSH for your request. So the Client then connects to JSH on port 9041 and proceeds with the request/transaction. In you case the min and max set to 9/12 respectively .
e.g. Tuxedo Server side is configured JSL port 9400, MIN=, and MAX= the MIN/MAX indicate the number of JSH (Handlers) to start. So if MAX=12 you have to open 9400 through 9412.

Address=//,machine name>
Port=9400
JSL Encryption=0
Min Handlers=9
Max Handlers=12

In above case, 9400,9401,09402,…,9412 ports need to be open.



In my case,
the JSH ports were running on 

I ran this command from power shell to open these ports as JSL port was already open..
Open JSH ports (9034–9038)

New-NetFirewallRule -DisplayName “PeopleSoft JSH 9034-9038” -Direction Inbound -Protocol TCP -LocalPort 9034-9038 -Action Allow

That’s it the Jolt Error was gone finally.

Now, there was another issue connecting to peoplesoft hcm database. I am posting the parameters right here so that no one has to search for a fix:

and finally:

It works! now. Hope this helps the community!

Thanking You,

Suresh

1 Like

Good to know . Thanks.

@harsh_gupta4 ,

But in the first place. you were right, you need this in the tomcat setenv.cmd file..

set CATALINA_OPTS=%CATALINA_OPTS% -DTM_ALLOW_NOTLS=Y

echo ==== setenv loaded ====
echo JAVA_OPTS is: %JAVA_OPTS%
echo CATALINA_OPTS is: %CATALINA_OPTS%

Kudos! to you.

Regards,

Suresh

1 Like

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.