Run Module Error After Querying Db

[PhilRobert]

One one my script generates an error after querying the database. I copied the event log here and have attached the script file. If anyone has a clue...

 

By the way I'm working with version 5.1.8 and a Dialogic D/4PCI Card, under Windows XP... Thanks for the help = )

 

101129,13 0 sys cleanup Start

101129,13 0 sys cleanup End

101132,83 9 linedevstate 2048 0 0

101132,83 9 callstate OFFERING 66150 0 4

101132,84 9 callinfo CALLEDID

101132,84 9 callinfo ORIGIN

101132,84 9 ring 0

101138,83 9 ring 2

101138,83 9 Answer the call at 2004-03-09 10:11:38

101138,83 9 lineAnswer(66150) => 66133

101139,38 9 callstate CONNECTED 66150,1,0

101139,38 9 WorkingModeTAPI@Connected=

101139,38 9 WorkingModeScript@Connected=

101139,41 9 Inband detection not enabled

101139,41 9 StartLoadedVgs at 2004-03-09 10:11:39

101139,41 9 tapi Reply (LineEvReply) ok 66133 0

101139,41 9 [Greetings] Playing

101139,41 9 [Greetings] Playing (Dialogic\Code_valide_1.wav)

101139,42 9 PlaySoundStart ok [C:\Documents and Settings\phirob\Bureau\VoiceGuide\Dialogic\Code_valide_1.wav]

101139,42 9 RunModule PLAY end

101143,06 9 wb(29798400)

101143,08 9 Play End line[9] (id=297984)

101143,09 9 LsPlayMsg EV_PLAY_FINISHED

101144,08 9 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

101144,08 9 [Language_select] Number Input

101144,08 9 [Language_select] Playing (Dialogic\Veuillez_entrer_code_acces_1.wav)

101144,09 9 PlaySoundStart ok [C:\Documents and Settings\phirob\Bureau\VoiceGuide\Dialogic\Veuillez_entrer_code_acces_1.wav]

101145,09 9 dtmf 1 (66150,49,2)

101145,09 9 LsGetNbrsPlayWelcMsg 1

101145,16 9 PlaySoundStop err=0

101145,16 9 [Language_select] Number Input 1

101145,16 9 [system_select] Number Input

101145,16 9 [system_select] Playing (Dialogic\Veuillez_entrer_code_acces_1.wav)

101145,17 9 PlaySoundStart ok [C:\Documents and Settings\phirob\Bureau\VoiceGuide\Dialogic\Veuillez_entrer_code_acces_1.wav]

101146,44 9 dtmf 1 (66150,49,2)

101146,44 9 LsGetNbrsPlayWelcMsg 1

101146,50 9 PlaySoundStop err=0

101146,50 9 [system_select] Number Input 1

101146,50 9 [Get_PIN] Number Input

101146,50 9 [Get_PIN] Playing (Dialogic\Veuillez_entrer_code_acces_1.wav)

101146,52 9 PlaySoundStart ok [C:\Documents and Settings\phirob\Bureau\VoiceGuide\Dialogic\Veuillez_entrer_code_acces_1.wav]

101148,91 9 dtmf 1 (66150,49,2)

101148,91 9 LsGetNbrsPlayWelcMsg 1

101148,95 9 PlaySoundStop err=0

101148,95 9 [Get_PIN] Number Input 1

101148,95 9 path {1} not found

101149,25 9 dtmf 0 (66150,48,2)

101149,25 9 LsGetNbrsRxDigits 0

101149,25 9 [Get_PIN] Number Input 10

101149,25 9 path {10} not found

101149,73 9 dtmf 1 (66150,49,2)

101149,73 9 LsGetNbrsRxDigits 1

101149,75 9 [Get_PIN] Number Input 101

101149,75 9 path {101} not found

101150,45 9 dtmf 0 (66150,48,2)

101150,45 9 LsGetNbrsRxDigits 0

101150,45 9 [Get_PIN] Number Input 1010

101150,45 9 path {1010} not found

101150,45 9 path {1010} not found

101150,45 9 [Validate_PIN] DB Query

101150,45 9 ODBC mode used

101150,47 9 RVreplace start: [sELECT REP.CODE FROM REP WHERE REP.CODE='$RV[Get_PIN]']

101150,47 9 RVreplace end: [sELECT REP.CODE FROM REP WHERE REP.CODE=1010]

101150,47 9 About to execute Retrieve Operation [sELECT REP.CODE FROM REP WHERE REP.CODE=1010]

101150,47 9 [Validate_PIN] row count=1

101150,47 9 ERROR 5.1.8001 RunModule:0:3001:Argument non valide.:DAO.Recordset

101150,47 9 Hanging up call... [RunModule Error]

101150,47 9 RecSoundStop ok

101150,47 9 PlaySoundStop err=0

101150,48 9 fnHangupCall end

101150,52 9 linedevstate 2048 0 0

101150,52 9 callstate IDLE 66150 0 0

101150,52 9 WorkingMode@Idle=

101150,53 9 tapi Reply (LineEvReply) ok 66116 0

101151,53 9 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

101151,53 9 ReinitTelephony due to IDLE

101151,53 9 tapic lineDeallocateCall(MainCall:66150) 0

101151,69 9 lineOpen(9) => 0

101151,69 9 Waiting for a call...

101151,69 9 LineHandle=66099

MyScript.zip

[SupportTeam]

Could you also please post a copy of the database so that we may reproduce the error.

[SupportTeam]

We've determined cause of database problem.

In VG.INI file, section [moduleDBQuery] change:

 

RecordsetGetRowsMax=0

 

to

 

RecordsetGetRowsMax=1000

 

(or some other high value)

[PhilRobert]

Thanks a lot for your precious help = )

You guyz rock! Keep up the good work!

[SupportTeam]

Current download available form our WWW has this bug rectified. RecordsetGetRowsMax in VG.INI can now be set to 0 and this will no longer produce any problems.