4 Replies Latest reply on May 30, 2014 11:57 AM by c.gura

    NPM 10.7 Custom table SQL-based report resource failed to properly initialize

    adeese2

      Does anyone know why the following Custom Table SQL-based report generates error message "Report resource failed to properly initialize"?

      (1) Edit Report | Layout Builder | Custom Table | Edit Table | Preview works

      (2) Edit Report | Layout Builder | Datasource | Edit | Preview works

      (3) Edit Report | Preview | Edit Table | Preview displays error message "Report resource failed to properly initialize".


      SELECT

      APM_ComponentStatus_Detail.TimeStamp

      ,Nodes.NodeID

      ,APM_Application.ID as ApplicationID

      ,APM_Component.ID as ComponentID

      ,Nodes.Caption as NodeName

      ,APM_Application.Name as ApplicationName

      ,APM_Component.Name as ComponentName

      ,APM_PortEvidence_Detail.ResponceTime as ResponseTime

      FROM

      Nodes

      INNER JOIN APM_Application

      ON (APM_Application.NodeID=Nodes.NodeID)

      INNER JOIN APM_Component

      ON (APM_Component.ApplicationID=APM_Application.ID)

      INNER JOIN APM_ComponentStatus_Detail

      ON (APM_ComponentStatus_Detail.ComponentID=APM_Component.ID)

      INNER JOIN APM_PortEvidence_Detail

      ON (APM_PortEvidence_Detail.ComponentStatusID=APM_ComponentStatus_Detail.ID)

      WHERE

      (APM_Application.Name='HTTP Form Login')

      AND

      (

      APM_ComponentStatus_Detail.TimeStamp >= ${FromTime}

      AND

      APM_ComponentStatus_Detail.TimeStamp <  ${ToTime}

      )

      ORDER BY

      APM_ComponentStatus_Detail.TimeStamp

        • Re: NPM 10.7 Custom table SQL-based report resource failed to properly initialize
          adeese2

          Last week this custom table SQL report displayed error when we tried to view it and this week it does not.

          So, it appears we have discovered yet another transient error with unknown root cause.

          Hope you have better user experience.

          Cheers!

          • Re: NPM 10.7 Custom table SQL-based report resource failed to properly initialize
            LadaVarga

            Hello,

             

            Only way how non-admin user can see Custom chart/table with Custom SQL/SWQL datasource is use Custom SWQL instead of custom SQL. It should be easy to rewrite.

            One other note: Use ${FromTimeUTC} instead of ${FromTime} because application statistics is in UTC time.


            Something like this:

            SELECT

            APM_ComponentStatus_Detail.TimeStamp

            ,Nodes.NodeID

            ,APM_Application.ID as ApplicationID

            ,APM_Component.ID as ComponentID

            ,Nodes.Caption as NodeName

            ,APM_Application.Name as ApplicationName

            ,APM_Component.Name as ComponentName

            ,APM_PortEvidence_Detail.AvgresponceTime as ResponseTime

            FROM

            Orion.Nodes nodes

            INNER JOIN Orion.APM.Application APM_Application

            ON (APM_Application.NodeID=Nodes.NodeID)

            INNER JOIN Orion.APM.Component APM_Component

            ON (APM_Component.ApplicationID=APM_Application.ID)

            INNER JOIN Orion.APM.ComponentStatus APM_ComponentStatus_Detail

            ON (APM_ComponentStatus_Detail.ComponentID=APM_Component.ComponentID)

            INNER JOIN Orion.APM.PortEvidence APM_PortEvidence_Detail

            ON (APM_PortEvidence_Detail.ComponentStatusID=APM_ComponentStatus_Detail.ID)

            WHERE

            (APM_Application.Name='HTTP Form Login')

            AND

            (

            APM_ComponentStatus_Detail.TimeStamp >= ${FromTimeUTC}

            AND

            APM_ComponentStatus_Detail.TimeStamp <  ${ToTimeUTC}

            )

            ORDER BY

            APM_ComponentStatus_Detail.TimeStamp

             

            thanks