EDBS & MyODBC

[mark_ittt]

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...

[pradeepde]

If you have more than one db resource (i.e more than one DBRead/DBGet pair). The second DBGet step always throws File I/O exception once you save and re-open the script. This is strictly a cosmetic dialog box, the attributes of the DBGet and DBRead steps are intact.