3 Replies Latest reply: Feb 9, 2017 2:39 PM by Tyler Waterfall RSS

    Governance Dashboard Errors

    Grant Smith

      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