Exception is thrown if a PICKED_BY a non UUID value such as 'W-PG02Y5T6' or 'XKWYWQ0JFW'

[AtikaRaj]

Hi,

We are developing a service for which we are making use of db-scheduler to schedule certain tasks. We are observing some issues now in the "SCHEDULED_EXECUTION_LOGS". We have defined a Recurring task which is scheduled for every 15 min run. If the task is PICKED_BY a non UUID value like 'W-PG02Y5T6' or 'XKWYWQ0JFW', the job fails throwing IllegalStateException: Connection pool shut down the stack trace is listed below:
java.lang.IllegalStateException: Connection pool shut down at org.apache.http.util.Asserts.check(Asserts.java:34) at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.requestConnection(PoolingHttpClientConnectionManager.java:269) at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:176) at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186) at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89) at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110) at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83) at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108) at com.sap.cloud.security.xsuaa.client.DefaultOAuth2TokenService.executeRequest(DefaultOAuth2TokenService.java:102) at com.sap.cloud.security.xsuaa.client.DefaultOAuth2TokenService.requestAccessToken(DefaultOAuth2TokenService.java:95) at com.sap.cloud.security.xsuaa.client.AbstractOAuth2TokenService.getAndCacheToken(AbstractOAuth2TokenService.java:313) at com.sap.cloud.security.xsuaa.client.AbstractOAuth2TokenService.getOrRequestAccessToken(AbstractOAuth2TokenService.java:271) at com.sap.cloud.security.xsuaa.client.AbstractOAuth2TokenService.getOAuth2TokenResponse(AbstractOAuth2TokenService.java:254) at com.sap.cloud.security.xsuaa.client.AbstractOAuth2TokenService.retrieveAccessTokenViaClientCredentialsGrant(AbstractOAuth2TokenService.java:114) at com.sap.cloud.security.xsuaa.tokenflows.ClientCredentialsTokenFlow.requestTechnicalUserToken(ClientCredentialsTokenFlow.java:183) at com.sap.cloud.security.xsuaa.tokenflows.ClientCredentialsTokenFlow.execute(ClientCredentialsTokenFlow.java:141) at com.sap.bpm.pvs.intelligence.core.commons.utils.AuthorizationUtil.getAccessTokenForClientCredentialFlow(AuthorizationUtil.java:121) at com.sap.bpm.pvs.intelligence.core.commons.utils.AuthorizationUtil.getOAuthAuthorizationStringForClientCredentialFlow(AuthorizationUtil.java:87)

Additionally, we also have some CustomTask which if PICKED_BY the above stated values it fails with the following stack trace:
java.lang.NullPointerException: Cannot invoke "com.sap.bpm.pvs.intelligence.core.commons.enums.JobType.ordinal()" because "jobType" is null at com.sap.bpm.pvs.intelligence.scheduler.execution.handler.PollingOperationExecutionHandler.execute(PollingOperationExecutionHandler.java:92) at com.github.kagkarlsson.scheduler.task.helper.Tasks$TaskBuilder$1.execute(Tasks.java:324) at com.github.kagkarlsson.scheduler.ExecutePicked.executePickedExecution(ExecutePicked.java:95) at com.github.kagkarlsson.scheduler.ExecutePicked.run(ExecutePicked.java:74) at com.github.kagkarlsson.scheduler.Executor.lambda$addToQueue$0(Executor.java:53) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840)
When we print the the jobType in the logger it shows the correct value.

Here is the image that shows the same:

The database that we are using is HANA database. Could you help us with the issue we observe here?

[AtikaRaj]

The issue comes up as we are running the srervice using tomcat for local development and the id of the system comes up which leads to the error. Its the testing issue.