badfetch

[SWSDEV]

I keep getting a badfetch error when I try to use a database component. I've tried removing the variables and changing settings, but the error seems to broad to know what to try.

Any help?

 

[VAD_Support]

How are you filling the database component properties? Can you post a screenshot of the configuration dialog, or paste here the values you're using? Also, the exact error text you're getting will help us to know what's going on...

 

[SWSDEV]

This badfetch is coming back to haunt me... I can't seem to make database calls.

Here's a screen shot of my component...

 

[VAD_Support]

Can you provide the error reported in 3CXIvrServer.log?
Thanks.

 

[SWSDEV]

Where is it located on windows 2003?

 

[SWSDEV]

Here's the log.

I had to replace the "http" text in this log with "_ttp" because the message board would not permit more than two urls in a message.

2009/09/21 >>
05:07:12.296|0224|.\PbxMedia\IVREngine.cpp(883):IvrService, IVREngine::RegisterLines(), Registering of lines...127.0.0.1:5060127.0.0.1:5060999[800,856][401,402][MakeCall]
05:07:12.296|0224|.\PbxMedia\IVREngine.cpp(1036):IvrService, IVREngine::RegisterLines(), Registering of lines done.
05:09:42.609|1152|(0):Error! Module '3CX.com.OSBinet'. Error ID 302. URL_ttp://localhost:5484/(S(wp1l3qmwx0xqvn45fpyncbes))/dr.aspx?dr=800&to=800&from=8019387712
05:09:50.968|1152|.\api\VXItelImpl.cpp(148):IvrDll, VXItelImpl::Impl::IntrnTransfer(), Error! Error of 'From_8019387712_To_800_Menu_800_#0/45' session transferring to sip:[email protected]:5060. Status: NEAR_END_DISCONNECT. Transfer error. Session stopped
05:10:00.437|3272|(0):Error! Module '3CX.com.OSBinet'. Error ID 219. URL_ttp://localhost:5484/(S(qsoe3rvwdyx50p55pue3o045))/CellsAgent_Debug_64/GetAgentPhone_MF_dbGetNumbersForProperty_DoIt.aspx?dataSource=&database=cellsagent.com&parameterCount=1&parameter_0=&password=8Trh76&server=TFS2%5CSQLEXPRESS&userName=cellsagent.comMethodGETError-500
05:10:00.437|3272|(0):Error! Module '3CX.com.OSBinet'. Error ID 204. rc2
05:10:00.437|3272|(0):Error! Module '3CX.com.vxi'. Error ID 203. uriGetAgentPhone_MF_dbGetNumbersForProperty_DoIt.aspx
05:10:02.171|3272|.\api\VXItelImpl.cpp(148):IvrDll, VXItelImpl::Impl::IntrnTransfer(), Error! Error of 'From_8019387712_To_856_Menu_856_#1/46' session transferring to sip:[email protected]:5060. Status: NEAR_END_DISCONNECT. Transfer error. Session stopped
07:07:08.640|0224|.\PbxMedia\IVREngine.cpp(883):IvrService, IVREngine::RegisterLines(), Registering of lines...127.0.0.1:5060127.0.0.1:5060999[800,856][401,402][MakeCall]
07:07:08.640|0224|.\PbxMedia\IVREngine.cpp(1036):IvrService, IVREngine::RegisterLines(), Registering of lines done.
07:08:43.640|0224|.\PbxMedia\IVREngine.cpp(883):IvrService, IVREngine::RegisterLines(), Registering of lines...127.0.0.1:5060127.0.0.1:5060999[800,856][401,402][MakeCall]
07:08:43.640|0224|.\PbxMedia\IVREngine.cpp(1036):IvrService, IVREngine::RegisterLines(), Registering of lines done.
07:09:00.015|4340|(0):Error! Module '3CX.com.OSBinet'. Error ID 302. URL_ttp://localhost:5484/(S(1lyc5mqbbqvbwtiexojtwiij))/dr.aspx?dr=800&to=800&from=8019387712
07:09:06.734|4340|.\api\VXItelImpl.cpp(148):IvrDll, VXItelImpl::Impl::IntrnTransfer(), Error! Error of 'From_8019387712_To_800_Menu_800_#0/48' session transferring to sip:[email protected]:5060. Status: NEAR_END_DISCONNECT. Transfer error. Session stopped
07:09:14.656|0772|(0):Error! Module '3CX.com.OSBinet'. Error ID 219. URL_ttp://localhost:5484/(S(ubvoqq55yrosa3qngrmrvnmk))/CellsAgent_Debug_66/GetAgentPhone_MF_dbGetNumbersForProperty_DoIt.aspx?dataSource=&database=cellsagent.com&parameterCount=1&parameter_0=100650&password=8Trh76&server=TFS2%5CSQLEXPRESS&userName=cellsagent.comMethodGETError-500
07:09:14.656|0772|(0):Error! Module '3CX.com.OSBinet'. Error ID 204. rc2
07:09:14.656|0772|(0):Error! Module '3CX.com.vxi'. Error ID 203. uriGetAgentPhone_MF_dbGetNumbersForProperty_DoIt.aspx
07:09:16.406|0772|.\api\VXItelImpl.cpp(148):IvrDll, VXItelImpl::Impl::IntrnTransfer(), Error! Error of 'From_8019387712_To_856_Menu_856_#1/49' session transferring to sip:[email protected]:5060. Status: NEAR_END_DISCONNECT. Transfer error. Session stopped
07:43:34.796|0224|.\PbxMedia\IVREngine.cpp(883):IvrService, IVREngine::RegisterLines(), Registering of lines...127.0.0.1:5060127.0.0.1:5060999[800,856][401,402][MakeCall]
07:43:34.796|0224|.\PbxMedia\IVREngine.cpp(1036):IvrService, IVREngine::RegisterLines(), Registering of lines done.
07:44:22.734|5040|(0):Error! Module '3CX.com.OSBinet'. Error ID 302. URL_ttp://localhost:5484/(S(qgvtij24utegib45erzimd45))/dr.aspx?dr=800&to=800&from=8019387712
07:44:30.828|5040|.\api\VXItelImpl.cpp(148):IvrDll, VXItelImpl::Impl::IntrnTransfer(), Error! Error of 'From_8019387712_To_800_Menu_800_#0/51' session transferring to sip:[email protected]:5060. Status: NEAR_END_DISCONNECT. Transfer error. Session stopped
07:44:38.609|5108|(0):Error! Module '3CX.com.OSBinet'. Error ID 219. URL_ttp://localhost:5484/(S(jsjtem45poaimi2fre5lra55))/CellsAgent_Debug_67/GetAgentPhone_MF_dbGetNumbersForProperty_DoIt.aspx?dataSource=&database=cellsagent.com&parameterCount=1&parameter_0=&password=8Trh76&server=TFS2%5CSQLEXPRESS&userName=cellsagent.comMethodGETError-500
07:44:38.609|5108|(0):Error! Module '3CX.com.OSBinet'. Error ID 204. rc2
07:44:38.609|5108|(0):Error! Module '3CX.com.vxi'. Error ID 203. uriGetAgentPhone_MF_dbGetNumbersForProperty_DoIt.aspx
07:44:40.406|5108|.\api\VXItelImpl.cpp(148):IvrDll, VXItelImpl::Impl::IntrnTransfer(), Error! Error of 'From_8019387712_To_856_Menu_856_#1/52' session transferring to sip:[email protected]:5060. Status: NEAR_END_DISCONNECT. Transfer error. Session stopped

 

[VAD_Support]

It is usually under C:\Documents and Settings\All Users\Application Data\3CX\Data\Logs

 

[SWSDEV]

ok, I just posted the log above in my last message.

 

[VAD_Support]

Hi,

This seems to be the problem related to the newline character in the SQL statement. Try removing that newline. We'll fix that in the next release.