Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

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

3 Replies
Highlighted
Employee
Employee

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

Highlighted
Contributor III
Contributor III

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?

Highlighted
Employee
Employee

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.