LogoDark mode logo
LogoDark mode logo
Contact SupportLoading Light/Dark Toggle

    • Web API "An error occurred while sending the request"
    • The Visio diagram is not showing properly or some elements are missing
    • Troubleshooting the SQL tile
    • Troubleshooting the Visio tile
    • Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
    • The tile could not be found you, may be missing a dashboard pack
    • No values found for the given metric for the last <time period> at the resolution '<raw/hourly/daily>'
    • Login failed for user on Performance tile
    • Groups show no health information
  • Collecting diagnostic information
  • Operations Manager 2012 Data Warehouse Health Check Script
  • Where to find log files

troubleshootingdashboardstroubleshooting the sql tile

Troubleshooting the SQL tile

In this article:

General Troubleshooting

Line Graph shows "A value column and a timestamp column are mandatory in the query results, please modify your query"

General Troubleshooting

If you are having problems using the SQL tile to add SQL queries into SquaredUp DS please check the following:

Here are a few things to check if you're finding the SQL tile shows no data.

  1. Test the query in SQL Server Management Studio
    Run the query in SQL Server Management Studio on the SQL server. Are results shown? If not, then there is a problem with the query.
  2. Check SquaredUp DS has access to the database being queried.
    By default, access to the Data Warehouse database is configured during the SquaredUp DS setup process, but you will need to configure access to any other database.
    Check that the SquaredUp DS application pool account has the db_datareader role on the database that is being queried (see How to check and modify the application pool identity). See How to configure access to a database for use with the SQL tile.
    It is important to note that the account you are logging into SquaredUp DS with has no effect on database access. What is important is the user (identity) of the application pool inside IIS which is being used by SquaredUp DS (see How to check and modify the application pool identity).
  3. Check the connection string in the SQL tile configuration.
    To query the Data Warehouse the connection string can simply be set to:
    global:dw
    To connect to any other database you will need to specify the server and database as described below:
    Data Source=<SQLservername>;Initial Catalog=<DatabaseName>;Integrated Security=True;
    For more information about connection strings see How to use the SQL tile.
  4. Check that you are using the correct tile type (Grid or Scalar) depending on the results output in SQL Server Management Studio.
    The SQL Grid tile should be used for queries that return a table of results.
    The SQL Scalar tile should be used when the result of the query is a single number.

Line Graph shows "A value column and a timestamp column are mandatory in the query results, please modify your query"

Both a DateTime field AND a Numeric value field are necessary for a line graph or column graph to be drawn. This message indicates that the query results are missing either a DateTime field, a Numeric value field or both.

Was this article helpful?


Have more questions or facing an issue?
Submit a ticket

On this page

  • General Troubleshooting
  • Line Graph shows "A value column and a timestamp column are mandatory in the query results, please modify your query"

Footer

Sites

  • SQUAREDUP
  • SQUAREDUP DS
  • DOWNLOAD
  • COMMUNITY ANSWERS

Quick Links

  • SUBMIT A REQUEST
  • EVENTS
  • CAREERS

Small Print

  • PRIVACY POLICY
  • TERMS AND CONDITIONS
Youtubex (Twitter)LinkedIn

© SquaredUp 2025