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