Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.