No Sound After Oracle Query

[Guest tafelzeil]

Hello,

 

We have another problem. After we connect to a Oracle database and retrieve data, based on a number that was entered before, in the next steps where we have soundfiles these are not played over the phone.

 

We get data from de database in the step "ophalen gegevens" and one of those fields is processed in the "check nu ziek" evalution function. It then goes to either "intro redenen" or "intro betermelden" but the sound (file) is not heard over the phone.

 

In the supplied log-files we supplied the database with a valid number that should (en does) goto "intro betermelden" only one cannot hear that on the phone.

 

Are we doing something wrong? To be sure we have used only supplied voice files because our own are not in the right format.

tafelzeiltje5.zip

[SupportTeam]

Please .ZIP up and post the pressplz.wav file.

 

114039.281 16 3 state [intro betermelden] Playing wav(C:\Program Files\VoiceGuide\System\voice\pressplz.wav)

114039.281 16 3 timer clear (force=False)

114039.281 16 3 play start ok, lPlayId=552875

114039.281 16 3 db odbc query completed.

114239.078 10 3 ev Dialogic 2086,GCEV_DISCONNECTED,2086,0,0,GC_SUCCESS,GC_SUCCESS,IPERR_OK

[Guest tafelzeil]

Please .ZIP up and post the pressplz.wav file.

 

114039.281 16 3 state [intro betermelden] Playing wav(C:\Program Files\VoiceGuide\System\voice\pressplz.wav)

114039.281 16 3 timer clear (force=False)

114039.281 16 3 play start ok, lPlayId=552875

114039.281 16 3 db odbc query completed.

114239.078 10 3 ev Dialogic 2086,GCEV_DISCONNECTED,2086,0,0,GC_SUCCESS,GC_SUCCESS,IPERR_OK

 

 

As requested the pressplz.wav file in the attachment (is the standard deliverd wav-file)

 

 

We think the problem may be in the following bold line

 

114039.281 16 3 timer clear (force=False)

114039.281 16 3 play start ok, lPlayId=552875

114039.281 16 3 db odbc query completed.

114239.078 10 3 ev Dialogic 2086,GCEV_DISCONNECTED,2086,0,0,GC_SUCCESS,GC_SUCCESS,IPERR_OK[/font]

 

It looks like the database query ends very late and it might interfere with the playing of the wav file.

 

tafelzeiltje6.zip

[CSI]

I believe I have the same issue.

 

135751.632 18 1 PrepareAndPlayWavAndTTS sPlayFile=d:\sounds\merisantequal\Greeting.wav

135751.632 18 1 state [Play Greeting] Playing wav(d:\sounds\meq\Greeting.wav)

135751.632 18 1 timer clear (force=False)

135751.648 18 1 play start ok, lPlayId=235781

135751.648 18 1 db odbc query completed.

135808.445 9 1 ev dtmf # (1,35,0)

135808.445 9 1 ScriptEventCode #, code=35, state=1100

135808.445 9 1 LsPlayMsg #,#

135808.445 9 1 path {#} not found

135809.226 9 1 ev dtmf * (1,42,0)

135809.226 9 1 ScriptEventCode *, code=42, state=1100

135809.226 9 1 LsPlayMsg *,*

135809.226 9 1 path {*} not found

135810.460 9 1 ev dtmf 0 (1,48,0)

135810.460 9 1 ScriptEventCode 0, code=48, state=1100

135810.460 9 1 LsPlayMsg 0,0

135810.460 9 1 path {0} not found

135811.507 9 1 ev dtmf d (1,100,0)

135811.507 9 1 ScriptEventCode d, code=100, state=1100

135811.507 9 1 LsPlayMsg d,d

135811.507 9 1 path {d} not found

 

 

In fact, the line seems to just hand there forever (I had a test call that tied up the port until it was cancelled several hours later through the status monitor). It plays the files fine if I do not do the database query first.

[SupportTeam]

We have confirmed that in current v7 release there is bug with playing/recording immediately after a Database Query module.

 

The workaround for now may be to use a Play module which does not actually play anything (specify none as the sound file) and has a {timeout 1} path going to the Play module which plays the actual sound file.

 

We should have a fix available when for this issue by Monday (in 2 days time).

[SupportTeam]

The latest v7 release now fixes this issue. Please download the latest release currently available from our WWW.

[Guest tafelzeil]

The latest v7 release now fixes this issue. Please download the latest release currently available from our WWW.

 

We have installed this new version and the problems with database connections and playing sound files are gone.

 

Thx.

[CSI]

Confirmed. It is working correctly with the latest version.