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
tempQVWs:
Load FileName as tempFileName,
LoadDateKey
Resident FileList
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
Script line error:
ELSE
Script line error:
ENDIF
Field not found - <SOE_Comment>
Expressions:
Load
ObjectKey,
ObjectKey & Definition as ExpressionKey,
Label as Expression_Label,
Definition as Expression_Definition,
SOE_Comment as Expression_Comment
resident SOE
where SOE_Type ='Expression'
Table not found
SOELabel_Temp:
Load Expression_Label,
Count(DISTINCT Expression_Definition) as Defs
Resident Expressions
Where Not IsNull(Expression_Label)
Group by Expression_Label
Table not found
Expression_LabelSummary:
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],
Expression_Label,
1 as Expression_LabelDefCount
Resident SOELabel_Temp
Table not found
DROP TABLES statement
Table not found
SOEDef_Temp:
Load Expression_Definition,
Count(DISTINCT Expression_Label) as Labels
Resident Expressions
Where Not IsNull(Expression_Definition)
Group by Expression_Definition
Table not found
Expression_DefSummary:
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],
Expression_Definition,
1 as Expression_DefLabelCount
Resident SOEDef_Temp
Table not found
DROP TABLES statement
Field not found - <Group>
Groups:
load
Group as Dimension_Field,
Field as Group_Members,
If(IsCyclic='true','Cyclic','Hierarchic') as Group_Type
resident SOE
where SOE_Type ='Group'
Field not found - <Sheet>
ChartType:
load
ObjectKey, SOE_Type as ChartType
resident SOE
WHERE not isnull(Sheet)
Field not found - <IsConfig>
Variables:
load
FileName, Label as Variable_Name,
Definition as Variable_Def,
if(lower(IsConfig)='true' or lower(IsReserved)='true','System','User') as Variable_Type
resident SOE
where SOE_Type ='Variable'
Table not found
DROP TABLES statement
Table not found
tempQVDs:
Load FileName as tempFileName,
LoadDateKey
Resident FileList
Where Extension = 'qvd'
AND FileDate >= '2015-02-09'
AND (FileTime >= '1995-08-26 00:00:00'
OR not exists (QVD_FileName,FileName))
AND not exists (NonReadableMetadataQVD,FileName)
Script line error:
IF > 0 then
Script line error:
ELSE
Script line error:
ENDIF
Table not found
DROP TABLES statement
