Sql Server Outdialque Stopped Working

[jewillis]

Upgraded to 7.0.3149.39709 from 7.0.2942.25251 and the sql server OutDialQue has stopped working. The SQL Server Log is working. We are have 46 lines licensed for the production server and are running the upgrade on a test server in evaluation mode to ensure all issues are resolved prior to upgrading the production server.

 

All ini and config files are mirrors of each other

 

Any suggestions would be appreciated

 

 

***INI FILE***

[VGDialer]

 

OutDialQue_ODBC_ConnectString=Driver={SQL Native Client};Server=127.0.0.1;Database=OutDialQue;Uid=vg;Pwd=vg;

 

*** FROM LOG***

 

164300.609 5 C:\Program Files\VoiceGuide\VG.INI [VGDialer]:OutDialQue_ODBC_ConnectString = Driver={SQL Native Client};Server=127.0.0.1;Database=OutDialQue;Uid=vg;Pwd=vg;

164300.609 5 C:\Program Files\VoiceGuide\VG.INI [VGDialer]:OutDialQue_ODBC_SqlPrefix =

164300.609 5 C:\Program Files\VoiceGuide\VG.INI [VGDialer]:OutDialQue_ODBC_SqlSuffix =

164300.609 5 C:\Program Files\VoiceGuide\VG.INI [VGDialer]:AM_WelcMsgMinLen = 20

164300.609 5 C:\Program Files\VoiceGuide\VG.INI [Log]:CDR_ODBC_ConnectString = Driver={SQL Native Client};Server=127.0.0.1;Database=CdrLog;Uid=vg;Pwd=vg;

164300.609 5 C:\Program Files\VoiceGuide\VG.INI [Log]:CDR_LastData_SaveRv = 1

 

 

[SupportTeam]

Could you please post a copy of VoiceGuide's Trace Logs which captures the entire system startup, this will allow us to see what happened.

 

Trace files are created in VG's \log\ subdirectory.

 

Please post the traces.

 

When posting traces/scripts please .ZIP them up and post them as attachments.

[jewillis]

Found the problem- Apparently a new column was added in this release "OnAnswerFax", that was hidden in the documentatuion (only found it when I did a search on that column name). Not listed as part of the schema, but only in an example insert statement.

 

I added the column and all is working

 

are there release notes I overlooked?

 

 

193250.078 10 0 ERROR v7.0.3149.39709 (Fri 15/08/2008 21:03:39.35) DoWorkFindCall source2odbc ExecuteReader sql:[Driver={SQL Native Client};Server=127.0.0.1;Database=OutDialQue;Uid=vg;Pwd=vg;] : ERROR [42S22] [Microsoft]

[sql Server]Invalid column name 'OnAnswerFax'.