Solved: EAAS and Listner service are not comming up

Sheraz Saeed Lodhi · ‎03-29-2013

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.

Gaurav Thakur · ‎03-29-2013

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.

View solution in original post

Gaurav Thakur · ‎03-29-2013

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.

Ramamoorthy Shanmugam · ‎06-13-2017

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

Regards,
Ram.S

Ramamoorthy Shanmugam · ‎06-13-2017

I found it working now.

Regards,
Ram.S

Ramamoorthy Shanmugam · ‎06-15-2017

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

Regards,
Ram.S

pravin.muthu@vads.com · ‎01-09-2019

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.

AHMED Ali · ‎01-12-2020

Hi

can you tell me please how did you find it?

thank you

Omar Deen · ‎01-13-2020

What problems are your facing? Can you post screen shots and/or logs?

Sheraz Saeed Lodhi · ‎03-29-2013

Thanks Gaurav, i works now.