Hello all,

We figured out what was going on. Our enterprise uses an "_" underscore
character as a place holder in certain Labor Level Segment entries. We utilize
this logic b/c we prefer that all entries within a specific LL Segment have the
same amount of total characters. It makes custom programming much easier in the
long term.

We could not utilize these certain segments in the parent, or, top-level
roll-up. Funny thing is the app doesn't flag the aforementioned placeholder as
a "reserved special character" when entering individual Labor Level Segment
entries.

Further, the app drills down perfectly fine if the aforementioned logic is
followed, kind of quirky but makes sense.

I'm assuming Kronos simply needs to update the "reserved special character"
constraint list to prevent future customers from having to figure this out on
their own, or with the assistance of KGS.

Thank you for the feedback.


Harold Junca III
Financial Analyst | IT Project Manager
CorrectHealth | CorrectMed Companies
harold.junca@...


--- In kronos-fans@yahoogroups.com, Daniel Fields <red52baron@...> wrote:
>
> I got the same error on my new roll up gene  and had to reboot my apps. Error
cleared up.  Kronos said that we where the second company to have this problem
and that they where investigating it. 
>
>
>
> ________________________________
> From: Harold <hjunca@...>
> To: kronos-fans@yahoogroups.com
> Sent: Monday, February 27, 2012 9:55 PM
> Subject: WFC 6.2.4 Roll-Up Drill Down Error
>
>
>  
> Hello all,
>
> We have built the following:
>
> Roll-UP Column Set: XX WrkAcctRollUpSet
> Roll-Up by Worked Acct: Yes
> Detail ColSetForDrillDown: XX WrkAcctDtlSet
>
> Col1: Acct Name
> Col2: PayCdeTtlActl Reg Hrs
> Col3: PayCdeTtlActl OT Hrs
> Col4: PayCdeTtlActl Hol Hrs
> Col5: PayCdeTtlActl 1099 Hrs
>
> WrkedAcctDetlColSet: XX WrkAcctDtlSet
> Col1: Person Name
> Col2: Worked Account Name
> Col3: PayCdeTtlActl Reg Hrs
> Col4: PayCdeTtlActl OT Hrs
> Col5: PayCdeTtlActl Hol Hrs
> Col6: PayCdeTtlActl 1099 Hrs
>
> Roll-Up Genie: XX WrkAcctRollUp
> DefaultHypFndQry: All Home and Trnsferred In Optimized*
> DefaultTimePeriod: Previous Pay Period
> ColumnSet: XX WrkAcctRollUpSet
> NavBarCategory: Timekeeping
>
> When we run the Genie it returns summed up data based on Labor Levels fine.
However, when you attempt to drill into data the following error is returned:
>
> "WFP-00986 An unexpected error has occurred. Please contact your System
Administrator."
>
> The WFC log is in debug mode, with SQL tracing on and the following has been
noted:
>
>
4908|20120227222222|WFC.BUSINESS.SUMMARYVIEW|superuser|1|ERROR|Thread[ajp-0.0.0.\
0-8009-3,5,jboss] Error populating summary data
> java.lang.NullPointerException
> at
com.kronos.wfc.commonapp.genies.business.SummaryViewUtil.separateEntries(Summary\
ViewUtil.java:254)
> at
com.kronos.wfc.commonapp.genies.business.SummaryViewUtil.separateEntries(Summary\
ViewUtil.java:242)
> at
com.kronos.wfc.commonapp.genies.business.SummaryViewUtil.assembleDrillDownSQLStr\
ing(SummaryViewUtil.java:42)
> at
com.kronos.wfc.commonapp.genies.business.OptimizedWorkedAccountLoader.preprocess\
(OptimizedWorkedAccountLoader.java:93)
> at
com.kronos.wfc.commonapp.genies.business.OptimizedWorkedAccountLoader.getWorkedA\
ccountData(OptimizedWorkedAccountLoader.java:157)
> at
com.kronos.wfc.commonapp.genies.business.WorkedAccountEmployeeIdLoader.getData(W\
orkedAccountEmployeeIdLoader.java:45)
> at
com.kronos.wfc.commonapp.genies.business.TableDataHandler.getData(TableDataHandl\
er.java:556)
> at
com.kronos.wfc.commonapp.genies.business.SummaryDataCreator.createData(SummaryDa\
taCreator.java:48)
> at
com.kronos.wfc.commonapp.genies.business.SummaryDataCreatorFromGet.createDataFro\
mGet(SummaryDataCreatorFromGet.java:143)
> at
com.kronos.wfc.commonapp.genies.servlet.SummaryDataServlet.TKDoGet(SummaryDataSe\
rvlet.java:92)
> at
com.kronos.wfc.platform.security.framework.WFCBaseServlet.doGet(WFCBaseServlet.j\
ava:103)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
> at
com.kronos.wfc.platform.server.servlet.WFPHttpServlet.doService(WFPHttpServlet.j\
ava:287)
> at
com.kronos.wfc.platform.server.servlet.WFPHttpServlet.service(WFPHttpServlet.jav\
a:250)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
com.kronos.wfc.platform.server.servlet.WFPHttpServlet.service(WFPHttpServlet.jav\
a:231)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:290)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.CompressionFilt\
er.doFilter(CompressionFilter.java:182)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPAuditingFilt\
er.doFilter(WFPAuditingFilter.java:163)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPDataAccessFi\
lter.doFilter(WFPDataAccessFilter.java:429)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPRequestFilte\
r.doFilter(WFPRequestFilter.java:40)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPAuthorizatio\
nFilter.doFilter(WFPAuthorizationFilter.java:175)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPAuthenticati\
onFilter.doFilter(WFPAuthenticationFilter.java:214)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPSystemOnlyFi\
lter.doFilter(WFPSystemOnlyFilter.java:127)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPLoggingFilte\
r.doFilter(WFPLoggingFilter.java:151)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPContentTypeF\
ilter.doFilter(WFPContentTypeFilter.java:310)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPPageCachingF\
ilter.doFilter(WFPPageCachingFilter.java:178)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPSessionManag\
ementFilter.doFilter(WFPSessionManagementFilter.java:122)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
com.kronos.wfc.platform.security.business.authentication.filters.WFPSystemInitia\
lizationFilter.doFilter(WFPSystemInitializationFilter.java:150)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:9\
6)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:235)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:206)
> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2\
30)
> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1\
75)
> at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociatio\
nValve.java:179)
> at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionVa\
lve.java:157)
> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109\
)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
> at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437)
> at
org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:\
381)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Thread.java:619)
>
> I cannot seem to figure out what is causing this besides the fact that there
could be null values stored in the values attempting to be returned, any help in
resolving this would be greatly appreciated.
>
> Thanks,
>
> Harold Junca III
> Financial Analyst | IT Project Mgr & Business Systems Admin
>
>
>
>
> [Non-text portions of this message have been removed]
>