Hi,
Do we have any compatibility issue between Qlikview Governance Dashboard version 2.1.4 with Qlikview May 2021 SR2.
we are getting below errors during governance dashboard reload.
Syntax error
Aggregation expressions required by GROUP BY clause.
Join (SOE)
Load
Replace(Audit_FileName,'/','\') & '|Document\' & Replace(AuditId,'Document\','') AS ObjectKey
Resident SessionTaskAuditMaster
Where AuditTimestamp >= 44708
AND (AuditType = 'Sheet'
OR (AuditType = 'Document' AND AuditMessage = 'Open')
)
Group by Audit_FileName,AuditId
Field not found error
Field 'sense_profile_sheet_audit_count' not found
SOE_2:
NoConcatenate
Load *,
If(SOE_Type='Sheet',IF(sense_profile_sheet_audit_count > 0,sense_profile_sheet_audit_count,0)) AS sense_profile_sheet_activation_count
Resident SOE
Field not found error
Field 'sense_profile_sheet_audit_count' not found
Drop field sense_profile_sheet_audit_count
Table not found error
Table 'SOE' not found
left Join (SOE)
Load
SOE_FileName,
1 as SOE_is_sheet_object,
ObjectId & ': ' & Label as Sheet,
sense_profile_sheet_activation_count as sense_profile_sheet_activation_for_objects
Resident SOE
WHERE sense_profile_sheet_activation_count >=0
Table not found error
Table 'SOE' not found
Join (SOE)
Load
Sheet as ObjectId,
FileName,
Count(Distinct (If(SOE_is_sheet_object=1,ObjectId))) as soe_objects_per_sheet,
Count(Distinct (If(SOE_is_sheet_object=1 AND sense_profile_sheet_activation_for_objects>0,ObjectId))) as soe_objects_per_sheet_activated
Resident SOE
WHERE len(Sheet) >0
Group By FileName, Sheet
Table not found error
Table 'SOE' not found
LEFT JOIN (QVWComplexity)
LOAD FileName,
Count(DISTINCT If(SOE_Type='Sheet',ObjectId)) as ComplexitySheetCount,
count(distinct ObjectId) as ComplexityObjectCount,
Count(Distinct IF(SOE_is_sheet_object=1,ObjectId)) as ComplexitySheetObjectCount,
Count(If(SOE_Type='Expression',ObjectId)) as ComplexityExpressionCount,
Count(If(SOE_Type='Dimension' AND Left(Trim(PurgeChar(Definition,chr(10))),1)='=',ObjectId)) as ComplexityCalculatedDimensionCount,
Ceil(Count(Distinct IF(SOE_is_sheet_object=1,ObjectId))/Count(DISTINCT If(SOE_Type='Sheet',ObjectId))) as ComplexitySheetObjectsPerSheet,
Sum(SOE_not_compatible_with_sense) as ComplexityObjectsNotCompatibleWithSense,
Count(If(SOE_Type='Expression' AND Len(KeepChar(Definition,'{}'))>0, ObjectId)) as ComplexitySetAnalysisCount,
Count(If(SOE_Type='Expression' AND Len(Definition)>100,ObjectId)) as ComplexityLongExpressionCount,
Concat(Distinct If(SOE_not_compatible_with_sense=1,SOE_Type),',') as ComplexityObjectsNotCompatibleWithSenseList,
Ceil(Count(Distinct IF(SOE_is_sheet_object=1 AND sense_profile_sheet_activation_for_objects>0,ObjectId))/Count(DISTINCT If(SOE_Type='Sheet' AND sense_profile_sheet_activation_count>0,ObjectId))) as ComplexitySheetObjectsPerSheetActivated,
Count(DISTINCT If(SOE_Type='Sheet' AND sense_profile_sheet_activation_count>0,ObjectId)) as ComplexitySheetCountActivated,
Count(Distinct IF(SOE_is_sheet_object=1 AND sense_profile_sheet_activation_for_objects>0,ObjectId)) As ComplexitySheetObjectCountActivated,
Sum(IF(sense_profile_sheet_activation_for_objects>0,SOE_not_compatible_with_sense,0)) as ComplexityObjectsNotCompatibleWithSenseActivated,
Concat(Distinct If(SOE_not_compatible_with_sense=1 AND sense_profile_sheet_activation_for_objects>0,SOE_Type),',') as ComplexityObjectsNotCompatibleWithSenseListActivated
RESIDENT SOE
GROUP BY FileName
Table not found error
Table 'sense_profile_score' 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 'IsCyclic' not found
Drop fields IsCyclic,IsConfig,IsReserved,SOE_FileName,SOE_FileTime,_concatSOE
Can you please let me know your input to fix this issue.
Note: I was able to run this task if i comment below sub routine under Run logic.
CALL sense_profile // Additional script logic to support Sense Profile score (Added in QVGD 2.1.0)
Regards,
Balaji
