From $ORACLE_AGENT/sysman/log/emagent.trc, it said dynamic properties are missing but actually the value is not when I execute "emctl reload agent dynamicproperties ...". The error message like below,
/*******************
2009-06-23 19:28:30,499 Thread-2674 WARN TargetManager: The execution of the query for CheckStartConf in {aaa, CALL_IT_FV} is missing the following required property values : NAME;VALUE
******************/
Here is the dynamic property "CheckStartConf" value in MGMT_TARGET_PROPERTIES,
/**************************
SELECT * FROM mgmt_target_properties
where target_guid in (select target_guid from mgmt_targets where target_name like 'aaa') AND PROPERTY_NAME='runuser';
|TARGET_GUID|PROPERTY_NAME|PROPERTY_TYPE|PROPERTY_VALUE|
-----------------------------------------------------------------------------------------------------------------------------------
|8E9C70BFE8017888EA4885F81DC7A19E|runuser|INSTANCE|0 |
**************************/
And I noticed that only dynamic properties whose TYPE='TABLE' are getting those errors, and if I change the TYPE to TYPE='ROW' then no errors generated.
Here is the definition of dynamic property "CheckStartConf" in XML.
/**************************
<DynamicProperties NAME="CheckStartConf" PROP_LIST="NAME;VALUE" FORMAT="TABLE">
<QueryDescriptor FETCHLET_ID="OSLineToken">
<Property NAME="emdRoot" SCOPE="SYSTEMGLOBAL">emdRoot</Property>
<Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
<Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
<Property NAME="host" SCOPE="INSTANCE" OPTIONAL="TRUE">host</Property>
<Property NAME="port" SCOPE="INSTANCE" OPTIONAL="TRUE">port</Property>
<Property NAME="uname" SCOPE="INSTANCE" OPTIONAL="TRUE">uname</Property>
<Property NAME="pass" SCOPE="INSTANCE" OPTIONAL="TRUE">pass</Property>
<Property NAME="mysqlhome" SCOPE="INSTANCE">mysqlhome</Property>
<Property NAME="mydelimiter" SCOPE="INSTANCE">mydelimiter</Property>
<Property NAME="command" SCOPE="GLOBAL">"%perlBin%/perl" "%scriptsDir%/emx/%TYPE%/CheckStartConf.pl" "%mysqlhome%" "%mydelimiter%" "%host%" "%port%" "%uname%" "%pass%"</Property>
<Property NAME="delimiter" SCOPE="GLOBAL">%mydelimiter%</Property>
<Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
<Property NAME="errStartsWith" SCOPE="GLOBAL">em_error=</Property>
<!--<Property NAME="EM_METRIC_TIMEOUT" SCOPE="GLOBAL">60</Property>-->
</QueryDescriptor>
</DynamicProperties>
*****************************************************/
Any help will be appreciated!!!
Thanks,
Satine