Troubleshooting
Problem
The tasks of an Event Studio agent are never executed. In the agent's run history is always the following info message documented:
Symptom
CNC-ASV-0050 Event condition not met
Cause
The event condition does not cause any transaction on any of the database's tables/ cube as long as the result can be calculated.
Diagnosing The Problem
Event conditions are never met as long as there is no direct transaction on any database table / cube. The same behavior can be investigated when the condition is used.
Resolving The Problem
Enhance the event condition with a Boolean condition that provokes at least one database access and where the result is always true.
- example 1:
Event condition 'sysdate() = 2008-03-27' is never met, not even on March, 27th of 2008. Instead of 'sysdate() = 2008-03-27' use:
extract(day, maximum([Introduction date])) > 0 and sysdate() = 2008-03-27
- example 2:
Event condition '1=1' is also never met. Instead of '1=1' use:
caption([xxx]) = 'xxx'
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Event Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.1.1;10.2.2;8.3;8.4.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1039232
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21342900