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
- Login to workforce TAM application with a proxy as a manager.
- Find Employee from Home->Edit Employee Time->Search for employee.
- 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