Faxing Problem Using Xml File

[mediasol]

I'm using a xml file and voicegude script to send a fax.

 

The xml file is upload into the database, but then it is do not anything. The job just stay in the queue.

 

What is wrong? (I have upload log and xml file.

Copy_of_mbscall.txt

0423_1609_vgDialListLoad.zip

[SupportTeam]

vgEngine trace shows the VoiceGudie could not load the suppled XML file into the outdial database:

 

160907.109 4 0 ERROR dr[iD] : Could not find specified column in results

 

vgEngine trace also shows that you have setup the system to use the MySQL database instead of the default (VistaDB) database engine.

 

You should be able to see in the MySQL logs as to why MySQL is returning an error when trying to the INSERT, and that should let you see what needs to be fixed.

 

One thing that you could try is stop VG, delete all the tables in the MySQL database, and the restart VG and let VG re-create the tables. Maybe you have older table structure for previous VoiceGuide versions, and table recreation will update them.

 

 

 

160907.046 4 0 OutDial load from [C:\Program Files\VoiceGuide\data\OutDial_23420091696.xml]

160907.046 4 DialListLoadFileXML ReadAllText call

160907.078 4 0 Db_Insert_PrepareCmdParams AddParamToCmd calls

160907.078 4 0 Db_Insert_PrepareCmdParams cmdCQ.Parameters[...] set calls.

160907.078 4 0 oOutCallData = .+

160907.078 4 0 Db_Insert_PrepareCmdParams strOnAnswerLive value=

160907.078 4 0 dial Db_Insert_CallQueAndPortList CallQue insert call [18310755279677]

160907.078 4 0 dial cmd_CallQue_Insert.ExecuteReader [18310755279677] call

160907.078 4 0 dial cmd_CallQue_Insert sql [iNSERT INTO CallQue (PhoneNumber, PhoneNumberPrefix, ActivateTime, TimeStart_Mon, TimeStart_Tue, TimeStart_Wed, TimeStart_Thu, TimeStart_Fri, TimeStart_Sat, TimeStart_Sun, TimeStop_Mon, TimeStop_Tue, TimeStop_Wed, TimeStop_Thu, TimeStop_Fri, TimeStop_Sat, TimeStop_Sun, CampaignName, Priority, OnAnswerLive, OnAnswerMachine, OnAnswerFax, OnNotAnswered, OnRetriesExhausted, AnswerTimeout, RetriesLeft, RetriesDelay, RV, CallOptions, EscalationCalls) VALUES (@strNbrToDial, @strPhoneNumberPrefix, @dateActivateTime, @iTimeStart_Mon, @iTimeStart_Tue, @iTimeStart_Wed, @iTimeStart_Thu, @iTimeStart_Fri, @iTimeStart_Sat, @iTimeStart_Sun, @iTimeStop_Mon, @iTimeStop_Tue, @iTimeStop_Wed, @iTimeStop_Thu, @iTimeStop_Fri, @iTimeStop_Sat, @iTimeStop_Sun, @strCampaignName, @iPriority, @strOnAnswerLive, @strOnAnswerMachine, @strOnAnswerFax, @strOnNotAnswered, @strOnRetriesExhausted, @iAnswerTimeout, @iRetriesLeft, @iRetriesDelay, @strRV, @strOptions, @strEscalationCalls);SELECT DISTINCT @@identity FROM CallQue;]

160907.109 4 0 dial cmd_CallQue_Insert.ExecuteReader [18310755279677] returned, some data FieldCount=1

160907.109 4 0 ERROR dr[iD] : Could not find specified column in results

160907.109 4 0 dial cmd_CallQue_Insert.ExecuteReader [18310755279677] sID=NOT SET, oID=13, iID=13

160907.109 4 0 dial Db_Insert_CallQueAndPortList CallQue insert returned TimeSpan=00:00:00.0312500

160907.109 4 dial Db_Insert_CallQueAndPortList iID_JustInserted=13

160907.109 4 dial Db_Insert_PortToUse id=13, guid=[20e0247e-0311-4481-b6b9-361fb2aa2af9] sPortList=[3,4,5,6,7,8]

160907.265 4 dial Db_Insert_PortToUse : INSERT INTO PortToUse (CallID, PortNumber, ActivateTime, Priority, TimeStart_Mon, TimeStart_Tue, TimeStart_Wed, TimeStart_Thu, TimeStart_Fri, TimeStart_Sat, TimeStart_Sun, TimeStop_Mon, TimeStop_Tue, TimeStop_Wed, TimeStop_Thu, TimeStop_Fri, TimeStop_Sat, TimeStop_Sun ) VALUES (@iCallID, @iPortNumber, @dateActivateTime, @iPriority, @iTimeStart_Mon, @iTimeStart_Tue, @iTimeStart_Wed, @iTimeStart_Thu, @iTimeStart_Fri, @iTimeStart_Sat, @iTimeStart_Sun, @iTimeStop_Mon, @iTimeStop_Tue, @iTimeStop_Wed, @iTimeStop_Thu, @iTimeStop_Fri, @iTimeStop_Sat, @iTimeStop_Sun );

160907.265 4 dial Db_Insert_PortToUse inserts made: 6, ts=00:00:00.1562500

160907.265 4 dial Db_Insert_CallQueAndPortList Db_Insert_PortToUse returned

160907.265 4 0 OutDial input file : loaded 1 entries from C:\Program Files\VoiceGuide\data\OutDial_23420091696.xml

160907.265 4 OutDial input file deleted : C:\Program Files\VoiceGuide\data\OutDial_23420091696.xml