Qlik Community

QlikView Governance

Discussion Board for collaboration on QlikView Governance.

gksmithlcw
New Contributor

Governance Dashboard Errors

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

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Governance Dashboard Errors

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.

3 Replies
Highlighted
Employee
Employee

Re: Governance Dashboard Errors

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.

gksmithlcw
New Contributor

Re: Governance Dashboard Errors

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?

Employee
Employee

Re: Governance Dashboard Errors

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.