Discussion Board for collaboration on QlikView Security and Governance.
I'm running QV 11.2 SR16 and QVGD 2.0.2. I have a test environment and a production environment.
In my production environment, QVGD loads with no errors. However, in my test environment, QVGD is throwing multiple errors. I've included them below.
I noticed, while trying to troubleshoot, that even in production, QVGD is not listing my QlikView docs.
So, my first question.... Does QVGD have issues with subdirectories? I have a directory "Published" with many subdirectories that contain my QVWs.
My second question.... Any idea why I get all these errors on my test environment but not my production environment? Are questions 1 and 2 related?
Thanks in advance!
Table not found
Load FileName as tempFileName,
Where Extension = 'qvw'
AND FileDate >= '2015-02-09'
AND (FileTime >= '1995-08-26 00:00:00'
OR not exists (SOE_FileName,FileName))
AND not exists (NonReadableMetadataQVW,FileName)
Script line error:
IF > 0 then
Field not found - <SOE_Comment>
ObjectKey & Definition as ExpressionKey,
Label as Expression_Label,
Definition as Expression_Definition,
SOE_Comment as Expression_Comment
where SOE_Type ='Expression'
Count(DISTINCT Expression_Definition) as Defs
Where Not IsNull(Expression_Label)
Group by Expression_Label
Load If(Defs > 50, '50+',
If(Defs > 20, '21 to 50',
If(Defs > 15, '16 to 20',
If(Defs > 10, '11 to 15',
If(Defs > 7, '8 to 10',
If(Defs > 4, '5 to 7',
If(Defs > 1, '2 to 4'))))))) as [Definition Bucket],
1 as Expression_LabelDefCount
DROP TABLES statement
Count(DISTINCT Expression_Label) as Labels
Where Not IsNull(Expression_Definition)
Group by Expression_Definition
Load If(Labels > 50, '50+',
If(Labels > 20, '21 to 50',
If(Labels > 15, '16 to 20',
If(Labels > 10, '11 to 15',
If(Labels > 7, '8 to 10',
If(Labels > 4, '5 to 7',
If(Labels > 1, '2 to 4'))))))) as [Label Bucket],
1 as Expression_DefLabelCount
Field not found - <Group>
Group as Dimension_Field,
Field as Group_Members,
If(IsCyclic='true','Cyclic','Hierarchic') as Group_Type
where SOE_Type ='Group'
Field not found - <Sheet>
ObjectKey, SOE_Type as ChartType
WHERE not isnull(Sheet)
Field not found - <IsConfig>
FileName, Label as Variable_Name,
Definition as Variable_Def,
if(lower(IsConfig)='true' or lower(IsReserved)='true','System','User') as Variable_Type
where SOE_Type ='Variable'
Where Extension = 'qvd'
OR not exists (QVD_FileName,FileName))
AND not exists (NonReadableMetadataQVD,FileName)
Yes, there is at lease one known issue (GOVDASH-131 and GOVDASH-138) in 2.0.2 that might be giving you grief.
Try using this pre-release beta version of the app and let me know how it goes.
View solution in original post
Well, it loaded in my test environment. It looks like whatever the problem is, it's solved.
Does this pre-release beta have a release date?
Glad to hear!
And, no release date set yet, unfortunately. The resources (people) to make that happen are tied up in a different project right now.