4Site
Support Request System
View Patch #40.027.019
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
none
Symptoms:
Attempting to run the PMList report produces the error , "Invalid object name TestV3.dbo.pmprogram"
Solution:
Patch 40.024.017 changed the PMList report to use the PM trigger table rather than the PM task table to get the equipment related to a PM task. In making this change, a quirky behaviour of Crystal Reports was revealed. If the original SQL statement for the report was developed using the Crystal Wizard, then changing the query statement in the Show SQL Query window hard codes the connected database in the query.
Browse Patches
Find a Patch
Return to Request System Menu