I have IPCC Express Premium 4.0(3) and mysql, for checking DNIS.
When I create Enterprise Database Subsystem Datasource it work fine but in MIVR log I see:
2397153: Sep 26 06:15:51.367 GEST %MIVR-SS_DB-7-UNK: Checkout Connection
2397154: Sep 26 06:15:51.367 GEST %MIVR-SS_DB-7-UNK: GetAvailableConnection
2397155: Sep 26 06:15:51.367 GEST %MIVR-SS_DB-7-UNK: Granted connection # 136
2397156: Sep 26 06:15:51.367 GEST %MIVR-SS_DB-7-UNK:Database subsystem Polling S
QLState: 37000. If the database subsystem is OUT_OF_SERVICE please ensure that P
olling SQLState exists in the list of values for the property com.cisco.wf.subsy
stems.edbs.SQLState=|HY000|Polling_SQLState_value| in the file wfavvid\Subsystem
EDBS.properties.
2397157: Sep 26 06:15:51.367 GEST %MIVR-SS_DB-7-UNK:EDBSConnection.checkConnecti
onState() - Ok.
2397158: Sep 26 06:15:51.367 GEST %MIVR-SS_DB-7-UNK: Checkin Connection # 136
2397159: Sep 26 06:15:51.367 GEST %MIVR-SS_DB-7-UNK: Connection : 136 added to available list.
SQLState: 37000 I have add in SubsystemEDBS.properties -> com.cisco.wf.subsystems.edbs.SQLState=|HY000|37000|
But on next day it don't work. If I delete datastore and create again it work till next the day. Groundhog Day...