Author Topic: GVP _ Problem when inserting records to a DB  (Read 3632 times)

Offline GenesysNewbie

  • Full Member
  • ***
  • Posts: 225
  • Karma: -1
GVP _ Problem when inserting records to a DB
« on: December 23, 2009, 04:56:12 AM »
Hi guyz, i am performing several inserts on a SQL SErver2000 BD, i am using teh GVP Studio objects.

However, when i launch 25 or 30 it fails. (i test with 20 call and its ok)
i am getting several error logs about bad fetch issue(error 500).

I think its concurrency.


Is GVP capable to deal with this inserting db functionality for several calls?????

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: GVP _ Problem when inserting records to a DB
« Reply #1 on: December 23, 2009, 12:45:39 PM »
Hi,

What kind of web server do you use (IIS, Apache etc.)? It might be issue on web server side rather then on GVP as VXML pages are generated and communication with database is done on web server side.

R.

Offline GenesysNewbie

  • Full Member
  • ***
  • Posts: 225
  • Karma: -1
Re: GVP _ Problem when inserting records to a DB
« Reply #2 on: December 23, 2009, 07:26:58 PM »
IIS 6.0.



I never see a iis best practice genesys doc for GVP....Do u?


Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Re: GVP _ Problem when inserting records to a DB
« Reply #3 on: December 23, 2009, 07:42:54 PM »
In GVP Deployment guide are configurations and settings recommendations for IIS, have you done them?
What does the webserver issues as the origin for that 500 error?

Offline GenesysNewbie

  • Full Member
  • ***
  • Posts: 225
  • Karma: -1
Re: GVP _ Problem when inserting records to a DB
« Reply #4 on: December 23, 2009, 09:10:00 PM »
hi cav i dont see a specific recommendation for my problem...please, maybe u can point one if its possible.
I review teh guide twice...

Hoping any kind of recoomendation =)

Juan Perez

  • Guest
Re: GVP _ Problem when inserting records to a DB
« Reply #5 on: December 28, 2009, 06:11:32 AM »
Can you paste the code in the forum, to review that...

Offline GenesysNewbie

  • Full Member
  • ***
  • Posts: 225
  • Karma: -1
Re: GVP _ Problem when inserting records to a DB
« Reply #6 on: December 28, 2009, 07:10:45 PM »
hi guyz, Rene was rigth,

it was a DB issue. Thanks for all ur help.