03-29-2013 07:21 AM - edited 03-14-2019 11:28 AM
Hi all,
I am using CIM 4.4.1 with ES1. I have installed and integrated the CIM with UCCE and all configuration has synch with CIM from UCCE. But i am facing 2 issues right now first my CIM MR PIM is not comming up, it looks the port i an using 38001 is not open, i have requested to relevent team to open it between ICM and CIM.
2- Second thing when i try to start EAAS and Listner service it gives me the attached error "unable to perform any action on the instance as there is no process available on which this instance will run"
Any idea what could be the issue.
Solved! Go to Solution.
03-29-2013 12:55 PM
Expand Shared resources and you will find same directory stucture for listener and EAAS process. First you will have to start the process and then the instance can be started.
If you still not able to start the instance, attach the relavant logs to see what is happening.
Hope this helps.
03-29-2013 12:55 PM
Expand Shared resources and you will find same directory stucture for listener and EAAS process. First you will have to start the process and then the instance can be started.
If you still not able to start the instance, attach the relavant logs to see what is happening.
Hope this helps.
06-13-2017 03:49 AM
Where i need to find Expand Shared resources . I have installed 11.0.1 then upgraded to 11.0.2b .
I am able to start retriever and dispatched ,but not able to Instance .
Error message is : unable to perform any action on the instance as there is no process available on which this instance can run .
Please let me know what is wrong .
Ram.S
06-13-2017 04:59 AM
I found it working now.
06-15-2017 09:00 AM
Hi All,
I am not able to receive the mail from exchange . I can able to sent mail from EIM .
i have changed to Pop3 and IMAP . but no luck .
2017-06-12 18:38:53.680 GMT+0000 <@> PERF <@> [21:Thread-2] <@> ProcessId:10100 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:53:680 <&> Time (in millisec) => 1497292733680 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@2c2e6464 <&>
Query Start Time => 1497292733662 <&> Name of Query => license::get_all_license_ids <&>
Query Text => SELECT egpl_license.license_id FROM egpl_license <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:53:680 <&> Time (in millisec) => 1497292733680 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@5b085698 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-12 18:38:53.693 GMT+0000 <@> PERF <@> [21:Thread-2] <@> ProcessId:10100 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:53:693 <&> Time (in millisec) => 1497292733693 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@2c2e6464 <&>
Query Start Time => 1497292733662 <&> Name of Query => license::get_all_license_ids <&>
Query Text => SELECT egpl_license.license_id FROM egpl_license <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:53:693 <&> Time (in millisec) => 1497292733693 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@5b085698 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:53:693 <&> Time (in millisec) => 1497292733693 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@1fbaf3fa <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-12 18:38:55.041 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:10100 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:55:41 <&> Time (in millisec) => 1497292735041 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@167c34a0 <&>
Query Start Time => 1497292735026 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:55:41 <&> Time (in millisec) => 1497292735041 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@6cd4b0b2 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-12 18:38:55.057 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:10100 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:55:57 <&> Time (in millisec) => 1497292735057 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@167c34a0 <&>
Query Start Time => 1497292735026 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:55:57 <&> Time (in millisec) => 1497292735057 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@6cd4b0b2 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 18:38:55:57 <&> Time (in millisec) => 1497292735057 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@1c66dc04 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-12 19:38:36.012 GMT+0000 <@> PERF <@> [21:Thread-2] <@> ProcessId:9072 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:36:12 <&> Time (in millisec) => 1497296316012 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@6f272723 <&>
Query Start Time => 1497296315996 <&> Name of Query => license::get_all_license_ids <&>
Query Text => SELECT egpl_license.license_id FROM egpl_license <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:36:12 <&> Time (in millisec) => 1497296316012 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@f5564bb <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-12 19:38:36.037 GMT+0000 <@> PERF <@> [21:Thread-2] <@> ProcessId:9072 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:36:37 <&> Time (in millisec) => 1497296316037 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@6f272723 <&>
Query Start Time => 1497296315996 <&> Name of Query => license::get_all_license_ids <&>
Query Text => SELECT egpl_license.license_id FROM egpl_license <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:36:37 <&> Time (in millisec) => 1497296316037 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@f5564bb <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:36:37 <&> Time (in millisec) => 1497296316037 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@1716e3c0 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-12 19:38:37.348 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:9072 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:37:348 <&> Time (in millisec) => 1497296317348 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@28780af0 <&>
Query Start Time => 1497296317332 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:37:348 <&> Time (in millisec) => 1497296317348 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@69998799 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-12 19:38:37.363 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:9072 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:37:363 <&> Time (in millisec) => 1497296317363 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@28780af0 <&>
Query Start Time => 1497296317332 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:37:363 <&> Time (in millisec) => 1497296317363 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@69998799 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 12-6-2017 19:38:37:363 <&> Time (in millisec) => 1497296317363 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@6a21d474 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 08:31:08.518 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:9072 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 8:31:8:518 <&> Time (in millisec) => 1497342668518 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@1716e3c0 <&>
Query Start Time => 1497342668491 <&> Name of Query => dsm::update_monitor_instance <&>
Query Text => {? = call egpl_updt_instance_monitor ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) } <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 8:31:8:518 <&> Time (in millisec) => 1497342668518 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@62bb777 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 08:31:08.530 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:9072 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 8:31:8:530 <&> Time (in millisec) => 1497342668530 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@1716e3c0 <&>
Query Start Time => 1497342668491 <&> Name of Query => dsm::update_monitor_instance <&>
Query Text => {? = call egpl_updt_instance_monitor ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) } <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 8:31:8:530 <&> Time (in millisec) => 1497342668530 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@62bb777 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 8:31:8:530 <&> Time (in millisec) => 1497342668530 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@79970b5d <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 10:58:32.689 GMT+0000 <@> PERF <@> [20:Thread-1] <@> ProcessId:8704 <@> PID:0 <@> UID:1 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 13:58:32:689 <&> Time (in millisec) => 1497351512689 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@63421470 <&>
Query Start Time => 1497351512674 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 13:58:32:689 <&> Time (in millisec) => 1497351512689 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@5bdd2efe <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 10:58:32.708 GMT+0000 <@> PERF <@> [20:Thread-1] <@> ProcessId:8704 <@> PID:0 <@> UID:1 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 13:58:32:708 <&> Time (in millisec) => 1497351512708 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@63421470 <&>
Query Start Time => 1497351512674 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 13:58:32:708 <&> Time (in millisec) => 1497351512708 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@5bdd2efe <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 13:58:32:708 <&> Time (in millisec) => 1497351512708 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7786eb10 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 10:58:33.990 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:8704 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 10:58:33:990 <&> Time (in millisec) => 1497351513990 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7f97b918 <&>
Query Start Time => 1497351513970 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 10:58:33:990 <&> Time (in millisec) => 1497351513990 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7fbc892 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 10:58:34.002 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:8704 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 10:58:34:2 <&> Time (in millisec) => 1497351514002 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7f97b918 <&>
Query Start Time => 1497351513970 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 10:58:34:2 <&> Time (in millisec) => 1497351514002 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7fbc892 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 10:58:34:2 <&> Time (in millisec) => 1497351514002 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@1a182406 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 22:39:47.038 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 22:39:47:38 <&> Time (in millisec) => 1497393587038 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7786eb10 <&>
Query Start Time => 1497393587015 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 22:39:47:38 <&> Time (in millisec) => 1497393587038 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@3616d75d <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-13 22:39:47.050 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 22:39:47:50 <&> Time (in millisec) => 1497393587050 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7786eb10 <&>
Query Start Time => 1497393587015 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 22:39:47:50 <&> Time (in millisec) => 1497393587050 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@3616d75d <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 13-6-2017 22:39:47:50 <&> Time (in millisec) => 1497393587050 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@4383763a <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-14 11:01:32.578 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 11:1:32:578 <&> Time (in millisec) => 1497438092578 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@4383763a <&>
Query Start Time => 1497438092555 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 11:1:32:578 <&> Time (in millisec) => 1497438092578 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@51dcbe51 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-14 11:01:32.589 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 11:1:32:589 <&> Time (in millisec) => 1497438092589 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@4383763a <&>
Query Start Time => 1497438092555 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 11:1:32:589 <&> Time (in millisec) => 1497438092589 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@51dcbe51 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 11:1:32:589 <&> Time (in millisec) => 1497438092589 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@582ad0dc <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-14 23:20:22.598 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 23:20:22:597 <&> Time (in millisec) => 1497482422597 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@582ad0dc <&>
Query Start Time => 1497482422574 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 23:20:22:597 <&> Time (in millisec) => 1497482422597 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@3c28557a <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-14 23:20:22.608 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 23:20:22:608 <&> Time (in millisec) => 1497482422608 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@582ad0dc <&>
Query Start Time => 1497482422574 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 23:20:22:608 <&> Time (in millisec) => 1497482422608 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@3c28557a <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 14-6-2017 23:20:22:608 <&> Time (in millisec) => 1497482422608 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@30eaaf16 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-15 12:00:17.191 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 12:0:17:191 <&> Time (in millisec) => 1497528017191 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@30eaaf16 <&>
Query Start Time => 1497528017169 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 12:0:17:191 <&> Time (in millisec) => 1497528017191 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@54df7cbf <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-15 12:00:17.202 GMT+0000 <@> PERF <@> [18:Service Thread] <@> ProcessId:8704 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 12:0:17:202 <&> Time (in millisec) => 1497528017202 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@30eaaf16 <&>
Query Start Time => 1497528017169 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 12:0:17:202 <&> Time (in millisec) => 1497528017202 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@54df7cbf <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 12:0:17:202 <&> Time (in millisec) => 1497528017202 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@4e3e3b4b <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-15 15:17:50.613 GMT+0000 <@> PERF <@> [21:Thread-2] <@> ProcessId:9960 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:50:613 <&> Time (in millisec) => 1497539870613 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@613be5aa <&>
Query Start Time => 1497539870598 <&> Name of Query => license::get_all_license_ids <&>
Query Text => SELECT egpl_license.license_id FROM egpl_license <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:50:613 <&> Time (in millisec) => 1497539870613 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@d2d2e15 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-15 15:17:50.625 GMT+0000 <@> PERF <@> [21:Thread-2] <@> ProcessId:9960 <@> PID:0 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:50:625 <&> Time (in millisec) => 1497539870625 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@613be5aa <&>
Query Start Time => 1497539870598 <&> Name of Query => license::get_all_license_ids <&>
Query Text => SELECT egpl_license.license_id FROM egpl_license <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:50:625 <&> Time (in millisec) => 1497539870625 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@d2d2e15 <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:50:625 <&> Time (in millisec) => 1497539870625 <&> Pool => Master_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@7a8eecbf <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-15 15:17:51.946 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:9960 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:51:946 <&> Time (in millisec) => 1497539871946 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@262c087a <&>
Query Start Time => 1497539871931 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:51:946 <&> Time (in millisec) => 1497539871946 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 2 <&> mCurrentCapacity: 2 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@63620f5f <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
2017-06-15 15:17:51.959 GMT+0000 <@> PERF <@> [35:RMI TCP Connection(2)-172.18.176.33] <@> ProcessId:9960 <@> PID:1 <@> UID:12 <@> HttpSessionId: <@> DBConnectionPool <@> logConnPoolStat() <@> Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:51:959 <&> Time (in millisec) => 1497539871959 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 0 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@262c087a <&>
Query Start Time => 1497539871931 <&> Name of Query => preference::getsettingdatastruct <&>
Query Text => SELECT egpl_pref_globalsettings.dynamic_source dynamic_source, egpl_pref_globalsettings.is_visible is_visible, egpl_pref_globalsettings.level_id level_id, egpl_pref_globalsettings.setting_type setting_type, egpl_pref_globalsettings.is_department is_department_setting, egpl_pref_globalsettings.is_userdefined is_userdefined, egpl_pref_globalsettings.setting_id setting_id, egpl_pref_globalsettings.setting_def_val setting_def_val, egpl_pref_globalsettings.setting_name setting_name, egpl_pref_globalsettings.is_preference is_preference, egpl_pref_globalsettings.is_dynamic is_dynamic, egpl_pref_globalsettings.setting_act_val setting_act_val, egpl_pref_globalsettings.is_read_only is_read_only FROM egpl_pref_globalsettings WHERE LOWER( egpl_pref_globalsettings.setting_name ) = LOWER( ? ) <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:51:959 <&> Time (in millisec) => 1497539871959 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 1 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@63620f5f <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
Time (dd-mm-yyyy HH:mm:ss:SSS) => 15-6-2017 15:17:51:959 <&> Time (in millisec) => 1497539871959 <&> Pool => Platform_MSSQL_Pool <&> Num Idle Connections: 3 <&> mCurrentCapacity: 3 <&> mMaxCapacity: 600 <&>
Connection No. => 2 <&> DBConnection Status => CONNECTION_IDLE <&> DBConnection object: com.egain.platform.framework.dataaccess.dbconnectionfactory.DBConnection@30e19cda <&>
Query Start Time => -1 <&> Name of Query => null <&>
Query Text => null <&>
<@>
Please check and let me know . hot to make it work .
Ram.S
01-09-2019 06:46 AM
hi where you find the expand the resource. is it compulsory EAAS and listener service must be run. in our EIM the both services are not running and appear the same error message as you highlighted.
01-12-2020 12:37 AM
Hi
can you tell me please how did you find it?
thank you
01-13-2020 10:02 AM
What problems are your facing? Can you post screen shots and/or logs?
03-29-2013 01:00 PM
Thanks Gaurav, i works now.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide