SAP Knowledge Base Article - Public

3081749 - Workforce TAM stack shows error 'TIME_CLOCK_HUB_CARD:null'

Symptom

Login to workforce TAM using proxy as a manager.
Use the find feature on the timesheets page to find an employee. Below error can be seen in Stack trace.

Caused by: com.workforcesoftware.Policy.PolicyLookupInvalidForeignKey: Invalid policy key:
2021-**-**.RIGHT_GRP(WEBCLOCK_USER).RIGHT_GRP_DETAIL(2430080636).SYSTEM_FEATURE(TIME_CLOCK_HUB_CARD:null)

From the Stack Trace
================

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at com.workforcesoftware.ClientRequests.UIThemeFilter.doFilter(UIThemeFilter.java:58)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at com.workforcesoftware.ClientRequests.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at com.workforcesoftware.ClientRequests.P3PFilter.doFilter(P3PFilter.java:56)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at de.javakaffee.web.msm.RequestTrackingContextValve.invoke(RequestTrackingContextValve.java:99)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
    at de.javakaffee.web.msm.RequestTrackingHostValve.invoke(RequestTrackingHostValve.java:157)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: com.workforcesoftware.Policy.PolicyLookupInvalidForeignKey: Invalid policy key: 2021-07-20.RIGHT_GRP(WEBCLOCK_USER).RIGHT_GRP_DETAIL(2430080636).SYSTEM_FEATURE(TIME_CLOCK_HUB_CARD:null)
    at com.workforcesoftware.Gen.Policy.System_feature.<init>(System_feature.java:836)
    at com.workforcesoftware.Gen.Policy.Right_grp_detail.getSystem_feature(Right_grp_detail.java:114)
    at com.workforcesoftware.Gen.Policy.Right_grp_detail.getSystem_feature(Right_grp_detail.java:104)
    at com.workforcesoftware.Security.Principal.getRightGroupListForSystemFeatures(Principal.java:2127)
    at com.workforcesoftware.Security.Principal.getRightGroupListForSystemFeature(Principal.java:2106)
    at com.workforcesoftware.Security.Principal.getRolePolicyIdsForSystemFeature(Principal.java:2092)
    at com.workforcesoftware.timeOff.TimeOffRequestSecurity.getRolesThatCanApproveForAnyRole(TimeOffRequestSecurity.java:301)
    at com.workforcesoftware.Data.timeoffRequest.TimeoffRequest.getApprovalStatusRecord(TimeoffRequest.java:1522)
    at com.workforcesoftware.timeOff.TimeOffRequestTransactionBuilder.getTorApprovals(TimeOffRequestTransactionBuilder.java:317)
    at com.workforcesoftware.timeOff.TimeOffRequestTransactionBuilder.getTimeOffRequestDetailResponse(TimeOffRequestTransactionBuilder.java:250)
    at com.workforcesoftware.timeOff.TimeOffRequestTransactionBuilder.getTimeOffRequestDetailResponse(TimeOffRequestTransactionBuilder.java:86)
    at com.workforcesoftware.timeOff.TimeOffRequestTransactionBuilder.getTimeOffRequestDetailResponse(TimeOffRequestTransactionBuilder.java:95)
    at com.workforcesoftware.timeOff.TimeOffRequestTransactionBuilder.getTimeOffRequestLoadRequestScreenConfig(TimeOffRequestTransactionBuilder.java:184)

Environment

SAP Time and Attendance Management by WorkForce Software

Reproducing the Issue

  1. Login to workforce TAM application with a proxy as a manager.
  2. Find Employee from Home->Edit Employee Time->Search for employee.
  3. Below error can be seen.

    Caused by: com.workforcesoftware.Policy.PolicyLookupInvalidForeignKey: Invalid policy key:
    2021-**-**.RIGHT_GRP(WEBCLOCK_USER).RIGHT_GRP_DETAIL(2430080636).SYSTEM_FEATURE(TIME_CLOCK_HUB_CARD:null)

Cause

The role WEBCLOCK_USER was using system feature TIME_CLOCK_HUB_CARD which is no longer available in the system. 

Resolution

Remove the feature 'TIME_CLOCK_HUB_CARD ' and this issue will not be visible again.

Keywords

Policy, WEBCLOCK_USER, SYSTEM_FEATURE , KBA , XX-PART-WFR-TAM , SAP Time and Attendance Management by Workforce Software , Problem

Product

SAP SuccessFactors Workforce Analytics 2105