Bringing in data from external data sources into the SMP Server for reporting purposes

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

You are running a large report that references several other databases on the same DB server and uses a few temp tables.  It ran in under 5 minutes when you ran it in SQL management studio from the Altiris DB, but when running this via the reporting interface it errors out when trying to create it. 

The error seen is "Failed to retrieve schema information from run." 

You tried to convert the temp tables to global temp tables to allow them to persist beyond the session in which they were created, but the Altiris interface fails in the same way even though the temp tables are there and accessible.

 

Environment

ITMS 8.x

Resolution

The supported method for bringing in data for reporting is to use Data Import / Connector solution, and bring the external data into the CMDB.  Doing it this way makes reporting simple.