Governance Dashboard 2.1.4 version - Failing with Table not found

[dhanu_today]

Hi All,

we are trying to run the Governance Dashboard 2.1.4 version with Qlikview May 2022 SR1 version. When we are running the task getting the below errors.

We are followed the below articles and instructions. But the solutions are not helped.

https://community.qlik.com/t5/Official-Support-Articles/Governance-Dashboard-fails-to-reload-with-Ta...

https://community.qlik.com/t5/Official-Support-Articles/QlikView-Governance-Dashboard-error-quot-Tab...

Table 'QVWComplexity' not found

Left Join (sense_profile_score)                 

             Load 

                            FileName,

                            ComplexitySheetCount as sense_profile_sheet_count,

                            ComplexitySheetObjectCount as sense_profile_sheet_object_count,

                            ComplexityObjectsNotCompatibleWithSenseList as sense_profile_objects_not_compatible_list,

                            ComplexitySheetObjectsPerSheet as sense_profile_objects_per_sheet,

                            ComplexityObjectsNotCompatibleWithSense as sense_profile_objects_not_compatible_with_sense,

                            ComplexitySheetCountActivated as sense_profile_sheet_count_activated,

                            ComplexitySheetObjectCountActivated as sense_profile_sheet_object_count_activated,

                            ComplexityObjectsNotCompatibleWithSenseListActivated as sense_profile_objects_not_compatible_list_activated,

                            ComplexitySheetObjectsPerSheetActivated as sense_profile_objects_per_sheet_activated,

                            ComplexityObjectsNotCompatibleWithSenseActivated as sense_profile_objects_not_compatible_with_sense_activated

             Resident QVWComplexity

             Where ComplexitySheetCount > 0

…………………

Field not found error

Field 'sense_profile_sheet_count' not found

[Sense_Profile_Score]:

             NoConcatenate Load

                            FileName,

                            sense_profile_app_name,

                            sense_profile_app_adoption_score,                                    

                            sense_profile_app_session_count_0_30_days,  

                            If(sense_profile_sheet_count>0,sense_profile_sheet_count,0) as sense_profile_sheet_count,

                If(sense_profile_sheet_object_count>0,sense_profile_sheet_object_count,0) as sense_profile_sheet_object_count,

                     If(sense_profile_objects_per_sheet>0,sense_profile_objects_per_sheet,0) as sense_profile_objects_per_sheet,

              If(sense_profile_sheet_count_activated>0,sense_profile_sheet_count_activated,0) as sense_profile_sheet_count_activated,

              If(sense_profile_sheet_object_count_activated>0,sense_profile_sheet_object_count_activated,0) as sense_profile_sheet_object_count_activated,

              If(sense_profile_objects_per_sheet_activated>0,sense_profile_objects_per_sheet_activated,0) as sense_profile_objects_per_sheet_activated,

                            sense_profile_objects_not_compatible_list,       

              If(sense_profile_objects_not_compatible_with_sense>0,sense_profile_objects_not_compatible_with_sense,0) as sense_profile_objects_not_compatible_with_sense,

                            sense_profile_objects_not_compatible_list_activated,   

              If(sense_profile_objects_not_compatible_with_sense_activated>0,sense_profile_objects_not_compatible_with_sense_activated,0) as sense_profile_objects_not_compatible_with_sense_activated

             Resident sense_profile_score

Thanks,

Dhanu

[Ray_Strother]

Hello,

1. Have you confirmed that the Audit and session logs are enabled and turned up to High for logging?

[dhanu_today]

Yes, They are High.

[imajchrzak]

Hello,

Have you resolved the issue?