View Single Post
  #6  
Old 10-26-2015, 08:41 AM
verma62 verma62 is offline
Brainiac
 
Join Date: Apr 2015
Posts: 59
verma62 has 10 reputation points
Default

Dear Kruegerb,

Thanks for your response, you always come to our rescue whenever we face serious problem with IPOCC.

Regarding the database error, we are using IPOCC over windows 2012 server. I have successfully created the ODBC driver 32 bit to get connected with MSSQL database, after the configuration when I do the test connection it executes without any issues.

Now same driver I am using in IPOCC IVR script and able to fetch/insert values from database. However after some time(I don't have definite time interval) we started facing exceptions in IVR whenever we do database operation. But when I again configure the ODBC driver with passing the username and pwd, and do test connection this issue is resolved for some time

Below are the logs for your reference

E5089v 15:24:00.579 TC_General [0x00005E34] VUS_Element::ElemTrace(Retrieved Choice Id from data,Survey-demo,0x375B1AE0,0,0x2C8E6)::run(0xD353015611010000 ) Retrieved ChoiceId- 21, For QuestionId-7, DTMF -5
E5090v 15:24:00.581 TC_Warning [0x00005E34] DB_Connection::getNumberOfRows(Snug-Survey-db,db_user,75654672) Error: 24000
E5091v 15:24:00.581 TC_Warning [0x00005E34] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
E5092v 15:24:00.581 TC_General [0x00005E34] VUS_Element::ElemTrace(Decresing Question Counter,Survey-demo,0x375B1AE0,0,0x2C8E6)::run(0xD353015611010A00 ) Decresing the value of question counter, new value - 4
E5749v 15:24:04.420 TC_General [0x00005E34] VUS_Element::ElemTrace(Retrieved Choice Id from data,Survey-demo,0x375B1AE0,0,0x2C8E6)::run(0xD353015611010000 ) Retrieved ChoiceId- 28, For QuestionId-8, DTMF -3
E5750v 15:24:04.422 TC_Warning [0x00005E34] DB_Connection::getNumberOfRows(Snug-Survey-db,db_user,75655552) Error: 24000
E5751v 15:24:04.422 TC_Warning [0x00005E34] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
E5752v 15:24:04.422 TC_General [0x00005E34] VUS_Element::ElemTrace(Decresing Question Counter,Survey-demo,0x375B1AE0,0,0x2C8E6)::run(0xD353015611010A00 ) Decresing the value of question counter, new value - 3
E5763v 15:24:08.959 TC_General [0x00005E34] VUS_Element::ElemTrace(Retrieved Choice Id from data,Survey-demo,0x375B1AE0,0,0x2C8E6)::run(0xD353015611010000 ) Retrieved ChoiceId- 32, For QuestionId-9, DTMF -4
E5764v 15:24:08.961 TC_Warning [0x00005E34] DB_Connection::getNumberOfRows(Snug-Survey-db,db_user,17359480) Error: 24000
E5765v 15:24:08.961 TC_Warning [0x00005E34] [Microsoft][ODBC SQL Server Driver]Invalid cursor state



I checked the "Invalid cursor state" in Microsoft blogs and found this a known issues while using ODBC drivers, don't know how to overcome this.

Just for information at the same time I am using custom made connectors which are interacting with same database server and there the queries are getting successfully ecxectued. Checked this with both Java code and Visual c# code.
Reply With Quote