I just downloaded and configured the Governance 2.1.4 qvw, and I can not get it to do a successful reload task. What am I missing?
It might be that we are on Qlikview version 12.10.20600 SR8?
20201210T104953.075-0600 Information 2020-12-10 10:49:14 2594 SET vs_sense_profile_history_days = 90
20201210T104953.076-0600 Information 2020-12-10 10:49:14 2595 Let vs_audit_cutoff_date = Today(1)-90
20201210T104953.076-0600 Information 2020-12-10 10:49:14 2596 Let vs_audit_cutoff_date_pretty = Date(vs_audit_cutoff_date)
20201210T104953.076-0600 Information 2020-12-10 10:49:14 2597 TRACE Aggregations for calculating Sense Profile Score: Audit activity for past 90 days (back to 2020-09-11)
20201210T104953.076-0600 Information 2020-12-10 10:49:14 2597 Aggregations for calculating Sense Profile Score: Audit activity for past 90 days (back to 2020-09-11)
20201210T104953.077-0600 Information 2020-12-10 10:49:14 2598
20201210T104953.077-0600 Information 2020-12-10 10:49:14 2598 Let vs_adoption_cutoff_last_30 = Today(1) - 30
20201210T104953.077-0600 Information 2020-12-10 10:49:14 2599 Let vs_adoption_cutoff_last_60 = Today(1) - 60
20201210T104953.077-0600 Information 2020-12-10 10:49:14 2600 Let vs_adoption_cutoff_last_90 = Today(1) - 90
20201210T104953.077-0600 Information 2020-12-10 10:49:14 2602 TRACE 1- Create aggregate sessions by QVW (FileName)
20201210T104953.077-0600 Information 2020-12-10 10:49:14 2602 1- Create aggregate sessions by QVW (FileName)
20201210T104953.078-0600 Information 2020-12-10 10:49:14 2603
20201210T104953.078-0600 Information 2020-12-10 10:49:14 2603 sense_profile_score:
20201210T104953.078-0600 Information 2020-12-10 10:49:14 2604 | Load *,
20201210T104953.078-0600 Information 2020-12-10 10:49:14 2605 | | sense_profile_app_session_count_0_30_days * 1 +
20201210T104953.078-0600 Information 2020-12-10 10:49:14 2606 | | sense_profile_app_session_count_31_60_days * 0.5 +
20201210T104953.079-0600 Information 2020-12-10 10:49:14 2607 | | sense_profile_app_session_count_61_90_days * 0.25
20201210T104953.079-0600 Information 2020-12-10 10:49:14 2608 | | | AS sense_profile_app_adoption_score
20201210T104953.079-0600 Information 2020-12-10 10:49:14 2609 | Where sense_profile_app_session_count > 1
20201210T104953.079-0600 Information 2020-12-10 10:49:14 2610 |
20201210T104953.079-0600 Information 2020-12-10 10:49:14 2611 Load
20201210T104953.080-0600 Information 2020-12-10 10:49:14 2612 | | Sessions_FileName as FileName,
20201210T104953.080-0600 Information 2020-12-10 10:49:14 2613 | | Replace(Subfield(Sessions_FileName,'\',-1),'.qvw','') as sense_profile_app_name,
20201210T104953.081-0600 Information 2020-12-10 10:49:14 2614 | | Sum(Session_Start_Count) as sense_profile_app_session_count,
20201210T104953.081-0600 Information 2020-12-10 10:49:14 2615 | | Sum(If(SessionTimestamp>=44145,Session_Start_Count,0) ) as sense_profile_app_session_count_0_30_days,
20201210T104953.081-0600 Information 2020-12-10 10:49:14 2616 | | Sum(If(SessionTimestamp>=44115 and SessionTimestamp < 44145 ,Session_Start_Count,0) ) as sense_profile_app_session_count_31_60_days,
20201210T104953.081-0600 Information 2020-12-10 10:49:14 2617 | | Sum(If(SessionTimestamp>=44085 and SessionTimestamp < 44115 ,Session_Start_Count,0) ) as sense_profile_app_session_count_61_90_days | |
20201210T104953.081-0600 Information 2020-12-10 10:49:14 2618 | Resident SessionTaskAuditMaster
20201210T104953.082-0600 Information 2020-12-10 10:49:14 2619 | Where | SessionTimestamp >= 44085 AND Session_Start_Count>0 AND WildMatch(Sessions_FileName,'*.qvw')=1
20201210T104953.082-0600 Information 2020-12-10 10:49:14 2620 | Group by Sessions_FileName
20201210T104953.082-0600 Information 2020-12-10 10:49:16 | 7 fields found: FileName, sense_profile_app_name, sense_profile_app_session_count, sense_profile_app_session_count_0_30_days, sense_profile_app_session_count_31_60_days, sense_profile_app_session_count_61_90_days, sense_profile_app_adoption_score,
20201210T104953.082-0600 Information 2020-12-10 10:49:16 9 lines fetched
20201210T104953.082-0600 Information 2020-12-10 10:49:16 2622 Let vs_sense_profile_app_sessions = NoOfRows('sense_profile_app_sessions')
20201210T104953.082-0600 Information 2020-12-10 10:49:16 2625 sense_profile_adoption_score_max:
20201210T104953.083-0600 Information 2020-12-10 10:49:16 2626 | Load Max(sense_profile_app_adoption_score) as sense_profile_adoption_score_max Resident sense_profile_score
20201210T104953.083-0600 Information 2020-12-10 10:49:16 | 1 fields found: sense_profile_adoption_score_max,
20201210T104953.083-0600 Information 2020-12-10 10:49:16 1 lines fetched
20201210T104953.083-0600 Information 2020-12-10 10:49:16 2627 Let vs_sense_profile_adoption_score_max = Peek('sense_profile_adoption_score_max')
20201210T104953.083-0600 Information 2020-12-10 10:49:16 2628 Let vs_sense_profile_adoption_score_adjusted = vs_sense_profile_adoption_score_max*0.8
20201210T104953.084-0600 Information 2020-12-10 10:49:16 2629 Drop table sense_profile_adoption_score_max
20201210T104953.084-0600 Information 2020-12-10 10:49:16 2631 TRACE Sense Profile: apps accessed since 2020-09-11. Max score = 2553 (Adjusted 2042.4).
20201210T104953.084-0600 Information 2020-12-10 10:49:16 2631 Sense Profile: apps accessed since 2020-09-11. Max score = 2553 (Adjusted 2042.4).
20201210T104953.084-0600 Information 2020-12-10 10:49:16 2632
20201210T104953.084-0600 Information 2020-12-10 10:49:16 2634 TRACE 2- Create aggregate Sheet audit Activity and join to SOE table.
20201210T104953.085-0600 Information 2020-12-10 10:49:16 2634 2- Create aggregate Sheet audit Activity and join to SOE table.
20201210T104953.085-0600 Information 2020-12-10 10:49:16 2635
20201210T104953.085-0600 Information 2020-12-10 10:49:16 2638 Join (SOE)
20201210T104953.085-0600 Information 2020-12-10 10:49:16 2639 | Load
20201210T104953.085-0600 Information 2020-12-10 10:49:16 2640 | | Replace(Audit_FileName,'/','\') & '|Document\' & Replace(AuditId,'Document\','') AS ObjectKey,
20201210T104953.085-0600 Information 2020-12-10 10:49:16 2641 | | Sum(Audit_Count) as sense_profile_sheet_audit_count
20201210T104953.086-0600 Information 2020-12-10 10:49:16 2642 | Resident SessionTaskAuditMaster
20201210T104953.086-0600 Information 2020-12-10 10:49:16 2643 | Where | AuditTimestamp >= 44085
20201210T104953.086-0600 Information 2020-12-10 10:49:16 2644 | | AND | (AuditType = 'Sheet' |
20201210T104953.086-0600 Information 2020-12-10 10:49:16 2645 | | | OR (AuditType = 'Document' AND AuditMessage = 'Open') |
20201210T104953.086-0600 Information 2020-12-10 10:49:16 2646 | | | )
20201210T104953.087-0600 Information 2020-12-10 10:49:16 2647 | Group by Audit_FileName,AuditId
20201210T104953.087-0600 Information 2020-12-10 10:49:16 Error: Field not found - <AuditTimestamp>
20201210T104953.087-0600 Information 2020-12-10 10:49:16 Field not found - <AuditTimestamp>
20201210T104953.087-0600 Information 2020-12-10 10:49:17 Execution Failed
20201210T104953.087-0600 Information 2020-12-10 10:49:17 Execution finished.
