Helping us help you - ITM Bitesize Edition
ShaunR 2700005SW1 Visits (7881)
Hello again folks,
For this bitesize blog we've got a useful tip for ITM situations, specifically those using the "MISSING" function, which can be a bit thorny. Specifically, we're looking into an issue where a situation using the "MISSING" function does not fire as expected when it's been set up to monitor two items with similar names.
The explanation behind this is that ITM framework uses the SQL1 language, which is broadly similar to standard SQL, but not exactly the same which is what causes the issue in this specific instance.
In SQL1, *abc and *abc* is equivalent to SQL 'LIKE'. In the case of the situation here, the MISSING function does not fire because testfile1 is LIKE testfile and it's unable to tell the difference between the two.
I'm afraid that in this instance, this is considered to be working as designed and just something we need to find a way around. I hope this helps when it comes to constructing your situations around this function.
Subscribe and follow us for all the latest information directly on your social feeds: